| Thread | Last Post | Replies |
|
| Attach object (eg image) to worksheet | 27 Mar 2006 16:08 GMT | 3 |
I have a basic question, is it possible to attach an object (e.g. a jpg or gif image) to a worksheet in order have it included in the excel file? The underlying idea is to write a code that accesses an image stored
|
| How to extract data from Word Form into Excel | 27 Mar 2006 16:05 GMT | 1 |
I have created a Form named abc.dot in Word. A respondent fills in the form, and saves the file as abc-01.doc and sends it to me. And likewise, from other respondents I get files named abc-02.doc, abc-03.doc, etc.
|
| Macro needed to delete rows | 27 Mar 2006 16:00 GMT | 4 |
I have a list of numbers that I want to narrow down to unique numbers....in other words, I want to delete the row if a number show is already displayed elsewhere. Example list:
|
| Generate document folders for Excel list. | 27 Mar 2006 15:35 GMT | 6 |
I have a need to generate separate folders in a directory using a colum list in Excel. I want the program to take an Excel file wit descriptions in each row (column A only) and generate separate folder with the descriptions being the folder name. Would generate anywher
|
| Flashing TextBox | 27 Mar 2006 15:27 GMT | 1 |
Dim x As Integer Dim OrigColor As Integer Dim NewColor As Integer Dim CellToFlash As Range
|
| Flashing UserForm Label | 27 Mar 2006 15:20 GMT | 1 |
Dim x As Integer Dim OrigColor As Integer Dim NewColor As Integer Dim CellToFlash As Range
|
| Finding values within an array | 27 Mar 2006 15:12 GMT | 1 |
Is there a neater/faster way than having to use worksheet functions and iterating through an array to find values. my example - I have an array containing the following: AAAA ZZ 0001
|
| CountIf function query | 27 Mar 2006 14:52 GMT | 2 |
Is it possible to use the CountIF function to return the number of cells in a specific range which have a particular interior colour regardless of the value content of the cell? If so what information should be used in the 'Criteria' section of the
|
| Specifying a result for a Drop Down Box | 27 Mar 2006 13:38 GMT | 2 |
I would like to create some VBA that changes the result for a drop down to a result of 2. (There are only two options Yes (1) and No (2) I know how to select the Drop down... ActiveSheet.Shapes("Drop Down 2").Select
|
| .ControlSource | 27 Mar 2006 13:16 GMT | 1 |
I have this bit of code in a macro With C5B_UserForm.ComboBox1 RowSource = mSource ControlSource = Worksheets("Template").Range("X4")
|
| Make a Word event macro fire in active document | 27 Mar 2006 13:00 GMT | 2 |
This is a cross post originally to a Word programming group. Unfortunately, you can practically see the tumbleweed blowing down the main street of the Word groups... If anyone in here could answer this I'd be most grateful:
|
| Help, Ill try to explain my problem. | 27 Mar 2006 12:30 GMT | 3 |
I have a problem in Excel that I hope someone can help me with. I have a sheet that looks like a data base, id number, name, age, city is the kolumns name. Now i would like the same information on a different sheet but in a
|
| Import from SQL Server using an embedded formula | 27 Mar 2006 11:46 GMT | 2 |
I'm trying out importing data into excel from an SQL server database. So far it's great but there is one thing I can't do - calculating an embedded formula. The query looks something like:
|
| Need Code to rename standard modules | 27 Mar 2006 11:36 GMT | 5 |
Can someone kindly help me out with a code to *rename* standard modules? I have googled in vain for leads. Even Chip Pearson seemed to have miss this one in his comprehensive coverage of codings to manipulate VBComponents.
|
| need help for creating a macro | 27 Mar 2006 11:31 GMT | 4 |
Hi experts, I post this message a few days ago but received no answers. I am sure there are people here who can suggest solutions about my problem. Maybe I should repeat my question again.
|