LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default Excel file format.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number Format on Excel File saved from .html file joyfulone Excel Discussion (Misc queries) 3 April 15th 09 12:07 AM
Convert Excel XLS file to Quickbooks QIF file format Paul Excel Discussion (Misc queries) 0 October 22nd 07 10:46 PM
cannot open excel file - says invalid file format - what to do? excelless diane Excel Discussion (Misc queries) 2 November 8th 06 03:13 AM
How do I autosave a unique Excel file in the file format 03F67000 flyboy06 Setting up and Configuration of Excel 1 June 14th 06 11:11 PM
Error:Invalid File format,while opening an Excel Template file Saurabh Excel Programming 1 January 17th 05 07:15 AM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"