ron de bruin

  1. C

    How to add additional Criteria to Ron de Bruin's "Mail a row or rows to each person in a range" code?

    I toyed with this all day yesterday. Been working away at it all morning and still can't whip it. I think it will be relatively easy for someone with some VBA experience... I'm just not quite there. So, basically, Ron de Bruin's code from this page works great. Does just what it's supposed to...
  2. E

    Macro to change values of a cell and send e-mail

    Hello all, I have searched an answer for my question but couldn't find one. Please excuse me if there was a similar one. Right now my excel file can create PDF and send e-mails thanks to Ron de Bruin's add-in. What I do is, I change the value of one specific cell manually which updates the...
  3. J

    Mailing a worksheet with Pivot table and preserve formatting

    Hi All, I'm new to VBA and I used Ron De Bruin's fantastic code to mail a worksheet by modifying it slightly to do what I want. The problem is when the pivot table in the worksheet is copied to the email body, the formatting is lost. Is there a way to preserve the formatting of a pivot table...
  4. F

    Help - VBA Copy Non-Contiguos cells and Paste to specific cells in another workbook.

    Thanks to Ron De Bruin for this wonderful code. I copy/pasted it and have been hacking at it here and there to try and make it fit my situation. I have limited experience with VBA so please forgive my butchering of this. I would like to set the source cells (which are non-contiguos) and paste...
  5. M

    Modify Ron´s Code - Create a new workbook for all unique values And Create PivotTable is such workbooks

    Ron´s Code - Create a new workbook for all unique values works just fine. IT is below. But I need to go forward, and after all workbooks were created from unique values using this Ron´s code, I need to create PivotTable in each of these workbooks. Reference to Ron´s...
  6. F

    E-mail from Excel - macro errors when copied

    Working in Excel 2010 I have a workbook I'll call Group 1. There are 11 available worksheets, and anywhere from 1-11 of these sheets are assigned to a different company name. The worksheets themselves are simply numbered 1-11, the company names are always referenced in cell D3. I am not going to...
  7. M

    Modify Ron´s VBA code and help me with Worksheet Array

    I need to copy the same range from many sheets in the same workbook. I found Ron´s VBA solution, which basicly fits to me partly because this code below copy only specific range just from one sheet in specific workbook. But, I need to copy specific range from many sheets and i tried to modified...
  8. R

    Run a macro automatic when a specific formula cell reaches a User Defined value

    I'm having trouble sending an email after having the user define a "Reorder" level on an inventory project. I have tried troubleshooting or tweaking Ron's http://www.rondebruin.nl/mail/change.htm but i'm currently getting a mismatch error. If I can define Reorder Level to be Column "P" and my...
  9. E

    VBA Excel Table to Outlook Border Issues

    Hi, It appears someone else has posted a similar question regarding this but not received a solution: http://www.mrexcel.com/forum/showthread.php?t=588628 Perhaps I can elaborate on the issue at hand. I am using code written by Ron de Bruin in order to send a table I have created in Excel to...
  10. repairman615

    macro..create pdf: would like email window visible (on top of excel)

    Many thanks to this site and especially all the great people here! I have a macro that creates a pdf, then attaches the pdf to a email. Thanks Ron de Bruin! The macro works. There is one part that I would like to improve if possible. After the pdf gets attached into a email, this email...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top