Return Data from Excel 97 Range into table

interrupt · March 4th, 2005, 05:12 AM

Hi Guys,

Is there any way to do this? I basically need the data from 12 cells (A1:B6) to be returned individually to cells in a table.

TIA
interrupt

joefawcett · March 4th, 2005, 05:39 AM

Didn't you ask a similar question before, what's changed?

http://p2p.wrox.com/topic.asp?TOPIC_ID=20116

--

Joe (Microsoft MVP - XML)

interrupt · March 4th, 2005, 06:26 AM

The excel file will be on a network drive this time Joe, not sure if the code will change?

Thanks
interrupt

joefawcett · March 4th, 2005, 07:14 AM

Well you could use the same code and just use a UNC instead of a URL, you wouldn't use the saveRemoteFile function. Remember to escape backslashes if hardcoding the path, e.g a UNC of \\MyServer\MyShare\myFile.xls would be:

Code:

var FILE_UNC = "\\\\MyServer\\MyShare\\myFile.xls";
<snip/>
var oWB = oExcel.workbooks.open(FILE_UNC);

Most modern versions of Excel can cope with UNC syntax.

--

Joe (Microsoft MVP - XML)