PDA

View Full Version : how to open protected view excel file using VBA macro



ss5412369
02-04-2016, 02:47 AM
Dear Friends,

i just want to open protect view excel (97-2003) file and copy sheet(1) data into my Macro Master File (O_Master.xlsb) but i'm unable to open this file....
Please provide a solution or some diff way to complete my task.

Thx
Sumit

mancubus
02-05-2016, 12:42 AM
welcome to the forum.

https://msdn.microsoft.com/en-us/library/office/ff822367.aspx
http://www.howtogeek.com/60310/enable-editing-for-all-office-2010-documents-by-disabling-protected-view/

?


Application.ProtectedViewWindows.Open Filename:="FullFileNameHere"
Application.ActiveProtectedViewWindow.Edit