Hi
I recently upgraded my Excel from 2003 to 2007 and I am having issues running the below code through Visual Basic which imports data from a closed workbook in my directory to an open workbook. It was working fine in 2003 but since upgrading it seems to no longer recognise it. The problem seems to be when it is finding the file to import the data from and unsure how to fix it. Any help would be greatly appreciated:
Please Login or Register to view this content.
Last edited by davesexcel; 02-23-2011 at 08:01 AM.
My recollection is that FileSearch doesn't exist in 2007. If you Google you should find an alternative or somebody here will put you on the right track.
Correct Stephen, FileSearch was removed from 2007 and this seems to be a very touchy point with many people.
GNelson
Have a look at this thread in this forum.
http://www.excelforum.com/excel-prog...el-2007-a.html
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
This question has been asked in this forum by so many people, including me. Here are the answers I got
https://www.excelforum.com/showthread.php?t=711455
Sorry. Marcol has given the same link!!
Last edited by johnjohns; 02-23-2011 at 09:53 AM.
regards
johnjohns
When you are not sure where to go, every road takes you there!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks