gathering info & importing to another worksheet

  • Thread starter Thread starter kennyhotboi
  • Start date Start date
K

kennyhotboi

i am trying to track my servers sales per hour and am needing to organize my
data from the week by their server numbers, sum each servers sales for the
week, and pull all of this data from a separate workBOOK. i can do the rest
of the formulas and set up myself, but the prior poses a problem for me...
can anyone help?

thanks!
 
Dim oExcel As Excel.Application
Dim oWorkbook As Workbook
Dim oWorksheet As Worksheet

Set oExcel = New Excel.Application
Set oWorkbook = oExcel.Workbooks.Open(FileName:="C:\WorkbookName.xls",
_
UpdateLinks:=0, _
IgnoreReadOnlyRecommended:=True)
Set oWorksheet = oWorkbook.Sheets("SheetName")

' update oWorksheet

oWorkbook.Close (SaveChanges:=True)
oExcel.Quit

Phil Hibbs.
--
 
Back
Top