Visual Basic :: Execute Macro To Run Automatically

Execute Code Automatically
Let me try to explain what I am looking for...

I need to display a dialog box when user click on a 'Start' button of another dialog box. Also along with displaying, I need to invoke a lengthy time consuming processs to initiate automatically in the code of the displayed dialog box. The code inside the dialog box has 'DoEvents' to display statistics of the lengthy run.

I have put the code in the Load function of the dialogbox. Then what is happening the dialog box is not displayed until the code is executed completely defeating my purpose of the dialog box where I inteded to show some statistics.

Now I have to put another button the displayed box and code inside that. Then I have to click it to invoke the lenghty code.

Any geek out there to help me?

How To Make Subroutine Code Automatically Execute After Form Loads
hello,
I have a VB 6 project where I had some code that I used to execute by clicking a button on the form, and I've 'cut-and-pasted' that code, it's related subroutines it calls, and the form_load coad into a new project.

In this new project, I want the main subroutine which used to be invoked by a button click, I'll call it for now:

Sub CodeToAutomaticallyRunAfterFormLoadCompletes()

to Automatically run as soon as the form_load routine completes and the form is displayed on the screen. I have a Status box in this form that communicates info to use user.
I also need this Sub to not be interruped by anything in it's execution, ie, if the user minimized or switches away focus from the window, and I only need this Sub to run one time...when it's done, the form should close.

How do I setup my project code so that this will happen?

thanks in advance for your help!
david

Execute Macro
how do i execute a saved macro in word from visualbasic?

thanks

Execute/run Macro From Vb
How can i run a macro within my vb code in my database. The database is password protected so how can i do this? Thanks in advance all.

Running A Macro Automatically
I have a spreadsheet in excel 97 with a dropdown box. Can I automatically start a macro once someone has chosen from the dropdown box?

Automatically Enable Macro
Is there any way to automatically "enable macros" when a file is opened, despite the user's security settings?

Thanks!

Run Macro Automatically Every 5 Mins
hi,

I am looking to write some code to allow a macro to be run every 5 mins on my excel spreadsheet. I have tried using the following:

Private Sub Workbook_Open()
Application.OnTime TimeValue("15:00:00"), "MyMacro"
End Sub

Sub MyMacro()
Application.OnTime
TimeValue("15:00:00"), "MyMacro"'YOUR CODEEnd Sub

but this does not work. Please could somebody help or show me an example of a sheet that actually works.

Thanks in advance.

The Macro Doesn´t Execute Xls-->ppt
Hi I need help with this: Trying to figure out why my powerpoint macro doesn´t execute, I found some clues...:

Firsto of all I´m programming with VBA in Excel 2000, and this is the macro I use to open the ppt presentation and to run a specific SlideShow:

Code:
Sub ShowPPT(pp As String)
Dim pptapp, ppt As Object
Application.ScreenUpdating = False
Set pptapp = CreateObject("PowerPoint.Application")
pptapp.Visible = True
Set ppt = pptapp.Presentations.Open(ActiveWorkbook.Path & "Distingos.ppt")
With ppt.SlideShowSettings
.ShowType = 1
.LoopUntilStopped = msoFalse
.ShowWithNarration = msoFalse
.ShowWithAnimation = msoFalse
.RangeType = 3
.SlideShowName = pp
.AdvanceMode = 2
.PointerColor.SchemeColor = 2
.Run
End With
Set ppt = Nothing
Set pptapp = Nothing
Application.ScreenUpdating = True
End Sub

This works great, the problem cames when the ppt file opens, I only want it to show certain slides (I created a lot of Custom SlideShows), and when the user clicks the mouse close the presentation and the application... I use this code:

Code:
Sub EndShow()
SlideShowWindows(1).View.Exit
Application.Quit
End Sub

But for some reason, this macro (attached to a shape) doesn´t run!!!, I tried to open manually the ppt file and then run the show, clic the shape and it works... why it doesn´t work when I open it from Excel???

Could anybody help me???

Execute A Macro On Several Worksheets At Once
I created an application to track credits/debits for a real estate company to record tenant transactions. For example, a tenant is selected on the form, and an amount of $1000 is entered as rent paid. The macro divides that amount based on percentages and inserts the new amounts into different accounts.

I created a macro to look up a sheet tab name (the tenant) based on a combo box on a form. It then inserted a row on the tenant sheet and pasted the contents of the form's text boxes on that particular sheet tab.

I would like to create a macro that will execute that transaction on all sheet tabs. For example, I could choose "All" from the tenant drop down and the macro will insert a row and add the amount to all worksheets except for the first two sheet tabs (they're Admin sheets).

If there's someone out there who knows the code to call a macro and have it affect multiple sheets, please share ;-)

Thank you in advance.

Can Two Macro Execute At The Same Time?
Hello, Everyone:
I had one Macro. Now I want to separate it into two Macro, one to deal with slow printing (thermal printer), one secone one line and about 15 lines. One to deal with file process, save file and other stuff. I wonder whether it is possible?
In the printing wait process, I used the doevents command. Is there any bad effect?
Thank you very much!
Charlie

Automaticly Execute A Macro
hi

i have made a VB program, for some things i've used VBA, but i want VBA to start automaticly, from my program or from excel itself, but it has to be started when my program finished.
how do i do that?

Thanks

Vb Macro To Execute Every 5 Minutes
Hi,
can anyone help me in this issue.I need a web page to be
refreshed automatically every 5 minutes.During each time it
refreshes,it should extract the contents of that page and store
it in a text file,search for a specified content and send that
gives me a good insight of what to do.thanks

Execute Access And Macro From VB
I would like to know how to execute code inside a VB application that will bring up an Access database and then execute one of it's macros. So far I've been able to write the following code to bring up the Database, but its not working:
Dim objAccess As Access.Application

Set objAccess = New Access.Application

'Set objAccess = CreateObject("Access.Application")

With objAccess
.OpenCurrentDatabase "C:Pars2.mdb"
'objAccess.OpenCurrentDatabase ("C:Pars2.mdb"), False
.Visible = True

End With

Execute Access97 Macro
How can I execute an Access97 Macro from Within my Visual Basic program.
thanks,
Craig

Automatically Print On Opening Macro
Hello

I am trying to build a macro to print automatically when the document is opened.

can anyone tell me how to do this?

I have tried creating a new macro in a template and put this code in:

<vbcode>
Sub pr()
'
' pr Macro
' Macro created 28/08/2003 by adavies
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0

End Sub
</vbcode>

That is in a macro in the document.

When I open the document, it does not automatically print.

Can someone help?

Macro To Execture Automatically At Startup?
Hi,

Is there a way to get a macro to exectute at the moment an Excel spreadsheet is loaded?

Cheers,

Rob.

Edit by Moderator:
Please post Excel questions, in the Excel forum.

Thank you.

How To Add The Macro Automatically In Outlook 2000?
I have made a macro in outlook 2000 that will filter the emails and send a specific email (according to the subject) to a folder in the hard disk, and it works fine.

what I need is how to make a program that will (install) or add this macro to the outlook 2000 automatically without the manual work (I mean without making a new macro inserting the code and changing the security to medium..)..

please I spent weeks trying to solve this problem which I think easy but could not reach the solution yet ..

please any comment maight help!

Automatically Run Macro In Access Database?
Hi,

I have an Access database named db1.mdb in my C: root that has a Macro named Macro1.

How would I get Windows 95 to automatically run Macro1 every hour using the System Agent? Would I need to create a batch file first and call that every hour? If so, what would the batch file look like?

Any help and examples would be appreciated..

Dan

How To Use VBA To Automatically Update Macro In Another Workbook
Hi,
I am currently writing some VBA script for excel, due to time constraint, I have to release the early version of utility to the users, all together there are more than 6 copies of them distributed out.

Question,
1) For every change of new revision, I have to copy the latest macro to the users workbook manually, it is not a present experience of manual updating. Is there a way to automatically delete the old macro module then add the latest module onto the workbook without overwriting the data on the workbook.

I have tried using the macro recorder to extra the code out..but no code is generated.

2) How to enforce user select macro running option while excel startup. If user do not select macro running, is there a way to detect it.

thanks alot
regards
kaileong

How To Automatically Overwrite Files W/VB Macro?
Could someone help me out with automatically overwriting files when using a
MS Project VB macro? As you can see, I have the file saving to native
format, then to a HTML file. When it goes to save the HTML, it always gives
me an overwrite verification msg. for which I have to click "OK." I'd like
to avoid having to click and just have it overwrite. Here's the pertinent
portion of the macro:

FileSave
FileSaveAs Name:="K:ProjectsRetire CKP.html", FormatID:="MSProject.HTML",
map:="Jeff Main"

Thanks!

Need Help With Calling Macro Automatically <RESOLVED>
I'm currently using vb in excel to do several tasks, although one troubles me. I would greatly appreciate some sort of insight in this matter. Im trying to print the spreadsheet at midnight. The printing is no problem, i just call on a macro to do that. The issue arises with how to call that macro at midnight. Ive tried several ways including an ondata command, but have found no way to check the time, to call the macro automatically from either the spreadsheet or a command. Any help would greatly be appreciated....

Edited by - flopro on 6/14/2004 2:18:07 PM

Execute Macro In Word From Vb Application
I have a user that creates a document that I need to be automaticly processed when saved to a directory on the server (change some colors, fonts etc.. and save as html) . I want to be able to record a macro in the document (They always edit the same one and save a copy elsewhere) then open the document from vb and execute the macro I recorded previously.

Can this be done. It works now with sendkeys, but is messy at best. I think the macro would be much easier.

Execute Outlook Macro Using The Calendar?
Good morning!!

Does anybody know how to have outlook calendar execute a macro ?

I want to control the times when the macro is activated using the outlook calendar.

Thank you!!

How To Execute A Macro Or Module In Excel From VB
I have managed to open the excel application and work sheet .Below is the code..

Dim app As Excel.Application
Dim work As Excel.Workbook
On Error Resume Next
Set app = GetObject(, "Excel.Application")

If app Is Nothing Then
Set app = CreateObject("Excel.Application")
End If

'app.Visible = True

Set work = GetObject("C:ACNielsenAC.xls")

work.Windows(1).Visible = True
work.Application.Visible = True

But how can execute a module or macro from VB.. how to use
work.module ..
than you..

How To Execute A Macro In An Excel Formula
I am trying to execute a macro via an excel formula. I have recorded a macro to insert a page break (name = page, hot key ctrlB). I would like it have a formula which would look like " If(a2=a1,"",run macro ctrlB). any help would be greatly appreciated. Thanks in advance

Mike

Need Help - UserForm Causes Code In Macro To Not Execute???
Here's hoping someone out there can point out the stupid error I'm making (I'm betting it's something obvious... been a couple years since I've worked with VB/Macros in Excel):

I have created a custom dialog box as a UserForm - it works fine. It implements a date range picking mechanism and pushes start and end ranges into specific cells on a specific worksheet.

When I do the following all code after the form is displayed doesn't execute:

{some initialization stuff in the macro}

UserForm1.Show

{more code which should copy some cells, etc. on the worksheet}

The "more code" never seems to execute. I have tried using UserForm1.Show 1 to force modality (shouldn't need to but I never trust Microsoft), and have also tried putting the Show method into a sub and then have 'Call JunkSub'. Same results either way.

Any suggestions from the wizards out there? I know I've done this before and must be forgetting something that can't be found in the online help. The sheer fact I could do this in 5 minutes in Excel 4 years ago irritates me no end that I've spent several hours banging away at this to no avail!

Bonus points available if someone can point me to WHERE in the help it shows the stupidity of my having to ask this here - one would think this is a common thing to do.

(If needed I can post more code but it shouldn't matter??)

Execute Access Macro Or Code From VB?
Say I have an Accesss file which has a Macro named Macro1. Or, say I have a Procedure in an Access Module
named Procedure1. Can I call those from within VB6 to execute? How would this be done? Also, would Access
have to be installed on the end user's machine for this to work?

Thanks,

Dan

Execute Existing Excel Macro Within Vb6
i have already a working excel macro and what it do is process the last open excel sheet and extract data from it. how can i automate this? i would like to write a prog where in it will open a file in excel and run the macro afterwards. i need this because the file in excel will also be automated. i have the template for the excel macro.

thanks alot!

Automatically Load A Macro When A Workbook Opens
Hi all,

I've been trying to figure a way to run a macro everytime _ANY_ workbook is open. So I've tried these ways and they all fail:
1. Workbook_Open - This can be done only for a single workbook and I need the macro to be run on every workbook which is opened
2. Personal.xls - The macro has to be launched manually from the menus (Auto_Open doesn't work since there is on worksheet open at the time of execution of the procedure)
3. I've tried creating an Add-In but I couldn't see any macros displayed

So any hints are greatly appreciated. I just need to automatically execute a macro everytime a workbook is opened. Thanks a lot!

Automatically Start Macro Recorder In Word
Hello,

it is possible to start the macro recorder in word from an external vb-application?
We want to automate the creation of word-macros, so that we start the recorder
and the user can do what he wants and after closing the recorder, we want to
save the new macro in our application.

It is possible to do this?

Thanks,
Joerg

Execute Access Macro From Visual Basic Using ADO
does anyone know how to execute Access Macro from Visual Basic using ADO? I tried using the Connection object and Recordset object.

I'm open to any suggestions.

Execute Ms Access Macro In Visual Basic
Hi, can anybody tell me how that you can execute / call a macro that has been created (before) in MS access, in my visual basic program

thx in advantage

Can I Execute Macro In Access Based On Time
ok.. i have an access macro that runs every thursday when i leave work.. the probem is that i like to leave at four while others stay until five... i need to wait for everyone to be finished working before running the macros... is there a way to set the macro to run at a certain time... (7:00pm)
thanks for the info
shawn

EXCEL: Execute A Macro When A Cell Is Clicked
How can I select a cell in Excel and cause it to activate a macro? I also need to know what the range address is of that activated cell. The macro will open up a userform where the user selects an item and the first column value will be placed in that active cell.

I think I'm in over my head...

Word Macro That Will Replace Single Characters Automatically...
... hi all. great forum you have here.
was wondering if someone could help me out... I don't know much about macro's, but I need to somehow create one that will automatically find & replace certain characters in .txt or .doc files.

we always receive documents that contain both French and German alphabetical characters. ie, À, Á, Â, É, Ë etc etc. we need to make a macro that when executed, will automatically run through a document and convert all these characters to their English equivalent. ie, A, A, A, E, E.

I've searched the forum and cannot find a thread that specifically applies to this problem.

can someone give me a head start?

any help would be much appreciated.

Automatically Run Macro When Formula Result Changes Cell Values
How do I automatically run a macro every time a formula result changes a cell value?

PS: Could answers include an example in code?

Ignoring Or Automatically Answering Dialob Boxes During Macro Run
The VB macro I'm developing generates a few application specific dialob boxes during execution. I am looking for some way to ignore them or to answer them.

This is the same 'Mail Merge' macro I've asked questions about in earlier posts. I want to thank those who have answered me so far. Your replies have been hugely helpful and enabled me to near the end of this program's development.

For this thread, the macro starts off in Excel. It then controls Word for a bit to do some Mail Merging. During this process, Office opens a brand new Excel window and opens the Mail Merge source file during the DDE processing. It's at this time the first box appears. Since the program starts off in Excel and it's opening a new Excel window, I get a small dialog box that says the file 'personal.xls' is in use and gives some options 'Read only' 'Notify' or cancel.

I'd like to be able to automatically answer 'Read only' for this box so the program continues execution without the user pressing the 'R' key or clicking on 'Read only'.

The second issue arises during the Mail Merge of some larger files. The Mail Merge takes so long that the original Excel window (where the macro execution started) gives me an error message that 'Microsoft Excel is waiting for a response from another application.'

If I go to the window and click 'Ok' execution resumes but it has to restart the whole Mail Merge process which takes an extra few minutes and has caused a few other text issues.

Would this be an appropriate place to use the Wait method?

I volunteered to use MSO 97 VB to automate some processes at work. That's why I'm asking all these questions. The program works on a basic level now but I'd like it to be much more refined so the user has to do much less. I do appreciate your thoughts on these issues. Thanks for reading!

JT

In Excel, Select Whole Row, Run Macro, End By Selecting Original Row Automatically
I have an Excel spreadsheet macro which takes off the auto-filter and then after carrying out various functions, puts the auto-filter back on again. The functions in the macro need the whole of one row to be chosen manually before running the macro. I want to end the macro by automatically highlighting the whole of the row that was orignally chosen. I assume I would need to save the address of the original ActiveCell/Row, say as a variable, and after carrying out the various functions, return to the saved address, ie: the original ActiveCell/Row. Can you give some guidance please.

Word Macro Help: Selection.Find.Execute And File Input
I'm writing a macro to take input from a .txt file wordlist into a string variable, search the document for instances of that word, and mark each instance as an index entry. The code I came up with is as follows, using the variable "term" as the term to be marked:

Code:
With Selection.Find
.Text = term
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = True
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
If Selection.Find.Found Then
ActiveWindow.ActivePane.View.ShowAll = True
ActiveDocument.Indexes.MarkEntry Range:=Selection.Range, Entry:= _
term, EntryAutoText:=term, CrossReference:="", _
CrossReferenceAutoText:="", BookmarkName:="", Bold:=False, Italic:=False
End If
The trouble is that this only marks the first instance of each term in the document. How would I go about having it scan the entire document and mark each instance of the term?

While I'm at it, I have another stupid question for you (it's been forever since I've written vb code). Let's say my wordlist file, which is parsed by commas, is opened for input as #1, and I want to input it into dynamic string array "term(x)". How would I go about defining x as the number of terms in the wordlist, then inputting the wordlist into the array from 1 to x sequentially? In other words, I want to count the number of terms in the list, assign that to a variable, and then input the terms from the file into an array.

Your help is appreciated. Thanks!

Auto Execute Excel Macro When User Opens Workbook
I want to execute a formatting macro automatically when a user opens a workbook (assuming they click "Enable Macros"). Is this possible? and if so, how?

Thanks,
roni72

Word Macro: Selection.Find.Execute And File Input
I'm writing a macro to take input from a .txt file wordlist into a string variable, search the document for instances of that word, and mark each instance as an index entry.  The code I came up with is as follows, using the variable "term" as the term to be marked:

CODEWith Selection.Find
        .Text = term
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = True
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
End With
Selection.Find.Execute
If Selection.Find.Found Then
        ActiveWindow.ActivePane.View.ShowAll = True
        ActiveDocument.Indexes.MarkEntry Range:=Selection.Range, Entry:= _
                term, EntryAutoText:=term, CrossReference:="", _
                CrossReferenceAutoText:="", BookmarkName:="", Bold:=False, Italic:=False
End If

Automatic Load/execute Of &"macro.bas&" File In Word
Hi,

I want to automatically generate Word documents out of simulations which run on Unix/Linux. This implies pasting hundreds of pictures which depend dynamically on the kind of simulations, the settings, etc. In order to speed this up, I

1. construct a "*.bas" file in Linux using ksh/perl scripts
2. load this "*.bas" file using the Visual Basic Editor in Word
3. execute the macro which then pastes all my figures at the right locations

I would like to further simplify this by automatically loading and executing a "*.bas" file (with a prescribed name). I know that there are AutoExec macros in Word but I could not figure out how to automatically load a "*.bas" file.

Any idea?

Regards and thanks,
Gianfranco

MS Internet Control Execute Execute Property?
How can
I use MS Internet Control Execute execute property to fill out a web based form, and submit it?

------------------
webmaster@hackvp.com
http://www.hackvp.com
I may be dumb, but I am not stupid!

Connection.Execute And Command.Execute
Please tell me what is the difference between connection.Execute and Command.Execute in ADO. Also which one we should use or which one is better in different scenerio. Please explain me those scenerio as well.

Execute Sql From A File Using Connect.execute??
I am currently using the following syntax:

sql = "select * from employee"

set connect=createObject("ADODB.Connection")

Connect.Open "Driver={Microsoft ODBC for Oracle};Server=DATABASE.WORLD;UID=username;PWD=password"

set rs = Connect.execute (sql,,adcmdtext)

Is there anyway I can pass in a file with a sql statement rather than the sql itsself. I have a large number of files that I would like to run directly rather than pulling all the data into a variable.

Thanks in advance!!

Ron

Word Macro Insert File/ Append Table Macro Issue.
Hello,

I was wondering if someone could help me with this problem...

When I use the following code to insert a table (from an external file), the table that is inserted does not append to the table in first document (which is what I want it to do)...

Sub Macro1()

Selection.Collapse Direction:=wdCollapseEnd
Selection.InsertFile FileName:="m:cat.DOC", Link:=True

End Sub

Would anyone know how I can make the contents of this file append to the table in the first document?

Thanks so much in advance,

Anne

Macro Opens A Document In Vba, Saves, Then Continue With Macro
Maybe the title isn't correct, but i've got the following problem.
I build a document that open a form. On this form there is a checkbox. When the checkbox is active and I press 'OK' a document has to be opened. On this document some changes can be made, then by pressing 'continue' this document is saved on 'c: emp' and closed. Then I want to go back to the first document and continue with it.
Is there some sort of halt or wait funtion to establish this?

The code I use is the following:

<code document1>
If chbFinPar = True Then
Documents.Open FileName:="f:Nieuwe format macroHuisstijlTestversiefinpar.doc"
Selection.EndKey , ActiveDocument.Bookmarks("bmkfinpar").Range
Selection.InsertFile FileName:="c: empfinpar.doc"
End If
<end code>

<code document2>
Private Sub cmdVrdr_Click()
ActiveDocument.SaveAs ("c: empfinpar.doc")
ActiveDocument.Close
End Sub
<end code>