Re: [MSAccessProfessionals] VBA Export to excel issue

Thank You so much for your responses. 

My thought was to kill the existing file in the folder and then have the process replace it. But I decided to try another way according to the users requests. 

Thank You

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Paul Baldy <Pbaldy@gmail.com>
Sent: Thursday, June 1, 2023 9:12 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] VBA Export to excel issue

 

>> I know that exporting to an existing excel does not overwrite it adds the new sheet. 

Not in my experience, at least not with OutputTo.  

Paul

------ Original Message ------

From: "Cheeseburger" <Michael.P.Devlin@hofstra.edu>

To: "MSAccessProfessionals@groups.io" <MSAccessProfessionals@groups.io>

Sent: 6/1/2023 6:54:15 AM

Subject: Re: [MSAccessProfessionals] VBA Export to excel issue

When you say killpath,are you killing the file first?  I know that exporting to an existing excel does not overwrite it adds the new sheet. 

Get Outlook for iOS