Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using dedicated spreadsheet
Hello,
I am not Excel programmer, I just use Excel automation to hook my application up to Excel. The problem I have is that I do not know which options should I offer to the user if he wants to use a dedicated (the specified title) spreadsheet. If the .xls file contains only one spreadsheet the selection is obvious. The name of the .xls file will be set in the application options. However, if the .xls file contain several spreadsheets, how the offered option to the user should look like? Something like this: ---- select workbook ----that will be the .xls file ---- select sheet ----- that will be selected spreadsheet ? If that is correct, won't it be confusing for the user who has only 1 spreadsheet to deal with ? Your comments appreciated, Jack |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using dedicated spreadsheet
Test the workbook for number of sheets with
If Activeworkbook.Sheets.count =1 Then 'offer nothing Else loop thru sheets and offer a list of names End If Mike F "Jack" <replyto@it wrote in message ... Hello, I am not Excel programmer, I just use Excel automation to hook my application up to Excel. The problem I have is that I do not know which options should I offer to the user if he wants to use a dedicated (the specified title) spreadsheet. If the .xls file contains only one spreadsheet the selection is obvious. The name of the .xls file will be set in the application options. However, if the .xls file contain several spreadsheets, how the offered option to the user should look like? Something like this: ---- select workbook ----that will be the .xls file ---- select sheet ----- that will be selected spreadsheet ? If that is correct, won't it be confusing for the user who has only 1 spreadsheet to deal with ? Your comments appreciated, Jack |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using dedicated spreadsheet
Thank you,but it is not what I am asking for.
I am talking about Options (Preferences) window where user goes to set his preferences. At that time the Excel may be not opened yet. Jack "Mike Fogleman" wrote in message m... Test the workbook for number of sheets with If Activeworkbook.Sheets.count =1 Then 'offer nothing Else loop thru sheets and offer a list of names End If Mike F "Jack" <replyto@it wrote in message ... Hello, I am not Excel programmer, I just use Excel automation to hook my application up to Excel. The problem I have is that I do not know which options should I offer to the user if he wants to use a dedicated (the specified title) spreadsheet. If the .xls file contains only one spreadsheet the selection is obvious. The name of the .xls file will be set in the application options. However, if the .xls file contain several spreadsheets, how the offered option to the user should look like? Something like this: ---- select workbook ----that will be the .xls file ---- select sheet ----- that will be selected spreadsheet ? If that is correct, won't it be confusing for the user who has only 1 spreadsheet to deal with ? Your comments appreciated, Jack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Hosting, Reseller Hosting, and Dedicated Hosting!!!!!! | Excel Worksheet Functions | |||
Group data and maintain grouped data on dedicated pages | Excel Worksheet Functions | |||
my own dedicated mvp | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |