Export from query to excisiting Excelfile

[wharting]

Hi,

I want to export query results to an excisting Excel file. In the Excel file I've a pivot table that should be updated every month with fresh data so the data of a former month should be deleted.


Exporting to Excel offcourse isn't a problem but how to do it in VBA in the way I want it?
Thanks in advance.

Best regards,
Willem

[rpeare]

You will likely have to delete the existing file (if you use the same file name over and over) using the filesystemobject commands. There are tons of resources for using filesystemobject just google it.

Then just re-export your query with the same file name etc. using the transferspreadsheet command in your vb code.

You'd just have to add a button to one of your forms to perform the export when you wanted.

[wharting]

The issue was to export data to a specific worksheet in an excisting Excel file without deleting turntable's.
I've tried several times and finally I got it working as I want it to work.
Thanks anyway.

Best regards,
Willem