View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson[_2_] Chip Pearson[_2_] is offline
external usenet poster
 
Posts: 95
Default Turning macros into executable code

David,

You can't turn a VBA macro in to an exe file. If you want to execute it with
Scheduler, put the following code in the ThisWorkbook code module:

Private Sub Workbook_Open()
' call your code here
End Sub

Then, have Scheduler open this workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"David" wrote in message
...
How do i turn a macro into a .exe file that can be
executed using the scheduler?