PC Review


Reply
Thread Tools Rate Thread

automatically executing Excel macro after OutputTo macro

 
 
I.M. Shatner
Guest
Posts: n/a
 
      6th Aug 2009
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically executing a macro when A pick list item is selected =?Utf-8?B?S2VuIEs=?= Microsoft Excel Programming 1 30th Oct 2006 11:52 PM
Pause an executing Word Macro to enter info and then Macro continu =?Utf-8?B?c3Ryb25nd2VsbA==?= Microsoft Word Document Management 1 11th Aug 2006 06:57 PM
Macro OutputTo Excel Help. Probably easy Brandon Johnson Microsoft Access Forms 0 12th Jul 2006 03:48 PM
Macro OutputTo Excel Help Brandon Johnson Microsoft Access Forms 0 11th Jul 2006 09:06 PM
OutputTo Excel Macro different to VB =?Utf-8?B?U3RldmU=?= Microsoft Access VBA Modules 2 23rd Mar 2006 07:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:12 AM.