• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

export error

Hi,

I have a macro called autoexec

On the TransferSpreadsheet Action i have file name

G:\Asset Services MI\UnMatched Merit\balances.xls

Now, that ss already exists. So i get an error message saying table already exists and it halts execution

How can i get it so the macro ignores this and overwtites the file

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try placing set warnings before and after the transferspreadsheet
with first warnings on set to yes and the second setwarnings on to No

SetWarnings
TransferSpreadsheet
SetWarnings
0
 
Seamus2626Author Commented:
Excellent, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now