View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vrzimmerm@hotmail.com is offline
external usenet poster
 
Posts: 28
Default Opening .xls files

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.