Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
VB Code Or Macros hitesh New Users to Excel 4 February 13th 10 05:12 PM
Macros/vba Code mpsears62 Excel Discussion (Misc queries) 0 August 7th 08 04:08 PM
Excel into executable MrBT Excel Worksheet Functions 2 May 1st 08 03:05 AM
Turning Off Personal Macros sheet [email protected] Excel Discussion (Misc queries) 1 February 21st 07 01:53 AM
Turning Off AutoFilter With Code Howard Brody Excel Programming 0 August 11th 03 06:49 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"