Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i am using the code below, i am coming in after this was already built. it
appears that fileformat 16 will not let me password protect the sheet. is there a way around this? what is file format 16? i tried oBackLog.SaveAs(cblfile,16,12345) but the sheet was not protected. so im lost. osheet.protect("12345") if File(Cblfile) Erase(Cblfile) endif if nform = 2 oBackLog.SaveAs(cblfile,16) endif if nform = 5 oBackLog.SaveAs(cblfile,43,) endif if nform = 0 oBackLog.SaveAs(cblfile,-4143) endif |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
Convert Excel XLS file to Quickbooks QIF file format | Excel Discussion (Misc queries) | |||
cannot open excel file - says invalid file format - what to do? | Excel Discussion (Misc queries) | |||
How do I autosave a unique Excel file in the file format 03F67000 | Setting up and Configuration of Excel | |||
Error:Invalid File format,while opening an Excel Template file | Excel Programming |