Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using FSO to get Excel data
I hope there is an easy answer to this!
I have an active server page which dynamically shows all files in a directory. Based on the file name, using FSO, I use the first 5 chars to create a link to another tool and MID to gather other info from the title which helps populate other table cells. My question is this: Is there a way using VBScript to grab the value of a certain cell within the spreadsheet? Thanks in advance for any help!! Regards, Rusty |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using FSO to get Excel data
Rusty
You can use ADO to query ranges in closed excel files without the need for excel to be installed on the server. sPath = "D:\TestDB.xls" Dim vTemp(4),i Set oCon = CreateObject("ADODB.Connection") Set oRst = CreateObject("ADODB.Recordset") oCon.Open _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Extended Properties=Excel 8.0;Data Source=" & sPath oRst.Open "SELECT * FROM [Sheet1$A1:A4]", oCon, 3 'do your stuff... If oRst.State Then oRst.Close If oCon.State Then oCon.Close Set oRst = Nothing Set oCon = Nothing Plenty to google on ADO in this group and elsewhere.. HTH -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam RustyR wrote : I hope there is an easy answer to this! I have an active server page which dynamically shows all files in a directory. Based on the file name, using FSO, I use the first 5 chars to create a link to another tool and MID to gather other info from the title which helps populate other table cells. My question is this: Is there a way using VBScript to grab the value of a certain cell within the spreadsheet? Thanks in advance for any help!! Regards, Rusty |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using FSO to get Excel data
EXCELLENT! Thank you very much!
Rusty *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Write Macro to Fix Data Alignment (Data dump from Crystal to Excel | Excel Discussion (Misc queries) | |||
Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
Eliminating rows of data in excel spreadsheet that have blank cell in row A and data in row B - E | Excel Programming |