Hello,

I want to read some data from currently active worksheet. Is there a way to
access active sheet from a web browser (using JS and COM)?
ActiveXObject("Excel.Application") creates another instance of Excel while I
want to get to one already open.
BTW, do Excel macros have to be written in VBA? I really don't like the
syntax of VBA. ;)


--
Pozdrawiam,
Kwas

I want to read some data from currently active worksheet. Is there a way
to
access active sheet from a web browser (using JS and COM)?

Not unless there is some security vulnerability from Microsoft that we don't
know about yet!!!
Most users on this forum probably don't appreciate hackers trying to fetch
personal data from their machines!

(My firewall will stop you anyway!)
--
Go away and stop bothering us!
Bill

"Bill Renaud" wrote in a message
...

Not unless there is some security vulnerability from Microsoft that we
don't know about yet!!!
Most users on this forum probably don't appreciate hackers trying to fetch
personal data from their machines!
(My firewall will stop you anyway!)

I've just managed to find that information on MS web site:
http://support.microsoft.com/default...b;EN-US;239470
My solution was intended to be used only on local machine (users would use
it only to export data from excel), but unfortunately I will have to figure
out something else. (Any suggestions appreciated.)
Thanks anyway.

My solution was intended to be used only on local machine (users would use
it only to export data from excel)...

If your users are working in Excel and want to export data, why not use a
VBA macro in Excel? Is the exported data going to a web server or to a
file,etc.? How much data (entire worksheets or just a few cells here and
there)?

There should be plenty of help here on the newsgroup.

(Sorry about my original assumption about the original post.)
--
Regards,
Bill

"Bill Renaud" wrote in message
...

If your users are working in Excel and want to export data, why not use a
VBA macro in Excel? Is the exported data going to a web server or to a
file,etc.? How much data (entire worksheets or just a few cells here and
there)?

Data from Excel (one sheet - no more than a hundred rows) has to be exported
to another application using COM.
As I mentioned before I don't like VB syntax. That's why I was looking for
some method where I could use JScript. Moreover, I have a working JS code
(with a web browser interface) doing the thing from text files. But, just as
You said - I'm affraid I will have to write it as a VBA macro.


--
Regards,
Kwas

You might check Chip Pearson's web site for a routine to Export data to a
Text File:
http://www.cpearson.com/excel/imptext.htm#Export

Maybe the Microsoft KB article 242377 might have some useful info also (this
is outside my area of expertise, however).
INF: How to Use Data Transformation Services (DTS) (this is with Microsoft
SQL Server)
http://support.microsoft.com/default...b;en-us;242377
--
Regards,
Bill