Export to Excel from Access2000

[GammelNok]

I have a spreadsheet containing macros, that processes a lot of Subtotals, averages etc.
I export a query into this speadsheet, then open the spreadsheet and click my Macro button.

This works fine when done from Access 97

When exporting from Access2000, I get Access Violation, Sharing Violation, Memory could not be read etc when I open the Spreadsheet.
Any idea

 

[ETID]

You would not need to export the data to excel, (too many steps)...

Create a live link to the table or query from within excel,

From excel click Data>Get External Data>New Database Query>....the choose msaccess databases* from the list...follow the wizard from there (to select your mdb, table or query)
then return your data to excel.

You can opt to use the wizard or MsQuery (a gui type interface, similar to access)at this point...
after your comfy with this...I would recommend the MsQuery option.


when data is returned,...you can right click in the data area and select properties to refresh on open...auto fill formulas etc.

this is now a live link, any time the workbook is opened. your current access data comes in (if you set the refresh on open option)

 

[GammelNok]

Thanks
But...
All my Databases are Secured, and Excel does not recognise my Login and Password

Regards
Hans

 

[ETID]

ouch