| Thread | Last Post | Replies |
|
| question about FindWindow API call | 30 Mar 2008 15:55 GMT | 2 |
Is FindWindow a reliable way to determine if a particular application is currently running? I had been using Tasklist.exe to do this, but this program does not appear to be present on Windows XP Home systems.
|
| Pause Printing in VBA | 30 Mar 2008 10:48 GMT | 2 |
:) Hello!! I have written a Macro in VBA to print Invoices with data from an Excel Worksheet. But I have about 250 Bills to print. Could someone tell me how I can include a few more lines of code in my Macro that will
|
| Autoreference Code | 30 Mar 2008 08:49 GMT | 2 |
I have a sheet with a code. I would like to make multiple copies of this sheet, Is there a way to make the code change references automatically? for example:
|
| Help with the report needed | 30 Mar 2008 08:39 GMT | 1 |
I've got to get an urgent report ready for my teaching and I'm stuck. Here's what I have to do: Report sheet 1. create a combo box displaying subjects listed A1:A150 on the "my data
|
| What can inhibit an event handler? | 30 Mar 2008 01:32 GMT | 3 |
XL2003 on XP In one instance of Excel, I had two files open and then opened a third file that has a macro that should fire on workbook_open. For some reason, this macro did not run. I closed the third file and tried this twice more with no
|
| "ComboBox1.ListIndex = 0" Doesn't seem to always work. | 30 Mar 2008 01:28 GMT | 2 |
I have "ComboBox1" on a UserForm. In the Sub Form Initialize procedure, I have "ComboBox1.ListIndex = 0" hoping to set the ComboBox to Index 0 every time the Form is loaded. The problem is that maybe 50% of the time it loads up with the last selection instead. Am I doing ...
|
| Help with Calender Day colour | 30 Mar 2008 01:00 GMT | 2 |
Hi, I have an activeX calender embedded in my worksheet what I am trying to acheive is to get each wednesday of the month to shade to a different colour so that they standout. If you can help I would be grateful many thanks Joel
|
| Excel automation: Why my code is hijacked? | 30 Mar 2008 00:24 GMT | 12 |
I have this routine to disconnect from Excel: Public Sub XLDisconnectFromExcel() If Not moExcelWS Is Nothing Then Set moExcelWS = Nothing If Not moExcelApp Is Nothing Then Set moExcelApp = Nothing
|
| Excel columns: Converting numbers to letters and vice versa | 29 Mar 2008 22:17 GMT | 15 |
My app is using Excel spreadsheet. User has a choice of preselecting some of the sheet's columns. Now: Excel is using letters as the visual indexing, of the columns but when
|
| Variable within a formula | 29 Mar 2008 21:55 GMT | 9 |
I would like to set a formala in a cell that would vary based on the value of an another cell. The end result should look like: ='040208'!A1+C4 with 040208 being the value of the cell in question.
|
| vba; copy row, paste at offset | 29 Mar 2008 20:44 GMT | 2 |
I have a row copied to the clipboard, and I want to paste it into sheetB at rowR, colC. I can do the paste if I select the entire row, but that's now what I want. Thank you.
|
| Invoice Numbering | 29 Mar 2008 19:01 GMT | 8 |
I am creating a template for invoices. I want it to automatically fill in the invoice number in cell C5 each time I open it, just one number higher than the last one. I also want it to automatically save to a folder on my desktop called "Invoices". How can I do this with VB?
|
| Excel 2003 automated instead of Excel 2007 | 29 Mar 2008 16:57 GMT | 3 |
I have Excel 2003 and 2007 installed on the same machine. I'm trying to automate Excel 2007, but everything I seem to do ends up in Excel 2003. I have a file (XLSX) which was made in Excel 2007 and I'm trying to open it
|
| Sub to iterate thru combo box n copy paste n name ranges successively in a new sht | 29 Mar 2008 16:25 GMT | 11 |
Sorry, I'm posting this query again as there was an OE error received just now ---------------- In a sheet: Z
|
| Query with Excel VBA Find Method | 29 Mar 2008 13:35 GMT | 5 |
I have the following code that searches for a particular string in column K and repeats the process until all have been found (or that's what I intended). In one workbook, the first instance is found at K330 with the next 8
|