I'm trying to use the UpdateLinks on the Application.Workbook.open in a RIFL script using a function object within Process Designer. I can get the workbook to open but if it contains offline data sources I don't want to get a prompt to update. I was able to use AskToUpdateLinks but it changes the app settings. I would like to just override the current setting and when I close Excel it goes back to normal.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.