automatically executing Excel macro after OutputTo macro

I

I.M. Shatner

I have an OutputTo macro that creates an xls file from a report. The xls file
needs additional formatting to be usable. I would like to find a way to have
that formatting macro execute immediately upon Autorun. Here's the excel
code I'd like to fit in, or append to my Access macro if possible.

Thanks!

Private Sub Workbook_Open()

'
Cells.Select
With Selection.Font
.Size = 9
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 1
End With
Selection.Rows.AutoFit
Columns("A:A").Select
Selection.Font.Bold = True
Range("A4").Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Error 1
Macro to conditionally copy a row based on todays date 1
compile error type mismatch in macro on excel file 2
Macro Error in Command Button 4
Active sheet problem / macro button 0
compile error type mismatch 7
Macro DoSomething in every cell of my selected range 1
Macro Takes Long Time To Run 11

Top