Home |
Search |
Today's Posts |
#1
Posted to comp.lang.javascript,microsoft.public.excel.programming
|
|||
|
|||
Can anyone find what is wrong with the following?
The following syntax is what I found under the Help in Excel's VBA
Editor (you may refer to it for the details of each parameter). i specified to open in Write mode (Read Only is false), it doesn't do the way as I wished to open in Write mode. Instead, still saw (Read Only) above the MenuBar on the upper left corner when an excel file is opened. Syntax expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU) Here I care nothing else but opening a file in Read & Write. How to specify the parameters to open in Read & Write in javascript given the syntax? Thanks very much. |
#2
Posted to comp.lang.javascript,microsoft.public.excel.programming
|
|||
|
|||
Can anyone find what is wrong with the following?
In vba, you would leave arguments blank in a comma separated list
Workbooks.Open(myFile,,false,,,,true) I don't know what the rules are for Javascript. -- Regards, Tom Ogilvy "Derek Richards" wrote in message om... The following syntax is what I found under the Help in Excel's VBA Editor (you may refer to it for the details of each parameter). i specified to open in Write mode (Read Only is false), it doesn't do the way as I wished to open in Write mode. Instead, still saw (Read Only) above the MenuBar on the upper left corner when an excel file is opened. Syntax expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU) Here I care nothing else but opening a file in Read & Write. How to specify the parameters to open in Read & Write in javascript given the syntax? Thanks very much. |
#3
Posted to comp.lang.javascript,microsoft.public.excel.programming
|
|||
|
|||
Can anyone find what is wrong with the following?
Post the code you have that doesn't work....
Tim "Derek Richards" wrote in message om... The following syntax is what I found under the Help in Excel's VBA Editor (you may refer to it for the details of each parameter). i specified to open in Write mode (Read Only is false), it doesn't do the way as I wished to open in Write mode. Instead, still saw (Read Only) above the MenuBar on the upper left corner when an excel file is opened. Syntax expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU) Here I care nothing else but opening a file in Read & Write. How to specify the parameters to open in Read & Write in javascript given the syntax? Thanks very much. |
#4
Posted to comp.lang.javascript,microsoft.public.excel.programming
|
|||
|
|||
Can anyone find what is wrong with the following?
Hi Tim, thanks.
Here it is. e.Workbooks.Open(strFileName, null, false, null, null, null, true); However, the file is still opened in Read-Only. How strange it is! Any suggestions? "Tim Williams" wrote in message ... Post the code you have that doesn't work.... Tim "Derek Richards" wrote in message om... The following syntax is what I found under the Help in Excel's VBA Editor (you may refer to it for the details of each parameter). i specified to open in Write mode (Read Only is false), it doesn't do the way as I wished to open in Write mode. Instead, still saw (Read Only) above the MenuBar on the upper left corner when an excel file is opened. Syntax expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU) Here I care nothing else but opening a file in Read & Write. How to specify the parameters to open in Read & Write in javascript given the syntax? Thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace is going wrong in some cases | Excel Discussion (Misc queries) | |||
What is wrong? | Excel Discussion (Misc queries) | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
How to stop Excel from doing wrong Find/Replace | Excel Discussion (Misc queries) | |||
Getting wrong value due to ref? | Excel Discussion (Misc queries) |