Results 1 to 6 of 6

Thread: Macro VB project Message error message after closing Microsoft Excel file

  1. #1
    Join Date
    Jan 2012
    Posts
    23

    Macro VB project Message error message after closing Microsoft Excel file

    My codes image a table in Office 2003 excel template with macro enable, after I update to Office 2007, I get this error message on closing the workbook: The following features cannot be saved in macro-free workbooks. VB project. To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.To continue saving as a macro-free workbook, click Yes. Is there a way I can suppress this message programmatically? Or using Office 2007 policy? It seems that Office 2007 does not allow to save as .xlsx with macro. Thanks for your help.

  2. #2
    Join Date
    Jun 2011
    Posts
    635

    Re: macro-free workbooks - VB project message error message after closing Microsoft Excel

    You need to save it once as a 'macro-enabled workbook' in 2007. I think the type is xlsm. After that you can save the file without getting this message.

  3. #3
    Join Date
    Jul 2011
    Posts
    640

    Re: macro-free workbooks - VB project message error message after closing Microsoft Excel

    But every-time after the user images the template, then he closes this template, the error message displays again. Is there a way, I can default this template to .xlsm (or .xls) on saving when user closes the template?

  4. #4
    Join Date
    Jul 2011
    Posts
    634

    Re: macro-free workbooks - VB project message error message after closing Microsoft Excel

    A template will try to save the file in the default format of Excel 2007 You can change the default file format to xlsm(with macros) See Office Button>Excel Options. Save I send a suggestion to MS to always default the save for a template with code as xlsm.

  5. #5
    Join Date
    Jul 2011
    Posts
    623

    Re: macro-free workbooks - VB project message error message after closing Microsoft Excel

    The main reason for this error due to the application VB runtime is trying to copy and paste the complete row in a worksheet or may groped too many lines in the Excel worksheet. To resolve this runtime error, you must first make sure that the VB macro is just transferred to the line defined in the Excel worksheet. Rather than copy the complete row, you can get it done using a simple command. In this way, data is transferred to the system without leaving any piece of information.

  6. #6
    Join Date
    Aug 2011
    Posts
    566

    Re: macro-free workbooks - VB project message error message after closing Microsoft Excel

    The use of the registry repair tool will completely remove the errors and fix the runtime error 1004 easily and efficiently. This registry repair tool, not only helps to solve the error code 1004, but also helps to solve a series of errors which is caused by damage to the registry.

Similar Threads

  1. File not found error on open and closing project file
    By Umedd in forum Microsoft Project
    Replies: 4
    Last Post: 30-03-2012, 07:46 PM
  2. Getting Error Message when I try to save file in Excel
    By Aza in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 02:08 PM
  3. How to fix Print Error Message in Microsoft Excel
    By The-Farmer in forum MS Office Support
    Replies: 3
    Last Post: 13-01-2012, 04:58 PM
  4. Replies: 6
    Last Post: 14-05-2011, 11:06 AM
  5. Error Message while trying to Save a file in Excel 2007
    By hatred in forum Windows Software
    Replies: 5
    Last Post: 26-03-2010, 04:00 AM

Tags for this Thread

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
  •  
Page generated in 1,721,024,192.50969 seconds with 17 queries