Disabling a Message Box / Warning Message?

[unit213]

I have a macro that executes a series of queries (no modules or VBA code).
I use OutputTo to output an Excel file at the end of the macro. Each time the
macro is run, it overrides the previous Excel file. How would I go about turning
off this warning?

I searched the following thread and tried a few of the techniques mentioned, but I haven't been successful
at this point.

http://www.mrexcel.com/forum/showthread.php?t=352639&highlight=disable+warnings

 

[Joe4]

I see what you mean, even using SetWarnings "No" does not work. However, if I exported to an Excel file using the "TransferSpreadsheet" Action instead of the "OutputTo" Action, I do not get that warning.

Will that work for you? I am really not sure what difference there is in using TranferSpreadsheet instead of OutputTo to create an Excel file, if any.

 

[unit213]

Please forgive my Access skills (newbie). I'm trying to test the 'TransferSpreadsheet'
action. However, I don't think I have the parameters set correctly since the file isn't writing
out. Here's what I've got:

Transfer Type: Export
Spreadsheet Type: Excel Workbook
Table Name:
File Name: \\snas1\Production\Casting DOH Output.xls
Has Field Names: no
Range:

 

[unit213]

Joe,

I got it. I didn't define the table name. Thanks for your help! That worked great.

 

[unit213]

I found myself encountering this issue again and I'm hoping that there is a solution.
Previously, I programmed around the problem. This time I need to find a fix.
Perhaps there is a program, similar to 'ClickYes' that will work?

Has anyone found a solution for this? Any input would be greatly appreciated!

Thanks.

Dan

 

[Joe4]

Why do you think you need to use "OutputTo" instead of "TransferSpreadsheet"?
A "ClickYes" type of solution seems like it would be more of a workaround than "TransferSpreadsheet".

 

[unit213]

Joe,

I'm outputting a PDF file, not a spreadsheet. I'm not familiar with another way to ouput a PDF other than 'OutputTo'.
I'm ok with a band-aid too if there is one out there as opposed to an actual solution. The 'ClickYes' program works quite well.
Something along those lines would be great too.

 

[Joe4]

Ah, I see. You didn't mention that we are talking about outputting to PDF instead of Excel now. Can't say that I have had a whole lot of experience doing that, but I found a few articles via Google that might prove to be useful:

http://p2p.wrox.com/access-vba/54452-print-pdf-access.html
http://www.vbaexpress.com/kb/getarticle.php?kb_id=789
http://tek-tips.com/faqs.cfm?fid=1635

 

[unit213]

Thanks Joe. I'll do a little reading to see if I can use any of the code in the links you posted.

 

[revans]

If you're writing over a file you can delete the file first.

hth,

Rich