penfold1992
Registered User.
- Local time
- Today, 12:14
- Joined
- Nov 22, 2012
- Messages
- 169
Hello,
I was wondering if it is possible to pre-processes queries before they are exported.
I wanted to do a few things like, conditional formating, column widths and some simple formatting.
I currently have a macro to export to an xlsx excel spreadsheet and i dont know if i can code in the formatting or if i have to create an additional excel spreadsheet with the macro on it so that I can do this:
In Access -->
Export Query
Open export
Open Pre-programmed macro
run macro
save the export with the macro completed
close macro
Im not sure how easy that will be to do but im sure I can find a way to do that...
is there a better way?
I was wondering if it is possible to pre-processes queries before they are exported.
I wanted to do a few things like, conditional formating, column widths and some simple formatting.
I currently have a macro to export to an xlsx excel spreadsheet and i dont know if i can code in the formatting or if i have to create an additional excel spreadsheet with the macro on it so that I can do this:
In Access -->
Export Query
Open export
Open Pre-programmed macro
run macro
save the export with the macro completed
close macro
Im not sure how easy that will be to do but im sure I can find a way to do that...
is there a better way?