Solved

export error

Posted on 2011-03-16
2
281 Views
Last Modified: 2012-05-11
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
Comment
Question by:Seamus2626
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 35149439
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
 

Author Closing Comment

by:Seamus2626
ID: 35149622
Excellent, thanks!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What's wrong with CopyFromRecordset 6 33
Migrating Macro Menu’s From Access 2003 to Access 2013 2 28
Combobox row source 2 20
Access 2003 query lost it's only join 7 26
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question