I have a post as below Paul Schreiner has been helping me out on it. http://groups.google.com/group/excel-macros/browse_thread/thread/9565d70088ca5677/524288e52789b113#524288e52789b113
I inserted the macro as a module in my spreadsheet . I had to insert Dim RecCnt Dim MatNo as I was getting " variable not defined" messages . I have the macro running through now but Its not importing any records? I am not getting any error messages can you please shed some light on why its not working? Please look at the the thread above for details, Thanks so much for any help!! Newby Dave -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel