VBA help on file location

ahovander1213

New Member
Joined
Oct 13, 2018
Messages
10
I have a set of docs in a folder that is used as a template. Our people Copy template into a different location. Everything works but a macro that opens files.
Below is my template location and name. How do I structure the Macro to adjust to new location?

Workbooks.Open Filename:= _
"C:\Users\alanh.CASNM\Desktop\CD - Al Test\05 Forms and progamming\QC Design.xlsm" _
, UpdateLinks:=3
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,090,551
Messages
5,415,227
Members
403,573
Latest member
ballardgirl

This Week's Hot Topics

Top