I have a tool I've been developing, and basically when you run it for the first time, it asks you to point to a save location (which it then uses in future when making different files and saving different things).
My end user is getting an error on one of the save as commands. Here is the issue step by step:
Full path saved for useis: \\nzsrv01\companynz\CompanyShared\CLIENT RATES & INFORMATION\I\ICEBREAKER\CT BOOKINGS\2_SPO\SPO Masters\11.10_GHF
When the user runs the code this happens:
Debugging to this line of code:
You see its just a save as command. Now this works perfectly if the installpath (which is the full unc path listed above in this case) is a normal like "C:\Blah" path. But it seems to be throwing this error due to the unc network path, even though as far as I know Excel vba should accept these paths.
Any ideas/tests I can do to figure this out.
I know I could map the network drive, but eventually multiple users will be using this so would rather avoid having the users do any mapping etc.