Opening filenames from a list in a spread***


I am writing a program for use at a bunch of sites around the world. It
uses several SAP extracts that are to be stored on the C: drive of the
user in a specific location, in this case

C:\CABD\CABD.xls

Putting the Workbooks.Open Filename statement is easy enough when it is
always one location but several of the files will require having a
location that varies by site. I do not want to have to redo the code
for each site and each site has a different directory name (ex. Y: or
Q:). I know I need to use a string but am new to the world of strings.
I am not sure no the syntax necessary to make this work. Can any of
you experts out there point me in the right direction. The incorrect
code is stated below...

Dim CWDBXLS
CWDBXLS = '[CABD.xls]Local Data Copy!R46C5
Workbooks.Open Filename:=CWDBXLS


--
croney
------------------------------------------------------------------------
croney's Profile: http://www.officehelp.in/member.php?userid=5986
View this thread: http://www.officehelp.in/showthread.php?t=1318743

Posted from - http://www.officehelp.in

.