Accessing/Editing an Excel Worksheet

[SirLars]

i am working on a vb program to enter information into an excel worksheet...

i have a function to retrieve a value from a specific cell

GetCellValue(strCellAddress)

and a subroutine to ENTER a value into a specific cell
PutCellValue(strCellAddress,strCellValue)

but i am having problems

how do i instantiate the worksheet? i have the workbook name and worksheet name as global variables w/in the project

dim goExcel as excel.application
dim goBook as excel.workbook
dim goSheet as excel.worksheet

set gosheet = new gobook(strfilename).worksheet(strWorksheetname)

it doesn't accept any of this at all?

any suggestions would be greatly appreciated

 

[johnwm]

Set goExcel = GetObject("", "excel.application&quot
Set goBook = objexcel.Workbooks(strfilename)
Set goSheet = ActiveSheet

Then deal with range object:
Dim goRange as Excel.Range
Set goRange = goSheet.Range("a1", "a2&quot ' values to suit your app

You can then reference cells by:
goRange.Cells(xref,yref) = YourVariable 'xref and yref are offsets from start of range Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'