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. 5 6494
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" <De**********@yahoo.com> wrote in message
news:2d**************************@posting.google.c 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.
What does it have to do with tea and China(with JavaScript and Web)?
If you are looking for a JScript "hook" to VBA, you can do something
like this:
function openExcel() {
var Excel = new ActiveXObject("Excel.Application");
Excel.Visible = true;
Excel.Application.Workbooks.Open("C:\\MyBook.xls") ;
//...
}
It opens MyBook in the normal (read/write) mode like if you run it in
the conventional way. Of cource it works with security warnings, only on
Internet Explorer, and only on your own computer (or within a LAN, see
second optional parameter of ActiveXObject).
If you want to serve a book to Explorer over the Web, just use a regular
link <a href="http://..../MyBook.xls"> Of course you cannot save changes
back to server, but you can edit and save on your computer.
Post the code you have that doesn't work....
Tim
"Derek Richards" <De**********@yahoo.com> wrote in message
news:2d**************************@posting.google.c 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.
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" <sa******@pacbellremovethis.net> wrote in message news:<u1**************@TK2MSFTNGP11.phx.gbl>... Post the code you have that doesn't work....
Tim "Derek Richards" <De**********@yahoo.com> wrote in message news:2d**************************@posting.google.c 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.
I can bet your file will be opened in Read-Only as was in my cases.
"VK" <sc**********@yahoo.com> wrote in message news:<3f***********************@news.freenet.de>.. . What does it have to do with tea and China(with JavaScript and Web)?
If you are looking for a JScript "hook" to VBA, you can do something like this:
function openExcel() { var Excel = new ActiveXObject("Excel.Application"); Excel.Visible = true; Excel.Application.Workbooks.Open("C:\\MyBook.xls") ; //... } It opens MyBook in the normal (read/write) mode like if you run it in the conventional way. Of cource it works with security warnings, only on Internet Explorer, and only on your own computer (or within a LAN, see second optional parameter of ActiveXObject).
If you want to serve a book to Explorer over the Web, just use a regular link <a href="http://..../MyBook.xls"> Of course you cannot save changes back to server, but you can edit and save on your computer. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Phil Powell |
last post by:
if (is_array($_POST)) {
foreach ($this->getAssocSectionsObjArray($key, $dbAP) as
$obj) {
print_r($obj); print_r(" in array? ");
print_r(in_array($obj, $result)); print_r("<P>");
if...
|
by: M.E. |
last post by:
I have following not working it report that I have
Can't find string terminator "STR" anywhere before EOF at init.pl line 50.
Compilation failed in require at /s101/home4/sgiwedding/cgi/form.pl...
|
by: Jon Jagger |
last post by:
I was thinking about how you can only use sizeof to find the size of an
unmanaged type. I started to wonder if there was a way to find the size of a
managed object and came up with the following....
|
by: i.r.f. |
last post by:
Recently I ran into a problem that I traced to something which completely
surprised me: the relative order of stack unwinding and finally block
execution in mixed C++ appears to vary depending on...
|
by: Norman Yuan |
last post by:
In my cuurent ASP.NET project, a weird thing happens: when I test-run the
project and a uncatched run error occurs, VS quits the test-run, as
expected. If I try to run the project again (either...
|
by: one man army |
last post by:
Hi All-
I am new to PHP. I found FAQTS and the php manual. I am trying this
sequence, but getting 'no zip string found:'... PHP Version 4.4.0
$doc = new DomDocument;
$res =...
|
by: Extremest |
last post by:
I know there are ways to make this a lot faster. Any
newsreader does this in seconds. I don't know how they do
it and I am very new to c#. If anyone knows a faster way
please let me know. All...
|
by: JohnQ |
last post by:
(The "C++ Grammer" thread in comp.lang.c++.moderated prompted this post).
It would be more than a little bit nice if C++ was much "cleaner" (less
complex) so that it wasn't a major world wide...
|
by: dp_pearce |
last post by:
I have some code that takes data from an Access database and processes
it into text files for another application. At the moment, I am using
a number of loops that are pretty slow. I am not a...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |