Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm writing a macro that, as a first step, allows the user to open a
spreadsheet file of his/her choice. I am using " Application.GetOpenFilename" to do this. Even tho the files the user will open are .xls file types Excel seems to interpret them as text files. (Whenever I try to manually open one of them Excel's Text Import Wizard opens.) How do I write a macro that will enable Excel to open these files once the user has selected the specific .xls file? (Note: accepting all the defaults in the Text Import Wizard results in a properly formatted spreadsheet.) Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
Several files opening at once | Setting up and Configuration of Excel | |||
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Opening Files | Excel Programming |