| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call macro from other workbook
Hi, I m running a macro from one of the excel workbook let s say workbook1 i want to add a call macro code so that i can execute the macro in othe workbook2. Guys, do u have any idea/ Thanks, ppyx -- ppyx ----------------------------------------------------------------------- ppyxl's Profile: http://www.excelforum.com/member.php...fo&userid=3611 View this thread: http://www.excelforum.com/showthread.php?threadid=56064 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
Application.Run "book2.xls!test_msgbox"
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ppyxl" wrote in message ... Hi, I m running a macro from one of the excel workbook let s say workbook1, i want to add a call macro code so that i can execute the macro in other workbook2. Guys, do u have any idea/ Thanks, ppyxl -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=560641 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
Like this: Application.Run "Workbook1!MyMacro" Col -- colofnature ------------------------------------------------------------------------ colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356 View this thread: http://www.excelforum.com/showthread...hreadid=560641 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
code is not working, pls check for me. Many thanks ____________________________ Sub SaveFO2() -'define date- Dim ReportDate, LsReportDate As Date Dim ReportName, directoryName As String LsReportDate = Workbooks("startup").Sheets("FO2").Range("B2") ReportDate = Workbooks("startup").Sheets("FO2").Range("B3") -'save from one file to another- Workbooks.Open fileName:=("K:\Reporting\XL\DataBase\FO2 " Format(LsReportDate, "yyyymmdd") & ".xls"), updatelinks:=0 ActiveWorkbook.SaveAs "K:\Reporting\XL\DataBase\FO2 " Format(ReportDate, "yyyymmdd") & ".xls" -'define some strings- directoryName = "K:\Reporting\XL\DataBase\FO2 " & Format(ReportDate "yyyymmdd") ReportName = "FO2 " & Format(ReportDate, "yyyymmdd") & ".xls" Sheets("Input_Working").Activate Cells(2, 4).Value = ReportDate -'run macro- Application.Run ReportName!Main End Su -- ppyx ----------------------------------------------------------------------- ppyxl's Profile: http://www.excelforum.com/member.php...fo&userid=3611 View this thread: http://www.excelforum.com/showthread.php?threadid=56064 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
Application.Run ReportName & "!Main"
-- Regards, Tom Ogilvy "ppyxl" wrote: code is not working, pls check for me. Many thanks ____________________________ Sub SaveFO2() -'define date- Dim ReportDate, LsReportDate As Date Dim ReportName, directoryName As String LsReportDate = Workbooks("startup").Sheets("FO2").Range("B2") ReportDate = Workbooks("startup").Sheets("FO2").Range("B3") -'save from one file to another- Workbooks.Open fileName:=("K:\Reporting\XL\DataBase\FO2 " & Format(LsReportDate, "yyyymmdd") & ".xls"), updatelinks:=0 ActiveWorkbook.SaveAs "K:\Reporting\XL\DataBase\FO2 " & Format(ReportDate, "yyyymmdd") & ".xls" -'define some strings- directoryName = "K:\Reporting\XL\DataBase\FO2 " & Format(ReportDate, "yyyymmdd") ReportName = "FO2 " & Format(ReportDate, "yyyymmdd") & ".xls" Sheets("Input_Working").Activate Cells(2, 4).Value = ReportDate -'run macro- Application.Run ReportName!Main End Sub -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=560641 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
Hi, thanks! error msg still! macro not found is it any speical setting for the macro in another excel work book -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=560641 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
the macro should be in a general module and not in a sheet module or the
thisworkbook module. the macro should be public, but this is the default. -- Regards, Tom Ogilvy "ppyxl" wrote: Hi, thanks! error msg still! macro not found is it any speical setting for the macro in another excel work book -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=560641 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
Try
Application.Run "'" & ReportName & "'!Main" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ppyxl" wrote in message ... Hi, thanks! error msg still! macro not found is it any speical setting for the macro in another excel work book -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=560641 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to call macro from other workbook
Good catch on Bob's part - Spaces in a workbook name require the name be
enclosed in single quotes. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote: the macro should be in a general module and not in a sheet module or the thisworkbook module. the macro should be public, but this is the default. -- Regards, Tom Ogilvy "ppyxl" wrote: Hi, thanks! error msg still! macro not found is it any speical setting for the macro in another excel work book -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=560641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Call Macro from another WorkBook? | Excel Programming | |||
| How to call Macro(using ExecuteExcel4Macro) for a particular workbook | Excel Programming | |||
| How can I call a macro in another workbook? | Excel Programming | |||
| Open Another Workbook and Call Macro | Excel Programming | |||
| Call a macro in other workbook | Excel Programming | |||
![ppyxl[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
