VBA, Opening a File Open window for file selection in VBA

Opening a File Open window for file selection in VBA

Author	Message
Alex Laure #1 / 3	Opening a File Open window for file selection in VBA I am a novice VBA programmer and I am having trouble on the following: I need a form to pop up in Excel to ask the user to select a file. That filename will then be used as a hyperlink in a specific cell. I can get a pop up to come up that asks the user for a straight filename, but when the file they are looking for is embedded in 5,6 or 7 subdirectories, I can't expect them to remember the exact path verbatim. So, I need to open up a File Open pop up box and then store that filename in a hyperlink. Any help would be greatly appreciated. Thanks Alex
Sat, 23 Oct 2004 23:17:12 GMT

Chirag Dala #2 / 3	Opening a File Open window for file selection in VBA Alex, Look at http://officerone.tripod.com/ (VBA Section). I have got an example on how to use Common Dialogs ActiveX control for showing File Open dialogbox. - Chirag Quote: > I am a novice VBA programmer and I am having trouble on > the following: > I need a form to pop up in Excel to ask the user to select > a file. That filename will then be used as a hyperlink in > a specific cell. I can get a pop up to come up that asks > the user for a straight filename, but when the file they > are looking for is embedded in 5,6 or 7 subdirectories, I > can't expect them to remember the exact path verbatim. > So, I need to open up a File Open pop up box and then > store that filename in a hyperlink. > Any help would be greatly appreciated. > Thanks > Alex
Sun, 24 Oct 2004 00:39:41 GMT

Stephen Bulle #3 / 3	Opening a File Open window for file selection in VBA Hi Alex, Quote: > I need a form to pop up in Excel to ask the user to select > a file. Take a look at Application.GetOpenFilename in Excel's VBA help. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk
Mon, 25 Oct 2004 06:38:42 GMT

Page 1 of 1

[ 3 post ]