Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. matfishe

    error Object Required: 'ActiveCell.Resize(...).Slect' and sum not wor

    I changed it but now Im getting the error " object doesnt support this property or method: 'Selection' " 'Declare variables and open excel then open the specified file dim objExcel005, ExcelWB005, osheet005, objRange set objExcel005 = createobject("Excel.Application") objExcel005.visible =...
  2. matfishe

    Any resources for VBScript with Excel?

    Hi, I have some experience with VBScript but not as much when I use it with Excel. I was just wondering if anyone would know of any books or sites that wounld have information on how to use VBScipt with Excel?? Thanks in advance!
  3. matfishe

    error Object Required: 'ActiveCell.Resize(...).Slect' and sum not wor

    Thanks. I added in the lines you suggested but its only doing as far as the line "objExcel005.ActiveCell(1, 3).Select". I not getting anymore errors but its just not selecting the 3 lines I need copied. Heres the code so far: 'Declare variables and open excel then open the specified file dim...
  4. matfishe

    error Object Required: 'ActiveCell.Resize(...).Slect' and sum not wor

    Hello, Im getting the error " Object Required: 'ActiveCell.Resize(...).Slect' ". My code looks like this: 'Declare variables and open excel then open the specified file dim objExcel005, ExcelWB005, osheet005 set objExcel005 = createobject("Excel.Application") objExcel005.visible = true set...

Part and Inventory Search

Back
Top