Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find sheet
I have a small marco that loads data from a file from another application
into a workbook in Excel 2003. Sometimes the number of rows exceeds the 65,000+ cap so the remaining data spills over to a second sheet, sometimes not. I need a line or two that looks for sheet2: if it finds id it copies all the data from sheets 1 & 2. If there is no sheet 2, the procedure continues and it loads sheet 1. Nothing I try seems to work. I am a beginner with VBA. -- stan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find sheet
Stan,
Have a look he http://www.cpearson.com/excel/ImportBigFiles.aspx DB "stan" wrote in message ... I have a small marco that loads data from a file from another application into a workbook in Excel 2003. Sometimes the number of rows exceeds the 65,000+ cap so the remaining data spills over to a second sheet, sometimes not. I need a line or two that looks for sheet2: if it finds id it copies all the data from sheets 1 & 2. If there is no sheet 2, the procedure continues and it loads sheet 1. Nothing I try seems to work. I am a beginner with VBA. -- stan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find sheet
Dim myWS as excel.worksheet
on error resume next Set myWS = ActiveBook.Worksheets("Sheet2") on error goto 0 if myws is nothing then MSgbox("There is no Sheet2") end if 'Alternatively, you can try this if there are only two worksheets in the workbook. if ActiveBook.WOrksheets.count = 2 then Msgbox("There are two worksheets") elseif activebook.worksheets.count = 1 then Msgbox("There is one worksheet") end if HTH, Barb Reinhardt "stan" wrote: I have a small marco that loads data from a file from another application into a workbook in Excel 2003. Sometimes the number of rows exceeds the 65,000+ cap so the remaining data spills over to a second sheet, sometimes not. I need a line or two that looks for sheet2: if it finds id it copies all the data from sheets 1 & 2. If there is no sheet 2, the procedure continues and it loads sheet 1. Nothing I try seems to work. I am a beginner with VBA. -- stan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
find sheet
Works prefectly. Thank you.
-- stan "Barb Reinhardt" wrote: Dim myWS as excel.worksheet on error resume next Set myWS = ActiveBook.Worksheets("Sheet2") on error goto 0 if myws is nothing then MSgbox("There is no Sheet2") end if 'Alternatively, you can try this if there are only two worksheets in the workbook. if ActiveBook.WOrksheets.count = 2 then Msgbox("There are two worksheets") elseif activebook.worksheets.count = 1 then Msgbox("There is one worksheet") end if HTH, Barb Reinhardt "stan" wrote: I have a small marco that loads data from a file from another application into a workbook in Excel 2003. Sometimes the number of rows exceeds the 65,000+ cap so the remaining data spills over to a second sheet, sometimes not. I need a line or two that looks for sheet2: if it finds id it copies all the data from sheets 1 & 2. If there is no sheet 2, the procedure continues and it loads sheet 1. Nothing I try seems to work. I am a beginner with VBA. -- stan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value from one sheet and replace value in second sheet | Excel Programming | |||
macro to find data from one sheet & copy in another sheet | Excel Programming | |||
Find value in sheet 1 and copy matching row from sheet 2 | Excel Programming | |||
Find value from sheet 1 on sheet 2 and copy to an offset from there | Excel Programming | |||
how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming |