I need help on creating a macro in Excel from MS Access

[homerbrn]

I have already created the spreadsheet and populated and formated it using excel.object, but I am having problems when trying to create a macro in excel from MS Access. The current error message I am getting

 

[SkipVought]

Please post your code and the error message.

Skip,

_{I'll be dressed to the nines this week, as I go to have my prostatectomy...
Because, if I'm gonna BE impotent, I want to LOOK impotent!}

 

[PHV]

Anyway, why not using a template (.xlt) to create your spreadsheet ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886