Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
gathering info & importing to another worksheet
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
gathering info & importing to another worksheet
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.x ls", _ UpdateLinks:=0, _ IgnoreReadOnlyRecommended:=True) Set oWorksheet = oWorkbook.Sheets("SheetName") ' update oWorksheet oWorkbook.Close (SaveChanges:=True) oExcel.Quit Phil Hibbs. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gathering Info on one sheet | Excel Discussion (Misc queries) | |||
Gathering data from worksheet | Excel Discussion (Misc queries) | |||
importing info from an email | Excel Discussion (Misc queries) | |||
Gathering info from saved files | Excel Programming | |||
Gathering info from a set of excel files | Excel Programming |