Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 102
Default Importing files

I couldn't reproduce your problem, but have you tried putting
Application.DisplayAlerts = False somewhere at the start of your code???

Otherwise it may help to post the suspect code.

Dan E

"Nick" wrote in message
...
I am importing txt files from another program which end
with the suffix .1

Excel complains that it doesn't recognise the file but
gives you the option of continuing. When you click OK the
macro works fine.

Unfortunately I have to open maybe 20 of these files and
each new file requests whether it should be opened.

Is it possible to disable this request so that Excel opens
the files on its own?

I am using Excel 2000 and the Workbooks.OpenText function
to open th files.

Any help would be much appreciated.



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Importing files

Your solution worked perfectly

Thank you.
Reply
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
importing .prn files jroth Excel Discussion (Misc queries) 2 May 20th 08 03:09 PM
Importing CSV files nnappy Excel Discussion (Misc queries) 1 June 19th 06 06:42 PM
importing csv files joelb Excel Discussion (Misc queries) 2 June 7th 06 04:53 PM
Importing files stina Excel Discussion (Misc queries) 3 March 29th 06 11:14 AM
Importing CSV files Chris Excel Discussion (Misc queries) 4 June 22nd 05 03:02 PM


All times are GMT +1. The time now is 02:34 PM.

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

About Us

"It's about Microsoft Excel"