Controlling an Excel File

M

M. Griffith

I am exporting data to an Excel file that is protected. How do I open the
protected file by VBA? How do I save it as unprotected?
 
M

Mr. Smith

Easiest way is to open the workbook then start a macro recording. Unprotect
the sheet and save or save as. stop recording the macro. Then do to the
Visual basic editor where you'll find the code that does it. with minor mods
you can implant it into your Access code.

if you have any further q's email me at: mr dot smith at trearc dot com

Mr. Smith
 
Top