fileformatnum

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