Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-01-2012
Member
 
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.
Reply With Quote
  #2  
Old 13-01-2012
Member
 
Join Date: Jun 2011
Posts: 632
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.
Reply With Quote
  #3  
Old 13-01-2012
Member
 
Join Date: Jul 2011
Posts: 632
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?
Reply With Quote
  #4  
Old 13-01-2012
Member
 
Join Date: Jul 2011
Posts: 631
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.
Reply With Quote
  #5  
Old 13-01-2012
Member
 
Join Date: Jul 2011
Posts: 618
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.
Reply With Quote
  #6  
Old 13-01-2012
Member
 
Join Date: Aug 2011
Posts: 564
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Macro VB project Message error message after closing Microsoft Excel file"
Thread Thread Starter Forum Replies Last Post
File not found error on open and closing project file Umedd Microsoft Project 4 30-03-2012 07:46 PM
Getting Error Message when I try to save file in Excel Aza MS Office Support 2 23-02-2012 02:08 PM
How to fix Print Error Message in Microsoft Excel The-Farmer MS Office Support 3 13-01-2012 04:58 PM
?The language DLL VBE6intl.dll could not be found? error message in Microsoft Excel 2007 pREMAsAGAR Windows Software 6 14-05-2011 11:06 AM
Error Message while trying to Save a file in Excel 2007 hatred Windows Software 5 26-03-2010 04:00 AM


All times are GMT +5.5. The time now is 02:37 PM.