Excel and web browser

[=?iso-8859-2?Q?Marcin_Kwa=B6niewski?=]

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.

 

[Bill Renaud]

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!)

 

[=?iso-8859-2?Q?Marcin_Kwa=B6niewski?=]

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.aspx?scid=kb;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.

 

[Bill Renaud]

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.)

 

[=?iso-8859-2?Q?Marcin_Kwa=B6niewski?=]

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.

 

[Bill Renaud]

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.aspx?scid=kb;en-us;242377

 

[=?iso-8859-2?Q?Marcin_Kwa=B6niewski?=]

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.aspx?scid=kb;en-us;242377

Thanks for information. Anyway, I think the best choice will be to compell
myself to write it in VBA as Excel macro.