vba and macros

Hi, I am trying to use the code provided here: http://www.rondebruin.nl/windowsxpzip.htm to get excel to zip some files for me. I included the first bits and am trying to use the sub that zips an entire folder that I specify. It keeps giving me Run-time error though. It says: Run-time error...

Hello all, I'm sure this is very simple but I'm stuck. I have a range of cells - L1:L1000 all of which need to have their font changed if the respective cell in T1:T1000 = "Caution". I've got conditional formatting for background shading, but thats no good for people using black and white...

Hi - Can someone provide the code so I can create a "popup panel" of macro buttons when a single macro button is activated? I have 4 or 5 macro button options but I don't want buttons all over the screen so I was hoping to have a panel of macro button pop up when requested. Thanks - jtk

Hello... Somewhat experience with basic and self taught. Need some help.. I have 2 separate macros and wanted to combine them. The issue is the two differetn For Each statements. Both steps are on the same worksheet and I am trying to consolidate the steps. I know it is very simple code...

Hi, I need an excel macro that will lift information from specific cells in a spreadsheet and populate an Outloock mail template. I am trying to automate approval emails. I have the Outlook template created and I have a list of groups with corresponding approvers in the same rows. What I need is...

Problems: Groups of data should not split at inserted page breaks. Row heights vary at the 3rd and 5th row of each 7 row group. Typical pages have between 4 and 6 groups. Average projects contain 10 - 50 pages, or 40 - 250 groups. What I am trying to do is adjust the height of every 5th and 7th...

I am attempting to write a macro that lets a user select a cell containing a unique value, run the macro which prompts the user to select a workbook to "search" for that value in and return the row number of where that value was found to the original workbook. Example: - Highlight a cell with...

Hi Guys, I have a workbook, which is protected with password to open using Save As -> Tools -> General Options. I am trying to open this workbook through a code in another, but it asks for the password to open. Can someone let me know the code to bypass this dialog box (at open) and...

I have two similar challenges I need help with: 1. I have about a hundred workbooks saved in a folder. I need to get the sum of all H columns in those workbooks. How can I do this without opening them all and using something like this:=SUM('[Workbook1.xls]Sheet1'!H:H...

Hallo I am having a problem with calling 2 macros sequentially when using Private Sub Worksheet_Change(ByVal Target As Range) . What I want to happen looks like this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$O$2" Then Call Macro1 Call Macro2 End If End Sub...

Hi! I need help again with a macro to take my data that comes to me in a single column that I can transpose into single rows over multiple columns. Briefly, heres my issue; I have data that im gathering on my companies website that I cut and paste into excel and comes in the following format...

I have "entries" that consist of a row of data and then a blank row below. The first entry is in A2:K3. The number of entries is indeterminate. I have formatting (borders and such) that I want to copy from the first to all the other entries--A4:K5, A6:K7, etc. My modified code from the macro...

I have a need similar to the one in this post: http://www.mrexcel.com/forum/showthread.php?t=483690&highlight=adding+rows+VBA VoG's code was: Sub InsRows() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR - 1 To 3 Step -2 Rows(i).Resize(2).Insert Next i End...

I have a range of data which is repeated after a break in row X. I need help setting up a VBA macro to select the top range of data and remove it. This is exported data from another programme and one worksheet contains both "pre" and "post" data for the same data set, displayed as mentioned...

hi gurus; i was going to ask how to set a pivot table filter for over 4500 items, but instead of asking that, i went ahead and recorded a macro that almost did what i needed, except not 4500 times! My Marco generator efforts yieded this; Sub SetAmSurgProcCodes() ' ' SetAmSurgProcCodes Macro '...

I Have a macro that reads excel file names that are stored in a particular location. The macro is supposed to Open each file name specified on each row of predefined column Cycle through the number of worksheets in the opened file. Remove any shapes (pictures) Save the modified file in a...

I'm trying to write a macro that will automatically select several non-contiguous cells, copy them, and then paste them onto a different sheet. I don't want to make the user select them by hand with control+click, and the cells are not in fixed rows, but the columns will always be the same...

Just got your new book. Unable to locate the code files. URL in the book on page 6 is not active. Please let me know where to get the files.