1
vote
0answers
141 views

Macro to copy and insert rows by variable number

I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines. Some members receive more than one copy of the magazine, which will be indicated in ...
0
votes
1answer
151 views

Excel 2003 Macro runtime error 1004 application-defined or object-defined error

We are using a macro to remove rows of data from our excel 'database' that have been tagged as being completed/done. this is the coding ... Private Sub cmdRemove_Click() Dim varResult As ...
-1
votes
1answer
215 views

Macro to count the number of text strings in sheet in Excel 2003

I have a worksheet for scoring. I have a list in the first sheet that will be for data entry starting with a2 and going down the sheet, this is for Player names. I have a summary sheet named "Place" ...
1
vote
0answers
680 views

How to Search For Excel (2003) Files which Contain Macros on Server?

How can I search for Excel files that contain VBA code, are there any efficient ways to do this? The way I'm thinking of would be to use vbscript and recursively search through the directory, open ...
0
votes
2answers
324 views

How can I speed up my macro in Excel 2003?

I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows. When I run it in Excel 2003, Excel starts to slow ...
0
votes
1answer
583 views

Download direct image links in Excel 2003

I have a list of about 6,000 direct links to images in an excel sheet, and I need to download them all automatically onto my computer into a directory keeping the same file names. How do I do this?
0
votes
1answer
1k views

In Excel VBA Macro does ActiveWindow.Scroll change ActiveCell at all

I'm cleaning up and extending some excel VBA macros (written and currently running in Excel 2003), and I have a question about how far I can go in cleaning up without modifying the output. There are ...
1
vote
2answers
758 views

Remove Excel 2003 macros easily

I am using Excel 2003 and I have some workbooks that I have to send several days a week to some recipients. These workbooks have macros in it and I don't want the people receiving the file to be able ...
0
votes
2answers
3k views

Macro to open excel hyperlinks

I would like to know if anyone can help me do a macro to open a list of hyper links. I have a list of about 600 hyper links all in a column in separate rows, i have to open each one to see if the ...