Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace help solution?
Hi, I'm relatively new to macros and would like some help. I have
roughly 50 sheets of information that are delivered from an external source to 50 separate specific directory. I simply have the directory path but need to change the date part of the path.........ie "...........200702 ..............." i need to change that part of the text string to reflect the previous month to the current one ie march now, need to do February. I can do the part that opens up the path but changing the path every month when the month changes is the tricky bit - i thought Find and replace from a specific cell that I have created to bring up last months date and the format i need yyyymm but i'm finding it difficult. Any suggestions on this or ideas as to changing part of a text string every month automatically. I don't want to ask users to define the file that needs to be opened as there are 50+. Regards, Boots |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting #DIV/O. Can't find a solution | Excel Discussion (Misc queries) | |||
I can't find the solution to my problem... | Excel Programming | |||
sum if problem, trying to find best solution | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
please find a solution | Excel Discussion (Misc queries) |