Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continue macro from current workbook
Hi,
I'm looking for vba codes to continue running the macro from workbook1 to workbook2 after furnishing data form in workbook2 and continue macro in workbook1 Extract codes below Workbook1 Windows("Workbook1").Activate Dim Frm As Object Dim varAnswer As String varAnswer = MsgBox("Do you want to update worksheet name ?", vbYesNo, "OpenWorksheetNameForm") If varAnswer = vbYes Then Set Frm = Application.Run("'" & ActiveWorkbook.Name & "'! OpenWorksheetNameForm") Frm.Show End If If varAnswer = vbNo Then GoTo NextSelection End If Workbook2 Sub OpenWorksheetNameForm() frmWorksheetName.Show End Sub Any helps will be appreciated and thanks in advance Regards Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert macro using current workbook | Excel Programming | |||
Refering to the current workbook in a macro | Excel Programming | |||
how can i get a macro in personal.xls to know my current workbook? | Excel Programming | |||
open workbook from a macro and continue this macro afterwards | Excel Programming | |||
Close current Workbook after calling macro in other | Excel Programming |