malachyscullion
asked on
TExcelApplication Server and switching between Excel Worksheets
HELP PLEASE
I require to programmatically switch between two differently named Excel worksheets in the same workbook. The excel file is opened from an already existing template so adding new workbooks is not an option. The template is required due to further analysis required on the output data.
Help please!!!
Malachy Scullion
I require to programmatically switch between two differently named Excel worksheets in the same workbook. The excel file is opened from an already existing template so adding new workbooks is not an option. The template is required due to further analysis required on the output data.
Help please!!!
Malachy Scullion
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Figured out how to do it.......
WS := ExcelApplication1.Workshee ts.Item['s ample_work sheet_name '] as _Worksheet;
WS.Activate(lcidExcel);
Thanks
Malachy
WS := ExcelApplication1.Workshee
WS.Activate(lcidExcel);
Thanks
Malachy
ASKER
Is there a way of passing the worksheet name as a parameter to a function that changes focus to the selected worksheet?????
ie) excelapplication1.workshee
ie) WorkSheet := WorkBk.WorkSheets.Get_Item
most of the solutions i have seen already involve adding your own blank worksheets. this is not valid solution in my case!
thanks
Malachy