Access 2010 ImportExportSpreadsheet Macro

PhxDB
PhxDB used Ask the Experts™
on
Just looking for the correct format to import specific spreadsheets via macro.

Screen Print
The file has a variety of sheets and I just want to choose one "Final".  Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

Try to place Final!A1:E20 or a named range in the Range field instead of the File name Range

Regards

Author

Commented:
Knew it was gonna be easy - Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial