question

BrenchleyDavidScott-3491 avatar image
0 Votes"
BrenchleyDavidScott-3491 asked BrenchleyDavidScott-3491 commented

What control is this and how do I activate it programatically

101326-image.png



This "Edit Anyway" button presents on a file opened from a sharepoint server ever since our upgrade to Office 365.
I open the file via an Excel macro.
I had previously and hope to be able to edit this file w/o user interaction.
I am able to locate the Window w/ FindWindow but I do not note a control to send a button click message ?
Any ideas ??
THANKS

windows-apioffice-vba-dev
image.png (318.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered BrenchleyDavidScott-3491 commented

Open the Excel file, start Macro recording, click on the "Edit anyway" and the lookup what was recorded ... nothing.
That's Excel internal, you can not access this security band.
You get that also in Excel sheets with data connection, e.g. to a Cube or an other Excel file; it's for security, would be bad if you can bypass it with VBA

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TY
Actually macro recording captured the .loclserverfile method, but if you attempt to run the macro it fails.
THANKS again for the response

0 Votes 0 ·