I'm importing worksheets in closed workbook that match each of the sheets names, but I'm running into a problem. The closed workbook has external links and I'm prompted to select a workbook for every sheet that's being imported. Is there a way to make this not happen?
Capture.PNGCapture2.PNG
Does this work?
Please Login or Register to view this content.
Last edited by MatrixMan; 03-06-2017 at 03:49 PM.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
You open a closed workbook, one of the parameter option is a link. You can put in a value of 0.
Or this might work.
Application.AskToUpdateLinks = False
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks