LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show most recent files first when opening excel files Anne` Excel Discussion (Misc queries) 5 January 23rd 08 01:54 AM
Several files opening at once Buck[_2_] Setting up and Configuration of Excel 1 December 20th 07 08:57 AM
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 PoundMutt Excel Discussion (Misc queries) 1 June 20th 07 03:50 AM
How can I view files chronologically when opening multiple files Stevilsize Excel Discussion (Misc queries) 3 July 26th 05 12:49 AM
Opening Files Dave[_32_] Excel Programming 2 October 16th 03 06:25 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"