Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening filenames from a list in a spreadsheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re-sort list when opening spreadsheet | Excel Discussion (Misc queries) | |||
Help with opening variable filenames | Excel Programming | |||
Error opening files from a list in a spreadsheet | Excel Programming | |||
Getting a list of filenames | Excel Programming | |||
Getting a list of filenames | Excel Programming |