I have an Excel macro that runs when a spreadsheet opens and I want it to give an open file message box that is pointing to a network drive where some csv files are stored. My problem is that the open box defaults to the last folder opened and I have not been able to change it to the network drive.
Here is what I have tried, but none are working:
How can I get the Open file dialog to point to the network directtory?
Here is what I have tried, but none are working:
Code:
ChDir "//Hmm04\Shared\CSV\Daily Reports"
Filename = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
Code:
InitDir = "//Hmm04\Shared\CSV\Daily Reports"
Filename = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
Code:
ChDrive "//Hmm04\Shared"
ChDir "//Hmm04\Shared\CSV\Daily Reports"
Filename = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
How can I get the Open file dialog to point to the network directtory?