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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com