Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Web Programming > JavaScript > Javascript How-To
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Javascript How-To Ask your "How do I do this with Javascript?" questions here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Javascript How-To section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 4th, 2005, 05:12 AM
Friend of Wrox
 
Join Date: May 2004
Location: , , .
Posts: 212
Thanks: 0
Thanked 0 Times in 0 Posts
Default Return Data from Excel 97 Range into table

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

__________________
\'sync\' <cr>
The name specified is not recognized as an internal or external command, operable program or batch file.
Reply With Quote
  #2 (permalink)  
Old March 4th, 2005, 05:39 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

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

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


--

Joe (Microsoft MVP - XML)
Reply With Quote
  #3 (permalink)  
Old March 4th, 2005, 06:26 AM
Friend of Wrox
 
Join Date: May 2004
Location: , , .
Posts: 212
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Thanks
interrupt

Reply With Quote
  #4 (permalink)  
Old March 4th, 2005, 07:14 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

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)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel XP and Excel 97 chiefouko Beginning VB 6 9 March 30th, 2007 03:32 AM
Displaying Excel data in a table badgolfer ASP.NET 1.0 and 1.1 Basics 6 January 6th, 2006 04:25 AM
Excel VBA: Select range of data and plot chart? xitu Excel VBA 1 December 23rd, 2003 04:21 AM
excel 97 & pivottable pilmart Excel VBA 1 November 18th, 2003 08:44 AM
Using Excel XP and Excel 97 chiefouko Excel VBA 3 August 27th, 2003 03:24 PM



All times are GMT -4. The time now is 10:44 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.