processing exported queries (1 Viewer)

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?
 

pr2-eugin

Super Moderator
Local time
Today, 12:14
Joined
Nov 30, 2011
Messages
8,494
penfold1992, did you say you have the macro to format the Excel sheet or are you asking that if there is any such macro?
 

penfold1992

Registered User.
Local time
Today, 12:14
Joined
Nov 22, 2012
Messages
169
oh, there is currently no macro but i can write one... i just wondered if i could do it in a better way then how i described it above...
Its a rather long way around but if thats the only method, i shall try.

Is it possible to run a macro from a work book from inside access? How would I go about doing this?
 

Users who are viewing this thread

Top Bottom