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: 4
Default Resolving "File Now Available" Read-Write dialog at end of code

I have a macro that downloads files off a FTP to a local directory and
then processes those files. These files are ".rpt" (basically text
files). I am using the OpenText() function to process these files.

After all my code runs through successfully and the macro is finished,
I get dialog boxes telling me that:

"File Now Available"
'report_name.rpt' is now available for editing.
Choose Read-Write to open it for editing.


The macro will eventually be ran as an automated script, so I cannot
have these dialogs displaying at the end of my script.
I would like to find a fix for this other than just suppressing all
dialog boxes.

Any suggestions greatly appreciated!!
thnx


 
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
XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY" billybob Excel Discussion (Misc queries) 1 February 13th 06 03:14 AM
Using "Cells" to write "Range("A:A,H:H").Select" Trip Ives[_2_] Excel Programming 3 June 5th 04 03:13 PM
"file available for read/write" message MikeP Excel Programming 2 June 5th 04 12:31 PM
VBA code to display the "Find" (Ctrl+F) dialog box lothario[_28_] Excel Programming 2 October 17th 03 10:28 AM
How can i write a vba code to get string or integer "C15" from $c$15? d Excel Programming 2 August 29th 03 06:11 PM


All times are GMT +1. The time now is 06:34 AM.

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"