Macro doesn't replace an existing file. It did in Access 97.

D

dlheim

I have a macro that performs several functions. It runs six queries, the
last one creating a table. I then have the macro setup to export that table
to an AS400 location. This is where it fails. It halts the macro and gives
me an message box that tells me the table "payrolje.csv" already exists. Has
an OK and help button. If I press OK, the macro is still halted. What do I
have to do so that this function continues?
 
S

Steve Schapel

Dlheim,

I assume you are using a TransferText action in your macro to export the
data to the payrolje.csv file? As far as I know, this problem can not
be overcome with a macro. The existing payrolje.csv file will need to
be deleted first, and for this you will need to use a VBA procedure
using the Kill method.
 

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

Similar Threads

Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Prompt For Replace in Selection And More... 0
Global Template Network and saving auto texts & macros 2
Error message "Macro doesn't exist" 3
Error When Using TransferText in a Macro 1
Table already exists 0
"table already exists" 5
Word 2007 - Macro gets stuck searching for and replacing "^p^p" 3

Top