Search:

Just goes to show you, play around long enough you can figure it out.

this is a "duh" moment

=E16>(D16+7)

Regards,
Brad

Hey folks!

Got a conditional formula needed. Basically, I need to have a formula to do the following:

Cell D16 contains a date.
Cell E16 contains a date.

Need to conditionally format based...

Kept getting an error with the formula. Discovered the extra (. Removed and works great


Thanks,
Brad

Ok, that works good. Now, how about the other direction?

I have another column where I need to see only the info after the "> I have already stripped the </OPTION>.



0000">0000 -...

Hey folks!

I have a situation where I had to import a selection list of data (from HTML). It is all formatted as follows:

the second set of 0000 will be alpha and or numeric. I need to delete...

Thanks!

I put the macro into the personal macro workbook. Works great! and I put the icon in the quick access bar.

Going forward, I think I may develop an Add-in with multiple things. I...

I am using Excel 2007, and would like to have a certain macro always be available when I start Excel.

What are the steps? I cannot seem to find the equiv. of personal.xls....



Thanks,
Brad

These are a variety of files.

I am going to keep plugging away. They appear to have been in the recycle bin, but not sure.

Thanks,
Brad

hey everyone!

I have used a few pgrms to cleanup the free-space, wipe the free space etc. mainly I am using East-Tec 2010. However, I am seeing some persistent files not being over written, thus...

Hi Folks,

I am running Vista Home Premium 64bit. I used to have Bitdefender 2009 Internet security. I opted to upgrade to the Bit Defender Total Security 2010. Now here is the situation. ...

Talk about a "duh" moment....

Changed the Range statement to be "Q:Q" and all is fine...

Talk about easy...

Thanks
Brad

I see that, but I think we need to test for cell content or not. If not content, then continue looking. When cell has content, then perform actions. Continue until cells in range have been looked...

Hey folks!

I am back!!! I happen to work with the originator of this thread, and we have a "almost" solution to the problem, however there is one thing causing issues.

Background:
The issue...

Ok... I will go back at it and try those things you describe.



Will reply with the outcome.


Thanks,
Brad

Steve,

On Directories less than 65536 lines, I do get everything. I did put the Option Explicit, but the Macro then failed.

Like I said earlier, I ran your updated code against the huge...

OK. I could not determine why it does not complete the listing on the final worksheet that gets created.

Steve,

Any Ideas?


Thanks,
Brad

Ok, well, this is working to a degree.

The first time I ran the code "AS IS", I got the tool to report the amount of files I am getting.. IE: the dialog box racks up to the expected result,...

Steve,

Thanks! I will begin digesting this and reply with any success/issues.

Appreciate the help and tips,


BRad

Ummmmm Good answer, However that is not an option at my current worksite. Only have Excel 2003.

Anyone solve this and I shall toast one to them !

Greetings all!

I have been out of the forum for a little while, but I am back! I have inheirted a Directory listing Workbook. It does exactly what is needed, EXCEPT
it will not carry over the...

Wow, I did not realize the difference...


Jan,
How ....where.... does this code go? The other code was in the "this workbook" area.



Thanks,

Greetings,

Well, the below code was written for Excel 2003. Basically, it created a dropdown menu, that always was placed on the bottom of the toolbar at the left.

Well, I moved up to Excel...

Hans,


Thanks! Seems to be a good one. (and freeeeee)



Thanks!

BRad

Greetings!

I am running Vista (64), and am looking for recommendations regarding software to generate listings of the files/folders on my system. Would also like to save as different file types....

Hey all,
Took a little break. Thanks for all the input. Will give them a try!



Thanks,
Brad