S
ssbsparky
Here is a little background on what I am trying to do... I have a bunc
of Excel files that are working together to make a timesheet program.
The files used to pull info from disks, but now I am trying to pul
from a network with each set of files in a different dirrectory for
different month. It used to pull the files like this...
='A:\[AM1wk.xls]SOD'!$F$10+'A:\[AM2wk.xls]SOD'!$F$10+'A:\[AM3wk.xls]SOD'!$F$10+'A:\[AM4wk.xls]SOD'!$F$10+'A:\[AM5wk.xls]SOD'!$F$10
Now I need A:\ to be more like M:\Timesheet\Ag\1\
with 1 being a variable number from 1 - 12.
I tried somethin like this...
="M:\Timesheet\Ag\" & [DOWNLOAD.XLS]Agdl!$I$25 &"\"
[DOWNLOAD.XLS]Agdl!$I$25 is the spot I can pull the month from, bu
this is taken as just text by excell
I have even tried setting up a cell to have everything but the filenam
in there so I can put =A2 & [AM2wk.xls]SOD'!$F$10 but that doesnt wor
either.
Is there a way in Excell to point to a specific file that will alway
be the same name but will always be in a different directory dependan
on a cell in another file.
So I have 3 Files... #1 reads the info off #2 (which change
dirrectorys dependant on the month) and #1 gets the month from a Cel
in #3 which is opening #1and telling it to update from the file in #
(actually 5 files for #2 but trying to make this simple)
Any help would be greatly appreciated
Spark
of Excel files that are working together to make a timesheet program.
The files used to pull info from disks, but now I am trying to pul
from a network with each set of files in a different dirrectory for
different month. It used to pull the files like this...
='A:\[AM1wk.xls]SOD'!$F$10+'A:\[AM2wk.xls]SOD'!$F$10+'A:\[AM3wk.xls]SOD'!$F$10+'A:\[AM4wk.xls]SOD'!$F$10+'A:\[AM5wk.xls]SOD'!$F$10
Now I need A:\ to be more like M:\Timesheet\Ag\1\
with 1 being a variable number from 1 - 12.
I tried somethin like this...
="M:\Timesheet\Ag\" & [DOWNLOAD.XLS]Agdl!$I$25 &"\"
[DOWNLOAD.XLS]Agdl!$I$25 is the spot I can pull the month from, bu
this is taken as just text by excell
I have even tried setting up a cell to have everything but the filenam
in there so I can put =A2 & [AM2wk.xls]SOD'!$F$10 but that doesnt wor
either.
Is there a way in Excell to point to a specific file that will alway
be the same name but will always be in a different directory dependan
on a cell in another file.
So I have 3 Files... #1 reads the info off #2 (which change
dirrectorys dependant on the month) and #1 gets the month from a Cel
in #3 which is opening #1and telling it to update from the file in #
(actually 5 files for #2 but trying to make this simple)
Any help would be greatly appreciated
Spark