Using Macros to write Links
I am attempting to write a macro that will link to a file on a server.
Several portions of the path are variables so that the user can input
specific dates.
The path is quite long:
\\USPSPS01\E-MOMO\...\Line 1\...\[L1 21 2009.xls]1ST SHIFT'!$I$20
If I screwed up the syntax, its because I'm working from memory...
Here's the problem...each time the macro runs, I get a file explorer window
and I have to point to the file. The problem is, I have some 216 links that I
want to write!
If input the formula in the form ='\\USPS.... then I get the data without
pointing, but use the macro to write the formula and I have to point to
it...is there no way to do this in Excel. I know there's a way in Access, but
I am not familiar with Access!
Thanks!
|