fileformatnum

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. R

    email active sheet and code associated with it

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

    VBA - Email selected cells from a worksheet via email

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

    E-Mail Worksheet

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

    Exporting Single Sheet to Network Path

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

    Email Macro not extractimng Name & Email address

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

    VBA Code to break links in new workbooks copied from template workbook?

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

    Newbie question

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

    VBA to email active worksheet with a TABLE

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

    Help Saving Current work book Macro

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

    File Format Numbers?

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