Subscribe Bookmark RSS Feed

How via JSL to import Excel data when the sheet is on the web?

jwubbel

Community Trekker

Joined:

Oct 26, 2011

I have tried to script access to retrieving data from an Excel spreadsheet that resides in a web location by various means unsuccessfully. Using the function Web(http..../myspreadsheet.xls) the sheet loads into Excel locally. However, I do not know of a way to follow this call with importing from that sheet when it is open. Is there any kind of a handle to this object once it is in memory to be able to extract data from the worksheets? I have also tried by keeping the spreadsheet in a web page. No cigar! It does not seem like you can get a Window handle to it. Any help or comments would be appreciated.