V
Vianet News
I am looking to created a formatted spreadsheet from a dump from an Access
generated report. The issues are that the built in export to Excel does not
format the Excel sheet properly and we want any code that does formatting of
the Excel sheet to be called from the object model in the Access VBA rather
than from Excel VBA.
Has anybody ever done anything like this before? I am wondering if there is
a good approach or an issue or two that I should be aware of while doing
this. Thanks again for any help, it is much appreciated.
Dave
generated report. The issues are that the built in export to Excel does not
format the Excel sheet properly and we want any code that does formatting of
the Excel sheet to be called from the object model in the Access VBA rather
than from Excel VBA.
Has anybody ever done anything like this before? I am wondering if there is
a good approach or an issue or two that I should be aware of while doing
this. Thanks again for any help, it is much appreciated.
Dave