Programming

Macro help needed
Is there anyway to write a macro to open several or all web hyperlinks on a single or multiple worksheets and update the web links if the page is no longer valid. If not able to obtain new page address provide details on which links are no longer valid. Thanks! ... 25 Mar 2010 18:37

add cells
I have this to start Sub Total() Range("D1").Value = Range("E1").Value + Range("F1").Value What do I have to add to this so it continues down 500 rows (D500 = E500 +D500) Thanks in advance! ... 25 Mar 2010 16:16

Problem with workbook on_open event
I have a call to an addtoolbar() sub in my workbook on_open event. When i first open the workbook, no toolbar added; if i close and reopen the workbook the toolbar appears. ... 25 Mar 2010 13:50

How do I open a com port using Excel visual basic
Has anybody got any code that would help me ... 25 Mar 2010 13:50

Auto_Open Macro
I have several auto_open macros that were created with Excel 2003. To enable the macro and preventing it from running, I set my security to medium and hold down the shift key when clicking 'enable macro'. How can I achieve the same with Excel 2007 so that I can enable the macro, without it running, and then e... 25 Mar 2010 16:16

Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1 to be repeated at top
Sub titles() Dim ws As Worksheet For Each ws In ActiveWorkbook.WorkSheets If ws.Type = xlWorksheet Then ws.PageSetup.PrintTitleRows = "$1:$5" End If Next End Sub Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 18:51:49 -0700 (PDT), Subodh <getsubodh(a)gmail.com> wrote: I want... 25 Mar 2010 12:40

How to reference shdocvw?
I found this info in order to reference the "shdocvw" object, but the "Microsoft Internet Controls" option doesn't appear in the dialog box. Is there another way to reference it directly? I am running Excel 2003 SP3. I did a Search for "shdowvw" in my pc and found several shdocvw.dll files in different folders,... 25 Mar 2010 12:40

how to skip open operation
Hi all, I am consolidate multiple xls files into one, now in code, I have to use workbooks.open(...) first, then do retrieve, but this method is too slow. Is there any way retrieve data from a xls file without opening it. Clara -- thank you so much for your help ... 25 Mar 2010 12:40

Copy Filtered Data
I am filtering my data that is in the range A:AJ starting on row 13 with headers and having a variable ending row. My filter criteria is Column 1 not blank and Column 11 ="s". I would like to copy the filtered date (No headers) to another work book beginning in BE3. Thanks! ... 26 Mar 2010 09:11

Go to record end, then one across
I want my macro to select J7, go to the record end, then go across to the next cell, which is empty. As you can see when I recorded my macro it referenced a specific cell instead (K751). Hope I explained clearly - thanks in advance for help. Range("J7").Select Selection.End(xlDown).Select Range("K7... 25 Mar 2010 13:50