D
D. Olsen
I am working with a series of databases linking store product information
together for new stores. I use the TransferSpreasheet SQL to import specific
tables of information which we update regularly each time I run any other
Macros. This links to the specific path that the files reside on our server.
Each store has its own folder structure and we have to copy across the
databases new each time we start a new project. This results in broken links
to these files and the need to go into each macro and replace the File Name
field with the correct path.
I want to be able to write in a variable of some sort to link to the correct
path just based on the store name which is the first and only variable
portion of the path.
Here is an example of the path
Z:\PROJECT PLANNING\CP Logistics\026 - Canton\Raw Data
Where "026 - Canton" is the variable store name.
Thank you,
D. Olsen
together for new stores. I use the TransferSpreasheet SQL to import specific
tables of information which we update regularly each time I run any other
Macros. This links to the specific path that the files reside on our server.
Each store has its own folder structure and we have to copy across the
databases new each time we start a new project. This results in broken links
to these files and the need to go into each macro and replace the File Name
field with the correct path.
I want to be able to write in a variable of some sort to link to the correct
path just based on the store name which is the first and only variable
portion of the path.
Here is an example of the path
Z:\PROJECT PLANNING\CP Logistics\026 - Canton\Raw Data
Where "026 - Canton" is the variable store name.
Thank you,
D. Olsen