| Thread | Last Post | Replies |
|
| Importing MS Word table to Excel | 28 Feb 2007 00:51 GMT | 1 |
I have a table in word that I need to import into Excel so that the content of each cell in the table is posted into a matching cell in Excel; i.e, the contents of a table cell are not split/entered into multiple cells in Excel.
|
| Change Cell Background Color Based On Search Results | 28 Feb 2007 00:48 GMT | 4 |
Hey Gang, I have a fairly generic calendar that I use as a team duty roster for about 30 people, which becomes quite busy as the months assignments are scheduled. What would help me immensely as I balance the assignments, is the ability to
|
| Macro to invoke mail merge from Excel | 27 Feb 2007 22:37 GMT | 2 |
I cannot seem to get this macro to work. I have a mail merge spreadsheet that I am adding an ActiveX button to perform the mail merge. I thought it would be fine to use late binding, but is that not a viable option? Sub DowngradeMerge() Dim wdApp As Object, wdDoc As Object ...
|
| Changing two way tables into one way tables | 27 Feb 2007 22:02 GMT | 5 |
Hello - I need to be able to 'undo' a two way table. The data is in this format: Student number English Grade Maths Grade US456 A B+
|
| callouts | 27 Feb 2007 18:53 GMT | 3 |
In excel can you create a callout with 2 points of reference? Somehow create one with 2 anchors? thanks
|
| Error message using DEata/Form | 27 Feb 2007 18:13 GMT | 1 |
Excel 2003. When I try to use Data/Form to add records to an existing table, I am suddenly getting the error message: "Cannot extend list or database." This table currently has 2599 records. I can add record 2600 using the data form, but none after that. Have I reached a limit
|
| Excel | 27 Feb 2007 15:41 GMT | 7 |
How do I find out if I have Excel on my computer?
 Signature Kathy
|
| How to accept input and then populate/concatenate this with other | 27 Feb 2007 15:38 GMT | 4 |
I need assistance with integrating the following within a macro I have. Ask the user to enter a 4 digit YEAR. Cell AM1 should be populated with the word Start. Cell AN1 should be populated with the word End.
|
| $ 500 (Dollar Five Hundred) how do i set up in excell | 27 Feb 2007 15:35 GMT | 3 |
I want to set up a formula in excell to display the numiric value in words value
|
| Sum not including writing | 27 Feb 2007 15:32 GMT | 2 |
Along with numbers, I have to put text into several cells, mainly astericks and some letters, but I also want to sum these cells. How do i sum the numbers and exclude the text? Please help!!
|
| How can I change from the exel file extention .xlsx to .xls ? | 27 Feb 2007 15:21 GMT | 2 |
How can I change from the exel file extention .xlsx to .xls ? Since the other users can not open .xlsx extention.
|
| Bug when calling sub within a sub | 27 Feb 2007 14:54 GMT | 3 |
I am calling a sub that includes the input parameters, aws, awb, owb, ows and mypattern (which is a string). We're having an inconsistent bug which appears to occur when the owb is already opened and we reopen it. Has anyone seen anything like this before and if so, what did ...
|
| UDF: How make volatile | 27 Feb 2007 13:40 GMT | 3 |
I have a UDF named exchangeRate (below): In a cell I have: =exchangeRate() At first entry this updates, refreshes or whatever properly, for
|
| Loop all Sheets not working. | 27 Feb 2007 11:55 GMT | 12 |
I have the following macro which I want executed for all worksheets within a book. I have tried it out and it only runs in the sheet that is selected, if I choose another sheet and run it, it runs.
|
| Multilne comment in an excel cell | 27 Feb 2007 07:35 GMT | 2 |
I've made an app in VB6 that allows export to excel. Everything works fine except for some multiline texts, he only displays ############ instead of the full text. I've also tried to correct the problem in the excelsheet itself to see
|