Excel and web browser

  • Thread starter Marcin Kwa¶niewski
  • Start date
M

Marcin Kwa¶niewski

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

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)?
Click to expand...

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

Marcin Kwa¶niewski

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!)
Click to expand...

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

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

Marcin Kwa¶niewski

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)?
Click to expand...

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

Marcin Kwa¶niewski

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
Click to expand...

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