sourabh_ajmera
New Member
- Joined
- Jul 17, 2014
- Messages
- 36
Hello,
I have doubt that I had been trying to find a solution for a long time. I want to open a specific folder while the browse option is in action to prompt user to select a file to open.
I have tried the following code but the problem is its open up desktop or the last opened folder. I always want to prompt folder ABC (Location: Desktop/ABC) as a first choice for user to select file from?
I dont know if the above statement explains my question or not. Please let me know if you have any doubt or queries.
Thank you in advance
I have doubt that I had been trying to find a solution for a long time. I want to open a specific folder while the browse option is in action to prompt user to select a file to open.
I have tried the following code but the problem is its open up desktop or the last opened folder. I always want to prompt folder ABC (Location: Desktop/ABC) as a first choice for user to select file from?
Code:
Sub test()
MsgBox "Choose Your Source File to Open"
Source = Application.GetOpenFilename()
If Source = "False" Then Exit Sub
Workbooks.Open Source
End Sub
I dont know if the above statement explains my question or not. Please let me know if you have any doubt or queries.
Thank you in advance
Last edited: