Protected View

[JerryH09]

Hi All,
When I scrape a file from the web it comes in "protected view". When I use the recorder for this being unprotected. I get:
application.activeprotectedview.edit=false. When I run this on a new file I get run time error 91. Not sure exactly what object I'm supposed to define and set. Help.
Regards
JerryH

 

[mole999]

when you run the code do you have the protectedview visible to you.

If not, you might add On Error Resume Next prior to that line so if there is nothing to do, you don't get an alert

 

[JerryH09]

when you run the code do you have the protectedview visible to you.

If not, you might add On Error Resume Next prior to that line so if there is nothing to do, you don't get an alert

Hi Mole999, This is the endstage of the last time you tried to help me. I've got hold of a data scraper and can get the data I want but in a protected view. This is the macro I'm running:
Sub test6()
'
' test6 Macro
'
On Error Resume Next
ActiveWindow.ActivateNext
application.ActiveProtectedViewWindow.Edit = False
ActiveWindow.ActivateNext
End Sub
. The ActivateNexts are because I'm looking at my main spreadsheet but want to unprotect my scraped file. Adding the on error resume next means the macro doesn't do anything. Would a copy of the scraped file be any use?
Regards,
JerryH09

 

[mole999]

if you have a cloud location to share through, that might help, somewhere free that doesn't require a user registration

 

[JerryH09]

if you have a cloud location to share through, that might help, somewhere free that doesn't require a user registration

Hi Mole999,
I have some cloud storage and one section is called public. I don't know how you'd access it. Do you have an email address I could send it to?
Regards,
JerryH09