Macro - Share with Users on a shared network drive
Without seeing your code it is hard to say. It could be security if the other
users do not have access to the file. More likely the other users might have
the drive mapped differently. Your "G" dirve might be different from other
users "G" drive. find out if the other users were to navigat to that file
what path would they follow.. There are remedies for this but lets see if
that is the problem first. Also... Post your code...
--
HTH...
Jim Thomlinson
"Vicki" wrote:
I wrote a macro in a workbook that refreshes data from an external file then
populates multiple spreadsheets. It is working very well for me at my
station, but won't run at other users' stations. The .CSV file that is being
read and imported in is in the same shared network folder where the workbook
is.
Why won't the macro run for the other users? Is there a security setting or
more code I need in my macro so they can run it.
|