This media is not supported in your browser
VIEW IN TELEGRAM
GmoTp.gif (734×494)
VBA code to open password protected Excel workbook:
Workbooks.Open "C:\Users\win10\Desktop\test.xlsx", , , Password:="12345"
Workbooks.Open "C:\Users\win10\Desktop\test.xlsx", , , Password:="12345"
Hi friends if you like below video and want to practice it, I am sharing Master sheet for VBA Macro for data collation. Download it and you can learn and can also use it by modifying as per your requirement. Thank you. https://youtu.be/5XrWYyo0sTo
loop through all files in folder.xlsm
23.9 KB
Masterfile with VBA Code
Ms Excel and VBA Macros💻⌨️🖥
https://youtu.be/-yno3DutdeU
getfile.xlsx
12.5 KB
Get list of files from folder with out VBA
Ms Excel and VBA Macros💻⌨️🖥
getfile.xlsx
Hi friends, you can download this for learning . I hope you will find this helpful.
@professor
I think This might help you. https://www.techrepublic.com/article/how-to-work-with-protected-view-in-microsoft-office/
I think This might help you. https://www.techrepublic.com/article/how-to-work-with-protected-view-in-microsoft-office/
TechRepublic
How to work with Protected View in Microsoft Office
Microsoft's Protected View feature tries to protect you against potentially malicious files and documents. Here's how to use it.