Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to the specified sheet in the workbook?
Hello,
I have asked that before to no reply, so I will rephrase my question below. Let say that: Book1.xls file contains 3 spreadsheets: Sheet1, Sheet2 and Sheet3 Book2.xls file contains 2 spreadsheets: Sheet1, Sheet2 My application's preferences window allows user to save preferred sheet as the sheet to be used by my app. How to do that? For example user wants to use Sheet2 from Book1.xls How to show that in the options window? File name: Book1.xls/Sheet2 ? Is there any standard regulating that? Your help appreciated, Jack |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refer to the specified sheet in the workbook?
On Wed, 19 Sep 2007 16:27:53 -0400, "Jack" <replyto@it wrote:
Hello, I have asked that before to no reply, so I will rephrase my question below. Let say that: Book1.xls file contains 3 spreadsheets: Sheet1, Sheet2 and Sheet3 Book2.xls file contains 2 spreadsheets: Sheet1, Sheet2 My application's preferences window allows user to save preferred sheet as the sheet to be used by my app. How to do that? For example user wants to use Sheet2 from Book1.xls How to show that in the options window? File name: Book1.xls/Sheet2 ? Is there any standard regulating that? If you refer to another book in a formula, it looks like this [Book1.xls]Sheet2 so that may be identifiable to the user. You'll have to parse it in your code, of course. -- Dick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
how do I refer a cell to workbook name not worksheet | Excel Discussion (Misc queries) | |||
Refer to more than one worksheet in a workbook | Excel Worksheet Functions | |||
how to I refer to current workbook without using its name? | Excel Worksheet Functions | |||
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X | Excel Programming |