Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Opening a file with code without a set file name
Hi all and thanks in advance for any help. I have excel workbooks that are produced on a daily bases by another program. The data layout is the same for each day produced except for the file name. What im having to do now is rename the file every day and then run my other code to clean it up and import the data into my new workbook. The code that i use works great but would like to be able to fix it so it doesn't matter what the file name is, so that others won't have to remember to change the name before they run the cleanup code. Any ideas. Thanks, Pat -- jenkinspat |
#2
|
|||
|
|||
Hi
it would probably help if we could see the code, if you'ld like to copy & paste it (or at least the bit where the file name is referenced) in a reply this would give us a starting point ... and also to know where you run the code from - is it stored in personal and run via tools / macro / macros in the newly created workbook or ?? Cheers JulieD "jenkinspat" wrote in message . .. Hi all and thanks in advance for any help. I have excel workbooks that are produced on a daily bases by another program. The data layout is the same for each day produced except for the file name. What im having to do now is rename the file every day and then run my other code to clean it up and import the data into my new workbook. The code that i use works great but would like to be able to fix it so it doesn't matter what the file name is, so that others won't have to remember to change the name before they run the cleanup code. Any ideas. Thanks, Pat -- jenkinspat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening file problem please help | Excel Discussion (Misc queries) | |||
Opening a file with a Macro | Excel Discussion (Misc queries) | |||
Opening CSV file in Excel 97 | Excel Discussion (Misc queries) | |||
restrict opening Excel file residing on a shared drive to one user | Excel Discussion (Misc queries) | |||
Problem opening an XML file in Excel - getting "ns1:macrosPresent" | Excel Discussion (Misc queries) |