Results 1 to 3 of 3

File Format equals Marco-Enabled Workbook

Threaded View

markcicoff File Format equals... 02-05-2009, 06:04 PM
dominicb Re: File Format equals... 02-05-2009, 06:14 PM
royUK Re: File Format equals... 02-06-2009, 04:07 AM
  1. #1
    Registered User
    Join Date
    10-09-2008
    Location
    Denver
    Posts
    4

    File Format equals Marco-Enabled Workbook

    Within my VBA code, I want to save the Excel file as "Excel Macro-Enabled Workbook." Currently, File Format:=xlNormal within the VBA code and the results saves the Excel file as .xls. How do I write the File Format to save the Excel file as "Excel Macro-Enabled Workbook."

    Below is an example:
    ActiveWorkbook.SaveAs Filename:=Left$(ActiveWorkbook.Name, (Len(ActiveWorkbook.Name) - 4)), FileFormat:=xlNormal, CreateBackup:=False
    Last edited by markcicoff; 02-06-2009 at 02:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1