Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My thanks to anyone who reads and replies to this
I have written a macro which does a number of things: 1) Writes a number of script files for a third party software product 2) Writes a .bat file to execute the scripts 3) Loops until the resulting output files are found 4) Imports the files (text files 5) Copies the required data into my spreadsheet 6) Closes the txt files (SaveChanges = False The problem I have is that when the macro completes, a few seconds later, an Excel popup proclaims "The file "####.txt" is available for read/write" for each of the txt files previously imported and closed Why? and, how can I prevent this happening Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
"Unable to Read File" error message in Excel - solutions? | Excel Discussion (Misc queries) | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Setting up and Configuration of Excel | |||
XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" | Excel Discussion (Misc queries) | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |