fileextstr

  1. J

    Saving worksheet as image

    Hi all, I have an excel workbook that has multiple tabs, and once a week I have to mail 2 of the tabs (worksheets) to our Plant manager, I use a Mail Sheets Array and a macro button to do this and it works fine, but recently, I have added a "Charts" worksheet, and when it makes the temp copy of...
  2. R

    Combine Two VBA Codes

    I have a workbook with many tabs that currently will create a folder and save each tab as a separate CSV file into that folder. Ultimately, what I'd like so for those files to then combine into one big CSV file. The headers of each tab are identical, so I only need the header row once. My...
  3. N

    Export all sheets as XLSX

    I want to export all sheets as xlsx with vba, and save that macro in the personal workbook. I searched online for some code and then I modified it, so that I could select the folder in which I want to save the sheets in, and it works, but only if the macro is saved in the workbook I am working...
  4. C

    Split workbook into individual worksheets and email via outlook to different recipients.

    Hi, I am trying to split a workbook with multiple worksheets to separate worksheets with one macro and then email (via outlook) the individual worksheets to different people. The objective of this is for recipients to receive information on one sheet only. They are not allowed to see the rest...
  5. J

    [VBA] If Cell Contains Certain Text, then Search IF Range Empty, If Cell Contains Different Text, then expand the Range it Searches?

    Hi all, Long time Listener, First Time Caller, so please bare with me. I am a VBA Novice, very much cobbling together my knowledge through various forums such as this. I have come to a bit of a sticking point with some code I am working on at the minute. What I want to get out is, IF cell C7...
  6. H

    Macro to attach several sheets to email

    I have the following macro to email a specific sheet I need to amend this to add sheet 'dashboard' to be attached to email 'Copy the ActiveSheet to a new workbook Sheets("overaged").Copy Set Destwb = ActiveWorkbook Sub Email_Overaged_Stock_Report() With Application...
  7. K

    Excel cell values transferred as Email body content

    Hello Excel-lent people! I wanted to make a userform where I would populate a textbox and want it's content to become the content or body of the email. With the code i have below, what it does is it attaches the worksheet instead as an attachment to the email and i believe one of those that...
  8. H

    Macro to extract sheet name after last character in subject line

    I have a macro that emails and attaches a specified sheet I would like the code below modified so that that sheet name appears after Sale report for eg Sales Report-BR1 .Subject = "sales Report" See full Code Full Code Sub Email_SalesReport() Dim FileExtStr As String...
  9. M

    Macro unlinking from buttons when file name changes

    Hello. I am rather new to VBA. I have a form set up in Excel. There are fields to fill out,and when the “Submit” button is clicked, there is VBA code that creates a newemail, re-names the file according to specific information in the forms fieldsand attaches the file to the email, as well as...
  10. R

    How do I skip specific workbooks in my macro?

    I've tried to look up how to do this, but with my Macro I keep getting errors and just can't figure it out...:mad: The Macro is designed to automatically save each sheet as it's CSV file. I have a couple sheets at the beginning that I want it to skip. How do I make the Macro automatically skip...
  11. T

    VBA Code to send two separate Emails

    Hi All, The below code is currently part of one of my subs, It’s toautomatically send an email when a button is pressed in the worksheet. Myquestion is how can I change this to make it send two separate emails withdifferent bodies and recipients? Thanks in Advance Tom Dim wb1 As Workbook...
  12. C

    Email button in excel

    Been a long time since I have been on here. I am using excel 2010. I have a button that when clicked will open outlook and attach the file. However, I want to have it automatically put in the email address that I am sending to, since it always the same. Below is the code I have. Also I...
  13. A

    Compile Error - VBA

    Hello All.... I have a VBA code that should be taking worksheets and saving them each as their own excel file in a new folder. I had previously had this code working, but then made some modifications to my file, and as a result, this code is now giving me a "Compile Error: Wrong number of...
  14. H

    Macro to email and attach sheet

    I have a macro to copy a sheet and attach the same format including all the comments as the sheets The macro work to a point, except that the format for the percentages is pasted as text It is the code below that I need amended to paste the data in exactly the same format including comments...
  15. F

    Something fishy in my VBA code, please help

    Hi, Im trying to Email 16 different email addresses a copy of a specific sheet from my workbook. I've almost suceeded in that sense that i've managed to create 16 emails and attach 16 different sheets. However it wont Add my address list to the "To" field in outlook.... I've now been staring...
  16. J

    Change CBA Code From E-mail Active Worksheet to Active Workbook

    How do I alter this code so the macro e-mails the entire workbook to my desired recipients instead of just e-mailing only the active worksheet? Sub Mail_Active_Sheet() 'Working in Excel 2000-2013 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm Dim FileExtStr As String...
  17. G

    Excel VBA to Send E-mail

    Good Morning, I’m helping a co-worker modify some code she borrowed from the internet to create an e-mail from an Excel file. Everything works well with one exception. We want to be able to send the e-mail containing the excel file AND the file keep the macro so the file can be reused and sent...
  18. R

    Mail activesheet & rename sheet

    I want to rename the sheet that is being mailed but it gives Run-time error 9, Script out of range. How would I fix this? Thank you for the help Sub Mail_ActiveSt_XLS_No_Date()'Working in Excel 2000-2016 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm Dim FileExtStr...
  19. H

    Macro to email sheet

    I have code to email sheet8 on Excel and attach it in Outlook as well as the subject heading and body for the email in Outlook The only items that the code is not doing , is extracting the email addreses, which are in cells N1:N5 on sheet "Email" I have set up the subject for the email on...
  20. kripper

    Mail Range or Selection

    Good Afternoon Excel Guru's..... I am having a bit of an issue trying to make a macro created by Ron de Bruin work for me as I want it to, and I was hoping someone may have tried to reconfigure to do the same or would know how to configure it. Basically I am using the script from Ron's site...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top