Sign in to follow this  
Followers 0
JohnBailey

ExcelCOM AskToUpdateLinks - set to no

11 posts in this topic

I understand that

$oExcel.AskToUpdateLinks = false

will automatically select yes and update the links. However, I want it to automatically select no, thus not updating the links. Does any one know a way to do this through COM and not through click the no button?

Where I'm pulling my info

http://msdn2.microsoft.com/en-us/library/bb220846.aspx


A decision is a powerful thing

Share this post


Link to post
Share on other sites



I understand that

$oExcel.AskToUpdateLinks = false

will automatically select yes and update the links. However, I want it to automatically select no, thus not updating the links. Does any one know a way to do this through COM and not through click the no button?

Where I'm pulling my info

http://msdn2.microsoft.com/en-us/library/bb220846.aspx

try setting AskToUpdateLinks to True and $oExcel.DisplayAlerts to False

1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

nope that doesn't work

thanks though!

btw, as you can see this COM method has enlightened me :whistle: Thank you SO much for that tip!!

Edited by JohnBailey

A decision is a powerful thing

Share this post


Link to post
Share on other sites

nope that doesn't work

thanks though!

btw, as you can see this COM method has enlightened me :whistle: Thank you SO much for that tip!!

always glad to help, i'll look into it a little bit more and see if we can't get this working.... do you have a sample spreadsheet to use for testing?

1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

Share this post


Link to post
Share on other sites

Here are the example files

test

test2

test.xls updates from test2.xls

There are no macros just the formula for updating. I'm working on figuring this out to. It is important that I figure it out besides the fact that I'm curious.


A decision is a powerful thing

Share this post


Link to post
Share on other sites

Here are the example files

test

test2

test.xls updates from test2.xls

There are no macros just the formula for updating. I'm working on figuring this out to. It is important that I figure it out besides the fact that I'm curious.

i'm going to start playing with it now, but i only have about 30 minutes until lunch. i'll try to figure something out before i go.

1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

Share this post


Link to post
Share on other sites

The reason DisplayAlerts won't work for accomplishing this task (I believe) is as follows:

"The default value is True. Set this property to False if you dont want to be disturbed by prompts and alert messages while a macro is running; any time a message requires a response, Microsoft Excel chooses the default response."

-http://msdn2.microsoft.com/en-us/library/bb177478.aspx


A decision is a powerful thing

Share this post


Link to post
Share on other sites

The reason DisplayAlerts won't work for accomplishing this task (I believe) is as follows:

"The default value is True. Set this property to False if you dont want to be disturbed by prompts and alert messages while a macro is running; any time a message requires a response, Microsoft Excel chooses the default response."

-http://msdn2.microsoft.com/en-us/library/bb177478.aspx

i was working on breaking the link before opening, but was getting prompted anyway, even with display alerts off. so i looked into it a little, and remembered something....

with workbooks.open() the second parameter is the update links parameter, so something like this would do what you want....

$oex = ObjCreate("excel.Application")
$mywb = $oex.workbooks.Open("u:\test.xls",False)

would open and not link.


1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

Share this post


Link to post
Share on other sites

THAT'S IT!!!!!!!! :whistle:

Do you know where there is an explanation of what the second parameter means and any additional parameters?


A decision is a powerful thing

Share this post


Link to post
Share on other sites

THAT'S IT!!!!!!!! :whistle:

Do you know where there is an explanation of what the second parameter means and any additional parameters?

glad i could help

1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0