PC Review


Reply
Thread Tools Rate Thread

Continue macro from current workbook

 
 
Len
Guest
Posts: n/a
 
      22nd Jul 2010
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert macro using current workbook Metro Microsoft Excel Programming 1 21st Jul 2009 06:31 PM
Refering to the current workbook in a macro =?Utf-8?B?dHBldGVy?= Microsoft Excel Programming 1 6th Aug 2007 04:38 PM
how can i get a macro in personal.xls to know my current workbook? nebuul@gmail.com Microsoft Excel Programming 2 3rd Aug 2006 09:23 PM
open workbook from a macro and continue this macro afterwards =?Utf-8?B?Q2hyaXMgRGUgTHV5Y2s=?= Microsoft Excel Programming 3 19th Dec 2005 12:12 PM
Close current Workbook after calling macro in other Des Janke Microsoft Excel Programming 4 7th Aug 2003 07:33 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:18 AM.