TransferToSpreadsheet

D

Dunner

Hey guys,

I've done a little macro to transfer all the data from a
query into a spreadsheet - that works fine. The problem
is I need it to overwrite this with updated data from the
spreadsheet whenever the macro is run but it keeps
popping up a "This file already exists, do you want to
overwrite it". Is there a way to disable this message as
I don't want to confuse the users beacuse they're only
simple folk.

Cheers

Dunner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top