Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation:Selecting a different worksheet from another excel work
Hello,
I have written the following code: Dim appExcel as Excel.Application Dim xlwb as Excel.Workbook Set appExcel = New Excel.Application Set xlwb = appExcel.Workbooks.Open("\\F0862P1\share\complianc e\orderedbed\issues log.xls") intTrackingNumber = xlwb.Worksheets(5).Range("A2").Value xlwb.Worksheets(3).Range("A1").Select Currently, the active worksheet in issues log.xls is the first worksheet. I need it to select the 3 worksheet but it errors out on the last line of code listed above giving me the "Select Method of range class failed.". If I go into the issues log.xls workbook and save it when the 3rd worksheet is the active sheet, the above code works fine. Does anyone have an idea what im doing wrong? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation:Selecting a different worksheet from another excel work
You can only select a range on a worksheet that is selected.
You can only select a worksheet if the workbook is active. You could use xlwb.activate xlwb.worksheets(3).select xlwb.worksheets(3).range("a1").select or appexcel.goto xlwb.worksheets(3).range("a1") ', scroll:=true 'or false But for most things, you don't need to select the range to work with it. xlwb.worksheets(3).range("a1").value = "hi" mattieflo wrote: Hello, I have written the following code: Dim appExcel as Excel.Application Dim xlwb as Excel.Workbook Set appExcel = New Excel.Application Set xlwb = appExcel.Workbooks.Open("\\F0862P1\share\complianc e\orderedbed\issues log.xls") intTrackingNumber = xlwb.Worksheets(5).Range("A2").Value xlwb.Worksheets(3).Range("A1").Select Currently, the active worksheet in issues log.xls is the first worksheet. I need it to select the 3 worksheet but it errors out on the last line of code listed above giving me the "Select Method of range class failed.". If I go into the issues log.xls workbook and save it when the 3rd worksheet is the active sheet, the above code works fine. Does anyone have an idea what im doing wrong? Thanks! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation:Selecting a different worksheet from another excel
Thanks Dave,
appexcel.goto xlwb.worksheets(3).range("a1") ', scroll:=true 'or false Worked like a charm. "Dave Peterson" wrote: You can only select a range on a worksheet that is selected. You can only select a worksheet if the workbook is active. You could use xlwb.activate xlwb.worksheets(3).select xlwb.worksheets(3).range("a1").select or appexcel.goto xlwb.worksheets(3).range("a1") ', scroll:=true 'or false But for most things, you don't need to select the range to work with it. xlwb.worksheets(3).range("a1").value = "hi" mattieflo wrote: Hello, I have written the following code: Dim appExcel as Excel.Application Dim xlwb as Excel.Workbook Set appExcel = New Excel.Application Set xlwb = appExcel.Workbooks.Open("\\F0862P1\share\complianc e\orderedbed\issues log.xls") intTrackingNumber = xlwb.Worksheets(5).Range("A2").Value xlwb.Worksheets(3).Range("A1").Select Currently, the active worksheet in issues log.xls is the first worksheet. I need it to select the 3 worksheet but it errors out on the last line of code listed above giving me the "Select Method of range class failed.". If I go into the issues log.xls workbook and save it when the 3rd worksheet is the active sheet, the above code works fine. Does anyone have an idea what im doing wrong? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro: Selecting items from another worksheet withoutactivating it | Excel Programming | |||
Automation : Excel::Font : get_Font does not work | Excel Programming | |||
Selecting an Excel tab, Delete Worksheet command is not active | New Users to Excel | |||
Problem with optional parameters in Excel Automation Add-in worksheet function | Excel Programming | |||
How to insert Excel Worksheet Name using Automation in VB Dot Net?? | Excel Programming |