Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing to Network Directory
I'm trying to create a macro, which when executed, will
display the "File Open" dialog box for Excel. However I want the dialog box to open up in a Network directory. The below macro executes just fine when tested in a blank workbook. When I add the code to the application I've created I can't seem to get to the Network directory. Can anyone recommend a solution or tell me why this macro isn't working? Given: The Network Workgroup is "Advantage". The Network computer name is "Advint01". The Network Drive is: "D:\" but displayed as "D Drive". The Operating System on the desktop is "Windows XP" The Operating System on the Network is "Windows 2000" The Excel Version is "2002" Code: Sub File_Open_Network() ' Uses the File Open dialog box for the Network ' directory where all estimate files are store ChDir "\\Advint01\D Drive\Quotes\Contracting" fileToOpen = Application.GetOpenFilename_ ("WorkSheets (*.xls), *.xls", , "Network Drive") End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colour changing within network | Excel Discussion (Misc queries) | |||
Unknown excel backup files created in network directory | Excel Discussion (Misc queries) | |||
How to change options for saving when old directory(network) gone | Setting up and Configuration of Excel | |||
Changing to different drive and directory | Excel Discussion (Misc queries) | |||
Saving files in the same network directory takes too long time!! | Setting up and Configuration of Excel |