| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a form to select files from
In Excel VBA, I want to set up a small form for selecting a file from a folder full of files. I tried using some VB code I had in another project and it didn't work. Any ideas or suggestions out there? Thanks!! -- greaseman ------------------------------------------------------------------------ greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808 View this thread: http://www.excelforum.com/showthread...hreadid=531671 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set up a form to select files from
Take a look at GetOpenFilename in VBA Help.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "greaseman" wrote in message ... In Excel VBA, I want to set up a small form for selecting a file from a folder full of files. I tried using some VB code I had in another project and it didn't work. Any ideas or suggestions out there? Thanks!! -- greaseman ------------------------------------------------------------------------ greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808 View this thread: http://www.excelforum.com/showthread...hreadid=531671 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set up a form to select files from
Try code like the following:
Dim FName As Variant FName = Application.GetOpenFilename("Excel files *.xls,*.xls", , "Select A File") If FName = False Then ' no file selected Else MsgBox FName End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "greaseman" wrote in message ... In Excel VBA, I want to set up a small form for selecting a file from a folder full of files. I tried using some VB code I had in another project and it didn't work. Any ideas or suggestions out there? Thanks!! -- greaseman ------------------------------------------------------------------------ greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808 View this thread: http://www.excelforum.com/showthread...hreadid=531671 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set up a form to select files from
And again, thank you both for your assistance! I'll give your suggestions a try in the morning, since it's about the end of my work day. Have a great dat! -- greaseman ------------------------------------------------------------------------ greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808 View this thread: http://www.excelforum.com/showthread...hreadid=531671 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you get outlook to select from list on a form | Excel Discussion (Misc queries) | |||
| Form Button - Select Row | Excel Programming | |||
| list related files, select which to open form | Excel Programming | |||
| Select all/Deselect all button in a form | Excel Programming | |||
| My First User Form - How to Select Range(s) and Print | Excel Programming | |||
![greaseman[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
