vba open workbook

P

plost33

Well-known Member
Joined
Oct 2, 2008
Messages
866
i am trying to assign the open workbook to a variable.

the varible is named "wbTimesheet"

i have it dim as a workbook.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
You have all the pieces there!

Dim wbTimesheet as New Workbook

Set wbTimesheet = activeworkbook
 
Upvote 0
Code: 
Dim wbTimesheet As Workbook
Set wbTimesheet = ActiveWorkbook
MsgBox wbTimesheet.Name
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Open, Copy data and Close a workbook based on the names of the tabs in my active workbook
Replies
2
Views
95
Aurore87
A
MrIfOnly
  • Question Question
shapes.onaction in add-in using reference path to macro (Excel VBA)
Replies
8
Views
126
jkpieterse
jkpieterse
KlausW
  • Solved
import a sheet from a closed workbook from location in cell
Replies
3
Views
367
bobsan42
bobsan42
O
  • Question Question
Determining how a workbook was opened
Replies
2
Views
78
Oseitutuakrasi
O
N
  • Question Question
Transferring Data Between Two Open Workbooks
Replies
6
Views
155
NorthbyNorthwest
N

Forum statistics

Threads
1,224,532
Messages
6,179,388
Members
452,908
Latest member
MTDelphis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top