Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically reading the excel sheet name--vbscript
Hi Jan Karel Pieterse,
Thanks allot! It worked. Regards Rishabh "Jan Karel Pieterse" wrote: Hi Rishabh, Above line of code does the cell (B2) click and fetch the data into a new sheet. I need to know in which sheet it displays the data. AFAIK, this action always inserts a new worksheet to the immediate left of the sheet the PT lives on, so: Sheets(Sheet2.index-1) should give you that sheet. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatically reading from Excel and formatting | Excel Programming | |||
how to access excel sheet programmatically????? | Excel Programming | |||
Removing Add-ins programmatically from Excel 2003 using VBScript | Excel Programming | |||
Inserting an Image in an Excel sheet using VBScript. | Excel Programming | |||
Programmatically reading data field values from PivotTable | Excel Programming |