Use the VBA SaveAs Method in Excel FileFormat Case FileExtStr = “. xlsx”: FileFormatNum = 51 Case roject Then. I have just started looking at code saving in vba and I am sure this will seem like a stupid question to a lot of you out there. After reading a. Note: This method has been added to the Excel object model with Excel and requires the Save as PDF or XPS Add-in for Microsoft Office programs to.

Author: Samuzshura Jukus
Country: Saint Lucia
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 25 April 2008
Pages: 378
PDF File Size: 7.92 Mb
ePub File Size: 2.90 Mb
ISBN: 393-6-61180-410-2
Downloads: 68553
Price: Free* [*Free Regsitration Required]
Uploader: Kalmaran

I installed the PDF save addon for Excel but now I need to know what the number code is for the file format for when I save the excel file.

xlFileFormat enumeration (Excel)

Sign up using Email and Password. The only issue I am having is with saving the selection as a PDF. Select ‘ End With ‘ Application. All times are GMT Only if the parent workbook is an xlsm file and if there is no VBA code in the new workbook it will save the new file as xlsx.

I got most of this code from online and understand the basics filefirmatnum how it works, but am having trouble editing it to do what I want. I am getting the prompt that the VB project cannot be saved in a macro-free workbook although I am specifying file format 51 Here is the code: Force SaveAs with macro-enabled sheet Thanks for all your help but I have another question.

If the parent workbook is not an.

Thread Tools Show Printable Version. Saving Worksheet as PDF. Forums Blogs Articles Groups. For additional details, refer to our Privacy Policy. Example 1 you can use in ExcelExample 2 you can use in Excel Exactly what I was looking for! The file send in outlook has this name: There are macros in the spreadsheet that need to remain so it must be saved as an.


The more you know!

Force SaveAs with macro-enabled sheet – Free Excel\VBA Help Forum

Force SaveAs with macro-enabled sheet October 21st, If the parent workbook is not an xlsx, xlsm or xls then it will be saved as xlsb.

How should I configure my browser to get the greatest benefits from the Lounge?

I need help tweaking vba code that sends one sheet from excel via outlook Hello, I’m trying to send worksheet “Project” using vba. Thanks in advance for vvba r time and help.

Name, InStr 1, wb. The Excel workbook template is in a SharePoint library When the user closes the file or clicks Save or SaveAs it needs to be automatically saved to a different SharePoint library using the value in exdel cell location as the file name. I did this in Word, and the format number is Sign up or log in Sign up using Google.

Use the VBA SaveAs Method in Excel – Microsoft Blog

As far as I know, it doesn’t have any of either, but I’ll keep trying to list the code on here somehow. Username Changing provided by Username Change v1. I’m trying to add the code but am running into errors that won’t let me post them too many URLs rxcel forbidden words. By continuing to use our website, you agree to the use of such cookies. If you always want to save in a certain fildformatnum you can replace this part of the macro: You see a lot of old SaveAs code that does not specify the FileFormat parameter.


Where is the Main Index page of the old Woody’s Lounge? Last edited by macropod; at Member List Calendar Forum Rules. Force SaveAs with macro-enabled sheet try This program is designed to let the fileflrmatnum select the section they would like to e-mail and fileformantum it as a PDF. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

I just want the fileformatnnum file to be sent in outlook without the copied excel file opening. These are the main file formats in ExcelNote: By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

Stack Overflow works best with JavaScript enabled.

Use the VBA SaveAs Method in Excel 2007

If you run the code in Excel it will look at the FileFormat of the parent workbook and save the new file in that format. I have done some programming before so I’ve been trying to piece together what I’ve been able to find from the internet. Thank you so much for any help you can give! ExportAsFixedFormat, but I can’t get it to work properly. Will try to fix later.