Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Open File Name
Hi,
I am trying to open a file from a folder but at the moment, not havin much sucess. I have written the following VB code: fileToOpen = Application _ .GetOpenFilename("Text Files (*.txt), *.txt") If fileToOpen < False Then MsgBox "Open " & fileToOpen End If However, this only allows me to select Text Files and I am mainl interested in .xls files. I have managed to get the folder box open bu I cannot open any Excel files. Have I missed something out? If there is any one who can help me in my quest, that would be cool. Thanks Kiz -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Open File Name
Try
fileToOpen = Application _ .GetOpenFilename("ExcelFiles (*.xls), *.xls") If fileToOpen < False Then MsgBox "Open " & fileToOpen End I -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |