ExcelChampion
Well-known Member
- Joined
- Aug 12, 2005
- Messages
- 976
I'm trying to open to a default folder but its not working and I have no idea why...
I've played with my code, but it keeps opening to the System32 folder on the Windows folder.
I'm in Access, and use this code to create an instance of Excel, and then prompt the user to open an Excel file.
Any ideas?
FYI, everything is on my local drive.
I've played with my code, but it keeps opening to the System32 folder on the Windows folder.
I'm in Access, and use this code to create an instance of Excel, and then prompt the user to open an Excel file.
Code:
CurrProject_Path = CurrentProject.Path
Set xlApp = CreateObject("Excel.Application")
With xlApp
ChDrive CurrProject_Path
ChDir CurrProject_Path
strPathFile = .GetOpenFilename("Excel Files (*.xls*), *.xls*")
Any ideas?
FYI, everything is on my local drive.
Last edited: