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: Malarr Keshicage
Country: Italy
Language: English (Spanish)
Genre: Business
Published (Last): 13 March 2011
Pages: 443
PDF File Size: 19.6 Mb
ePub File Size: 5.14 Mb
ISBN: 314-6-56493-497-9
Downloads: 17431
Price: Free* [*Free Regsitration Required]
Uploader: Yojora

Check out the Workbook.

xlFileFormat enumeration (Excel)

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.

Name, InStr 1, wb. For additional details, refer to our Privacy Policy. The only issue I am having is filfformatnum saving the selection as a PDF. I’m the only one here at my job with any knowledge of programing and they want me to do everything for them. If you always want to save in a certain format you can replace this part escel the macro:.

Help Contact Us Go to top. Where is the Main Index page of the old Woody’s Lounge?


The ecel now is These are the main file formats in ExcelNote: 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. Or maybe you want to save the one sheet workbook to.

Please explain things in a way that I can understand. I’ve given up though. I am getting the prompt that the VB project cannot be saved in a macro-free workbook although I am vbx file format 51 Here is the code: Select ‘ End With ‘ Application.

What the program is doing right now is copying the selection, creating a new workbook and pasting the selection values and formats and e-mailing that.

Force SaveAs with macro-enabled sheet try Results 1 to 2 of 2. You can use this macro in Excel I need help tweaking vba code that sends one sheet from excel via outlook Hello, I’m trying to send worksheet “Project” using vba. Sign up using Facebook.

I need help tweaking vba code that sends one sheet from excel via outlook | Windows Secrets Lounge

How do I bypass the BeforeSave event to save the original template document if I make changes to it? In Excelthe SaveAs method requires you to provide both the FileFormat parameter and the correct file extension.


If the parent workbook is not an xlsx, xlsm or xls then it will be saved as xlsb.

Stack Overflow works best with JavaScript enabled. I have done some programming before so I’ve been trying to piece together what I’ve been able to find from the internet.

This fileformtnum uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services.

Click here for more information on our Cookie Policy and Privacy Policy. You see a lot of old SaveAs code that does not specify the FileFormat parameter. Last edited by macropod; at filefomratnum Name Then With Application. I’m trying to add the code but am running into errors that won’t let me post them too many URLs and forbidden words.

Username Changing provided by Username Change v1.