Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reference macro syntax

Status
Not open for further replies.
mart10

mart10

MIS
Nov 2, 2007
394
GB
I am using Access 2003

I have a macro 1 (MacroShiftData1Day) which shifts lots of data.Occasionally I want to do the shist 3 times so just run the macro 3 times using:

Sub MacroShiftData3Days()
' MacroShiftData3Days Macro
'1st Pass
Application.Run "'Balance & Cash Flow Forecasts 1.xls'!MacroShiftData1Day"
'2nd Pass
Application.Run "'Balance & Cash Flow Forecasts 1.xls'!MacroShiftData1Day"
'3rd Pass
Application.Run "'Balance & Cash Flow Forecasts 1.xls'!MacroShiftData1Day"
End Sub

However this obviously references the macro1 in this workbook name and it needs to be general as I am just setting this up as a template at moment and will have lots of differetly named copies. What syntax do I need to do this?
 
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
1K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
416
dhookom
dhookom
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
170
dhookom
dhookom
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
150
Andrzejek
Andrzejek
Skittle
  • Locked
  • Question
RunSavedImportExport Macro - How Can You Edit Definition?
Replies
1
Views
90
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top