Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update from file?
Hello all.
I just stumbled across updateFromFile command today while looking for something else. I've read the Excel Help printout on it, and it appears that I want to do something that is the opposite of how I'm understanding UpdateFromFile to be explained. I have a large file with some 70 pages of data in it. Let's call it A.xlsx The data in this file has been processed, and is accurate. I want to have a macro that looks at another location-- say //Jones/Home/Master/ -- at read only files. If any of the read only files are more recent than the A.xlsx file-- have been modified more recently than the read only files-- there are a total of some 780 files, and I only want to look at a specific range of them-- #230 through #270. If these files are more recently modified than A.xlsx, then I want to copy two of the worksheets into A.xlsx from each of the read only files that are newer. If I understand UpdateFromFile correctly, it updates the read only files, and leaves the source files alone. But the Read only, and source files are the same file. What I'm interested in is modifying two distinct file groups. Does this make sense? Thank you. Best. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update the hyperlink in file after changing the file name | Excel Worksheet Functions | |||
Macro to pull data from another file - update name of file | Excel Discussion (Misc queries) | |||
i want to update one excel file the other one update automaticaly | New Users to Excel | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) | |||
Automate open file, update links, run macro, close and save file | Excel Programming |