troubleshooting Question

VBA to copy 2 columns from a closed workbook

Avatar of Jagwarman
Jagwarman asked on
Microsoft OfficeVisual Basic ClassicMicrosoft ExcelVBA
2 Comments1 Solution209 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros