Jan 24, 2008 #1 lambin Programmer Jan 24, 2008 2 IT Hi anyone, I need to create an open password for excel files. What is the syntax in VBscript? Thanks
Jan 29, 2008 #2 nickpark Programmer Jan 17, 2002 517 GB Could you elaborate on what you require as that sentence didnt make sense to me. Upvote 0 Downvote
Jan 29, 2008 #3 dm4ever Technical User Jul 3, 2006 991 US objExcel.ActiveWorkbook.SaveAs FileName, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AddToMru, TextCodepage, TextVisualLayout, Local You may want to look at the documentation or use a Macro to record the commands you'll need. -------------------------------------------------------------------------------- dm4ever My philosophy: K.I.S.S - Keep It Simple Stupid Upvote 0 Downvote
objExcel.ActiveWorkbook.SaveAs FileName, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AddToMru, TextCodepage, TextVisualLayout, Local You may want to look at the documentation or use a Macro to record the commands you'll need. -------------------------------------------------------------------------------- dm4ever My philosophy: K.I.S.S - Keep It Simple Stupid