Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prompt for file location and copy data
I have two data files that need to be copied each day to a job analysis
template. The location of the files changes with the months so I would want to open the directory location and have the user select the latest file(s). Each file has only one sheet, however, the name of the sheet is created by the financial program that created it and will change each day (same as file name). To simplify things I could use the same name each day and write over the old files. I need the whole of the contents of this sheet to be copied to a destination sheet in the template. One called "Jobs" and the other "JobEstimates". The JobEstimates sheet is very large (20-30 thousand rows). It also contains picture objects created by the program that produced it. I don't need to copy these and run a macro that selects and deletes them. The JobEstimates sheet also has numerical data in columns E, G, I & M represented as text. I use DataText to Columns to convert these each time I open it. Can I create a single macro that prompts for the new files copies the contents to the data sheets in the analysis file, changes text to data and strips the objects from one before it's copied? As always, any help is greatly appreciated. -- Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting rid of copy/overwrite prompt on Save | Excel Discussion (Misc queries) | |||
Using Macro to Save Copy of File to New Location | Excel Discussion (Misc queries) | |||
Import External Data Source File Location Changed | Excel Discussion (Misc queries) | |||
"Some of the files in this Web page aren't in the expected location." Prompt | Excel Discussion (Misc queries) | |||
Is there a way to setup excel to prompt for a backup copy upon ex. | Excel Discussion (Misc queries) |