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 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...
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...
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...
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...
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...
I am using the code that follows this message to email the active sheet in my workbook. The active sheet has a number of macros that, when executed, hide and unhide columns.
Can this code be adapted to also copy the VBA macro code so that the sheet will be functional for the recipient?
Thanks...
hi All,
I am stuck on this for 2 nights and I cant find a solution on the internet. Maybe it just doesn't work.
What I am trying to do
Attach two different tabs and attach them as attachment.
With the current tab - Put some few rows in the body of the email
Then save Rows 43 -95 into...
I am using the Ron De Bruin code to try and send a worksheet through e-mail.
I have checked the Microsoft Outlook 16 Object Library and have this code that I am using, however on the 3 lines that are in red font, I am getting errors: (I have put the error that im getting in green on the line...
I am currently working on a workbook that all I need exported into a network path is the first worksheet.
I am able to get this to save and move. However, it is saving on the main file. It is not saving within the folder I need it saved at.
Below is the code I am using...
**
Sub...
I have the following macro below which extract sheet 'Imported assets' and attaches it to outlook but without the email address/s
I have the email addresses in S1 to S5 on sheet7
I would like the macro amended so as to extract the email address from sheet 7 which is in S1 to S5
Sheet...
I have a financial template with about 40 worksheets that I use to create reports for various departments and financials. I currently have a VBA script that takes each worksheet in the workbook and copies it to its own new workbook (also puts all the files into their own folder), but the new...
I had this code working on a previous excel version
ActiveWorkbook.SaveAs filename:=Path & "SA-" & FileName1 & "-" & DATES & FileExtStr = ".xls": FileFormatNum = 56
now I get an error. Can anybody help me ?
Greets
Hello all, I have a workbook and would like to email a specific sheet in the workbook as an attachment. I've been using the code found on https://www.rondebruin.nl/ for years and it works well! I recently added a table on the worksheet i intend to email out and now the VBA keeps erroring out...
Hello I am using below macro to save my current workbook to a location on my desktop and email through out look.
But what its doing is taking just my sheet1 of personal.xls and saving it an attaching in email. What am I doing wrong. Please help.
Dim FileExtStr As String
Dim FileFormatNum...
Anyone have a list for all of the file format numbers? I've done some poking around on the interwebsbut have only come up with the following... <o:p></o:p>
<o:p></o:p>
FileExtStr = ".xlsb": FileFormatNum = 50<o:p></o:p>
FileExtStr = ".xlsx": FileFormatNum = 51<o:p></o:p>
FileExtStr = ".xlsm"...
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.