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

C:\CABD\CABD.xls

Putting the Workbooks.Open Filename statement is easy enough when it i
always one location but several of the files will require having
location that varies by site. I do not want to have to redo the cod
for each site and each site has a different directory name (ex. Y: o
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 o
you experts out there point me in the right direction. The incorrec
code is stated below...

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

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

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