Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Write Code w/VBA

How do you write a routine using VBA. A simple exaple would be a macro that
creates the following sub...

Private Sub Workbook_Open()
ThisWorkbook.IsAddin = False
Application.Run "TestOne"
End Sub

Thanks a lot for any help.

Regards
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Write Code w/VBA

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"Ronbo" wrote:

How do you write a routine using VBA. A simple exaple would be a macro that
creates the following sub...

Private Sub Workbook_Open()
ThisWorkbook.IsAddin = False
Application.Run "TestOne"
End Sub

Thanks a lot for any help.

Regards

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Write Code w/VBA

Thanks, that is exactly what I was looking for.

"Tom Ogilvy" wrote:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"Ronbo" wrote:

How do you write a routine using VBA. A simple exaple would be a macro that
creates the following sub...

Private Sub Workbook_Open()
ThisWorkbook.IsAddin = False
Application.Run "TestOne"
End Sub

Thanks a lot for any help.

Regards

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
could someone write me a VB code? thanks Morgan New Users to Excel 6 March 10th 10 01:20 PM
Write code to Write Code Kstalker[_43_] Excel Programming 6 November 25th 05 12:30 AM
Code to write out all lines of code davidm Excel Programming 3 August 5th 05 04:26 AM
How can i write TSR code A-Design Excel Programming 5 September 29th 04 05:26 PM
Using VBA to Write VBA code SB Excel Programming 10 January 23rd 04 02:01 PM


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

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"