| Thread | Last Post | Replies |
|
| Adding custom list and text boxes to the custom tool bar from Excel C API | 08 Aug 2007 19:54 GMT | 2 |
I am developing an addin excel using Excel C API. I want to know is there any way to add custom list and text boxes to the custom tool bar from Excel C API? If yes how can we do it? Any help would be greatly appreciated.
|
| Making a button in an Excel Spreadsheet to export to another | 08 Aug 2007 19:52 GMT | 1 |
I have a spreadsheet that is pretty much static with the exception of approximately 15 fields. Changing those 15 fields will change the entire sheet (and several pages within the sheet). I would like to create a button on my Excel spreadsheet that will simply export all of the ...
|
| generate randomly assigned lists | 08 Aug 2007 19:19 GMT | 6 |
I have a list of 36 names, we would like to be able to generate lists of randomly assigned groups such as 3 groups of 12 names or 4 groups of 9 names, etc. Needs to be completely random assignments. Is there a quick way to do this with excel 2003?
|
| Calculate time in hours between two dates | 08 Aug 2007 19:16 GMT | 7 |
I have see a lot of wonderful information on how to get work hours between two dates. Everything from UDF to formulas that are as long as my arm. What I need is a little confusing, at least to me. I need to know the difference in hours between two dates, excluding weekends
|
| Unwanted Auto-Fill Options Box | 08 Aug 2007 19:13 GMT | 6 |
Whenever I drag a cell down for Auto-Fill, I get an Auto-Fill options box. How do I get rid of this unwanted feature? Excel 2003. TIA, James
|
| Saving spreadsheet with a Macro (VB) | 08 Aug 2007 18:08 GMT | 2 |
Hi all. I am trying to write some VBasic code within Excel to save to the path as follows: C:\Documents and Settings\USERNAME\My Documents I know in windows world you would use %HOMEDRIVE%%HOMEPATH%My Documents, but
|
| random crash | 08 Aug 2007 17:24 GMT | 3 |
Hi all, I have a customer working in Excel for various things, but one of them is his price list. Right now he as Office 2003 installed with SP2 (11.8142.8132). As far as I know, the updates are all done (he's got Microsoft Update installed).
|
| excel - mr.frankie | 08 Aug 2007 17:17 GMT | 4 |
what is the difference between relative and absolute addressing?
|
| v lookup | 08 Aug 2007 16:26 GMT | 2 |
I am inexperienced with excel so any suggestions are welcomed. I have two different spreadsheets with columns of name, hours worked, total wages. Each name has a different row for each type of wage. A person can have several rows. There are no subtotals. I want to know how to ...
|
| Formating numbers as percents | 08 Aug 2007 16:18 GMT | 4 |
Issue: I've got a string of numbers that I need to change the format of in excel (i.e. 3.52, -2.6, 0.22, 2.82 etc...) They are currently formated as numbers and I need them in percents(%). When I select a cell and
|
| Better performance: Vista w/4gb RAM or XP w/3GB RAM | 08 Aug 2007 15:34 GMT | 10 |
I use Excel for operations and financial modeling; my spreadsheets are large and have many named ranges, lookups and array functions. I'm currently using a Pentium M 1.2 machine with XP and 2GB of RAM, and it's barely adequate for the work.
|
| Exclude Data | 08 Aug 2007 15:16 GMT | 2 |
I'm trying to exclude some data in my access table, but the code bellow doesn't work. I need that excel to exclude all data in the table that contains a criteria in two range of excel. For example:
|
| Question on sorting | 08 Aug 2007 14:56 GMT | 8 |
I have a spreadsheet that contains 3 columns: Col A = Names Col B = Dates of Birth Col C = An Assigned Password
|
| Help! Arrow keys scroll, but don't change selection??!? | 08 Aug 2007 14:38 GMT | 5 |
All of a sudden, my XL 2003 stopped letting me use the arrow keys to change the cell selection. I can still scroll left / right / up / down through the window using the keys, but the cell selection doesn't change. Ctrl+Home takes me to A1 and selects it, Ctrl+End acts the
|
| Auto Format Change | 08 Aug 2007 12:57 GMT | 2 |
Re Excel 2002. I have a colleague in accounts. She has a spreadsheet of bank details. She formats her sort codes to text (an example is 20-40-70) and then saves as a CSV file. When she then opens the CSV file, some of the sort codes have
|