• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

change vba code from active workbook to last workbook

Hi experts

How would u change vba code that starts

with activeworkbook

To refer to workbook called age
0
route217
Asked:
route217
  • 2
1 Solution
 
NorieVBA ExpertCommented:
Either this,
With Workbooks("Age")

Open in new window

or this, with the appropriate file extension.
With Workbooks("Age.xlsm")

Open in new window

0
 
route217Author Commented:
Cheers
0
 
route217Author Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now