fileextstr

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...