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 File open - .xls not recognized as spreadsheet

I'm trying to write a macro where the first step is to turn control
over to the user to specify a spreadsheet file that is to be opened.
I am using the "Application.GetOpenFilename" command to do this.

It seems that even tho the file to be opened is a .xls file Excel
doesn't recognize it as a spreadsheet - it seems to treat this as a
text file. (Note: when I try to open this same .xls file Excel
responds by opening the Text Import Wizard window. Proceeding using
the default options then works fine.) How can I have the macro
proceed with the opening of the specified file by recognizing tabs as
the delimiter between the columns?