Great Minds think alike! :O

Gary Brown

"smw226 via OfficeKB.com" wrote:

Evening Tim,

I am not sure of the easiest way to re-reference your spreadsheets, BUT...

Why don't you have the reference set to SICK_CURRENT and have your scheduler
create 2 copies, one with the date and the other called SICK_CURRENT?

HTH

Simon

TimN wrote:
Every two weeks I have a Business Objects query set on a scheduler to
refresh. It then saves to an Excel file in a defined location named like
SICK_10_15_06.xls. That file contains the most current list of employees and
their available sick hours. Every 2 weeks this query refreshes and saves a
new file with the most current data such as SICK_10_29_06.xls.
I have in addition another excel file that has multiple VLOOKUP formulas
that link to the above mentioned file in order to pull in the employee name
and sick hours available.
My question is how can I get my VLOOKUP formula to link to the most current
excel file? Initially it would be linked to SICK_10_15_06.xls, but when
SICK_10_29_06.xls is created, I want my VLOOKUP to switch to that file.

Any ideas on how to get there?

Thanks!

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com