You can only run the macro when the files exist
No way to link to a file that not exist

The macro create very fast the links for when you need them

--
Regards Ron de Bruin
http://www.rondebruin.nl



"jrm" wrote in message ...
what would such a macro look like? Since the files ren't created yet, how
would the macro I write now, find the file that won't exist until tomorrow?

"Ron de Bruin" wrote:

No but maybe you can use a macro to create links to certain cells in files in a folder
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"jrm" wrote in message ...
Hello friends,

Every morning our finance department creates a new spreadsheet for the
previous day's financials. I then take the information I need from the
spreadsheet and copy it over to new workbook that I keep upto date with my
departments daily numbers. I would love to "automate" this process by
settign up my spreadsheet to automatically link my department's sheet with
the appropriate cells on the finance department's sheet. The problem is
this: The finance reports are created new every morning, so there is no way
(that I know of) that I can tell my departmental spreadsheet to link to this
new document until it is created. the finance dept. creates this document in
the same folder every day and only changes the number at the end of the
report to reflect the date. This means that I can know the exact file path
for any day of the eyar so I could hypothetically setup my deptmental sheet
for the rest of the year. Is there a way to link the cells I need with a
document that doesn't yet exist? Does this make any sense?