LinkBack URL
About LinkBacks
When I use the code below it imports the data just fine when its .xls
but now wont work when I use it on .xlsm
How can I make it work
Please Login or Register to view this content.
When I use the code below it imports the data just fine when its .xls
but now wont work when I use it on .xlsm
How can I make it work
Please Login or Register to view this content.
How does it not work for xlsm files?
If posting code please use code tags, see here.
I just figured this out but on the workbooks I am trying to grab data off I have if I remove this code it works great
Everything stops when this code is in the This Workbook Object , but it is code I would like to keep because there a lot of sheets that are hidden on the sheet and if I open those workbooks it opens to the first sheet in the book.Please Login or Register to view this content.
is that possible
Please Login or Register to view this content.
Not sure I follow.
Are you saying there is code in the xlsm files that you are opening that you want to keep but that code appears to be preventing you importing data from the files?
If that's the case try temporarily disabling events, opening the workbook, doing the import then closing the workbook and enabling events.
Something like this
Please Login or Register to view this content.
That seems to be working now....awesome....
One more thing what line can I add to "disable update links" message when i open the file again.
Brian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks