Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing files
Your solution worked perfectly
Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing .prn files | Excel Discussion (Misc queries) | |||
Importing CSV files | Excel Discussion (Misc queries) | |||
importing csv files | Excel Discussion (Misc queries) | |||
Importing files | Excel Discussion (Misc queries) | |||
Importing CSV files | Excel Discussion (Misc queries) |