Automation.. excel updated links? 1

[AppStaff]

' Create a new instance of Excel.
Set objExcel = CreateObject("Excel.Application")

' Show the instance of Excel on the screen.
objExcel.Visible = True

' Open a file named SampleFile.xls
objExcel.workbooks.Open "\\Ntfrfddls08\CCT_Share\Project Reports\Prioritized Demand List\Prioritized Demand List_Temp.xlt", 3

Here is my code. For some reason when I open a file it does not update my external references (msquery using data from an access database).

I looked up this option in the object library, do i have it wrong? What is correct?

Thanks in advance for any responses!

 

[PHV]

You may try this after the Open:
objExcel.ActiveWorkbook.RefreshAll

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[AppStaff]

That seems to do it. Thanks! Star for response.