Display alert

[Guest]

Hi Expert

Can somebody help me with this code. I got excel file always ask for automactic update links. If I disable at the microsoft excel at tools>options>Edit>uncheck the automatic update then it ask me to save the file somewhere and I don't want it

Here my code to disable the automatic update links. Always ask me to enter <YES> or <NO> button

Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open("D:\project1\ForecastUpload\Vivian\Upload for IT_STM_SCM_UHT_POW.xls"
xlBook.Application.AskToUpdateLinks = Fals
xlApp.Application.DisplayAlerts = Fals
Set xlSheet = xlBook.Worksheets(1)

 

[Frank Kabel]

Hi
try
Set xlBook = xlApp.Workbooks.Open(filename:="D:\project1
\ForecastUpload\Vivian\Upload for IT_STM_SCM_UHT_POW.xls",
updatelinks:=0)

-----Original Message-----
Hi Expert,

Can somebody help me with this code. I got excel file

always ask for automactic update links. If I disable at
the microsoft excel at tools>options>Edit>uncheck the
automatic update then it ask me to save the file somewhere
and I don't want it.

Here my code to disable the automatic update links.

Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open("D:\project1

\ForecastUpload\Vivian\Upload for IT_STM_SCM_UHT_POW.xls")

 

[Guest]

Dear Frank
Thank you so much!!!

Its work

Wzaq