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

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top