Found this code that works in theory for me except in 2 areas.
1. In the FileFilter:= section I would like to have the option for *.xlsx as well as *.xls
2. I only need the first tabs data. Currently the code loops through all of the sheets.
Thanks so very much.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-21-2018 at 11:35 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Perfect...thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks