Access 2010 ImportExportSpreadsheet Macro

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!
Who is Participating?
Rgonzo1971Connect With a Mentor Commented:

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

PhxDBAuthor Commented:
Knew it was gonna be easy - Thank you!
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.

All Courses

From novice to tech pro — start learning today.