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?