Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jamil Akram   on Sep 16 In MS Office Category.

  
Question Answered By: Taylor White   on Sep 16

Using the macro recorder, I came up with the following:
-------------------------------------------------
Sub Macro1()
'
Workbooks.Add
End Sub
-------------------------------------------------
Before doing this, though, define sourceWorkbook = activeworkbook.name,
and repeat for new workbook, so you can easily switch between them.
Resulting in:

Dim sourceWorkbook, destinationWorkbook As String

sourceWorkbook = ActiveWorkbook.Name
Workbooks.Add
destinationWorkbook = ActiveWorkbook.Name

Share: 

 
 
Didn't find what you were looking for? Find more on Create a blank file Or get search suggestion and latest updates.


Tagged: