Export to Excel failing

[JChalmers]

Hi there,

Been using a huge database that the company has and I've been trying to create a price list using a number of tables and one querey.

I have created a report which lists the data in a style that is easy to group and list.

My previous version I could easily export to Excel into a spreadsheet and then run some macros to turn it into a stylised Price Sheet for customers to use.

However the boss wanted to change a few things and take data from a different table which was no problem. The report runs fine and shows everything just like the previous version.

This is where my problem starts though, when I click Export to Excel and choose my location it will start exporting all the pages, (I can even see the spreadsheet being created in the location as the export happens) but the moment the export finishes the spreadsheet automatically deletes itself as if nothing has happened.

I'm quite a Access newbie so any help to the matter would be great as it has left me and the boss completely bamboozled!

Thanks,

Chalmers

[June7]

Can you go back to the version that worked? Does it still work? Now try making changes again. Does the same problem present? Post code and/or project for analysis.