| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I bring up the brose pop-up screen with VBA?
Hello,
I want to use the BVA code to bring up the brose pop-up screen (this the same screen that when we click on "Open" file to brose the file to open). After user brose and select the file, I want to capture that file name. Can anyone help me with this? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I bring up the brose pop-up screen with VBA?
Ty this
Dim str As String str = Application.GetOpenFilename This does not open the file but rather just retuns the name and path of the selected file... -- HTH... Jim Thomlinson "Richard" wrote: Hello, I want to use the BVA code to bring up the brose pop-up screen (this the same screen that when we click on "Open" file to brose the file to open). After user brose and select the file, I want to capture that file name. Can anyone help me with this? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I bring up the brose pop-up screen with VBA?
fname = Application.GetOpenFileName() if fName < False tthen msgbox "You chose " & fname End if See Excel VBA help of GetOpenFilename for additional arguments. Regards, Tom Ogilvy "Richard" wrote: Hello, I want to use the BVA code to bring up the brose pop-up screen (this the same screen that when we click on "Open" file to brose the file to open). After user brose and select the file, I want to capture that file name. Can anyone help me with this? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I bring up the brose pop-up screen with VBA?
Thank you.
"Tom Ogilvy" wrote: fname = Application.GetOpenFileName() if fName < False tthen msgbox "You chose " & fname End if See Excel VBA help of GetOpenFilename for additional arguments. Regards, Tom Ogilvy "Richard" wrote: Hello, I want to use the BVA code to bring up the brose pop-up screen (this the same screen that when we click on "Open" file to brose the file to open). After user brose and select the file, I want to capture that file name. Can anyone help me with this? Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I bring up the brose pop-up screen with VBA?
Thank you Jim
"Jim Thomlinson" wrote: Ty this Dim str As String str = Application.GetOpenFilename This does not open the file but rather just retuns the name and path of the selected file... -- HTH... Jim Thomlinson "Richard" wrote: Hello, I want to use the BVA code to bring up the brose pop-up screen (this the same screen that when we click on "Open" file to brose the file to open). After user brose and select the file, I want to capture that file name. Can anyone help me with this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save as bring up full screen how do I get back to normal size | Excel Discussion (Misc queries) | |||
| Inputbox Location on Screen. Can you code it to popup lower on the screen ? | Excel Programming | |||
| print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
| Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
| How to copy data from excel to power point screen by screen? | Excel Programming | |||
Linear Mode
