| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map drive to open a file with code
The drive doesn't need to be mapped to a letter if you refer to it by its UNC
path. Try recording a macro when you open the file manually using that UNC path. Maybe you mistyped something in the code and the recorded macro will help you find it. Les Stout wrote: Hello Dave, this drive is not mapped in all cases... I tried your suggestion but it does not find the file and it is there. If i map the drive then it works fine but that is the initial problem... Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From share drive particular excel file takes long time to open | Excel Discussion (Misc queries) | |||
| format Excel to open in particular drive/file | Excel Discussion (Misc queries) | |||
| When I save a file on the hard-drive, it is fine, I can re-open, | Excel Discussion (Misc queries) | |||
| WINDOWS CANNOT OPEN THIS FILE IN A:\ DRIVE | Excel Discussion (Misc queries) | |||
| How do I open a file from a Network drive using Excel VBA? | Excel Programming | |||
Threaded Mode
