Resolving "File Now Available" Read-Write dialog at end of code

[tyler.paavola]

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

 

[akphidelt]

Never seen this situation but for most dialog boxes you can use the code

Application.DisplayAlerts = False
Whatever your code is
Application.DisplayAlerts = True

 

[tyler.paavola]

Never seen this situation but for most dialog boxes you can use the code

Application.DisplayAlerts = False
Whatever your code is
Application.DisplayAlerts = True

The dialog boxes only appear AFTER all my code as ran through.

I have tried putting Application.DisplayAlerts = False in my code, but
the dialog boxes still appear after the macro is finished.

 

[tyler.paavola]

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

Even if someone could tell me WHY this dialog is appearing after my
macro has finished running, that would help out A LOT

 

[EssKayKay]

Tyler,


Did you ever resolove your issue with the "File now available" error? I'm seeing the same thing with a similar routine where I'm running an Excel routine from inside Access. However, after I exit all, I'm seeing this error.

Thanks,
SKK