Formatting anMS Access report in Excel

  • Thread starter Thread starter Burt Rosner
  • Start date Start date
B

Burt Rosner

To Anyone,

Can someone direct me on how to format an MS Excel file
based on info from from an MS Access table?

Thanks, in advance.

Burt
 
Perhaps there is a better way to do this...but, what I do,
is make a macro (in excel) that Formats the report. Save
this macro, and whenever you download an Access report in
Excel, open the macro and run it on your newly downloaded
report. Maybee not the correct way, but it'll format your
report in 2 seconds.

Best of luck.
 
Roberta,

Thanks. I'll try that.

Burt
-----Original Message-----
Perhaps there is a better way to do this...but, what I do,
is make a macro (in excel) that Formats the report. Save
this macro, and whenever you download an Access report in
Excel, open the macro and run it on your newly downloaded
report. Maybee not the correct way, but it'll format your
report in 2 seconds.

Best of luck.


.
Click to expand...
 
Back
Top