[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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