Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel Macro Automatic

Hello, i want to know how i write an automacro in excel.
The thing is to open a workbook, and automatic execute a
macro, can i help me?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default Excel Macro Automatic

try this
Workbooks.Open(workbookname & ".xls").RunAutoMacros xlAutoOpen

--
Don Guillett
SalesAid Software

"graciela" wrote in message
...
Hello, i want to know how i write an automacro in excel.
The thing is to open a workbook, and automatic execute a
macro, can i help me?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Excel Macro Automatic

Try this:

In VBA, click on This Workbook
create a subroutine

sub Workbook_open()
.....command to run macro.
end sub


"graciela" wrote in message
...
Hello, i want to know how i write an automacro in excel.
The thing is to open a workbook, and automatic execute a
macro, can i help me?



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
Automatic email by Excel Macro Anift Setting up and Configuration of Excel 2 November 11th 06 04:33 AM
Help? start macro automatic in excel pim_parra Excel Worksheet Functions 2 April 8th 05 02:03 PM
excel - macro - automatic initiation of a macro at a pre-specified "system time" arunjoshi[_3_] Excel Programming 3 May 1st 04 09:42 AM
Automatic Macro in Excel MMM[_2_] Excel Programming 1 February 3rd 04 03:53 PM
Automatic startup of an excel macro Quist Excel Programming 3 October 3rd 03 04:31 PM


All times are GMT +1. The time now is 11:42 PM.

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

About Us

"It's about Microsoft Excel"