About
Pricing
Community
Teams
Start Free Trial
Log in
Jagwarman
asked on
9/22/2015
VBA to copy 2 columns from a closed workbook
could an expert provide VBA that will copy columns C and Columns L from a closed workbook into my current workbook
The path for the closed workbook is C:\jagwarman\AP\Reports
There will only ever be one file in that folder called LDNEQUEQF012
Copy column C and column L from that file into current workbook sheet1 column C into column A column L into column B
many thanks
Visual Basic Classic
Microsoft Office
Microsoft Excel
VBA
2
1
Last Comment
Jagwarman
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan Chong
9/22/2015
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jagwarman
9/23/2015
ASKER
that's perfect thanks
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck