You may receive runtime error 1004 error message when VBA not opening, copying worksheet ..., this page contains some useful information to repair your computer run time error code 1004, if you fixed this error from this help article, you can email us (windowsxpregistrycleaner@gmail.com ) give your feedback, and we hope you can share this page to your friends if they need like you, thanks.

 

Run-time error 1004 excel

Back to Top

• When you try to run a Visual Basic for Applications (VBA) macro that saves the current workbook as a shared workbook in Office Excel 2007, you receive the error below:
  
  "Run-time error 1004, Application-defined or object-defined error"
   
• How to fix?
  
  Cause:
  a. The default save format is set to Excel 97-2003. Additionally, a new workbook is added, and the macro uses the ProtectSharing method or the SaveAs method against the new workbook in the Excel 97-2003 file format.
  
  b. The ProtectSharing method uses the FileFormat property set to xlExcel8.
  
  
  To resolve this issue, try following methods:
  
  Method 1: Set the default file format to xlWorkbookNormal
  
  To use either the ProtectSharing method or the SaveAs method in a VBA macro, set the default file format to ExcelWokbookNormal early in your VBA macro.
  
  The following VBA code is an example of how to use the DefaultSaveFormat method to set the default file format to xlWorkbookNormal.

  Application.DefaultSaveFormat = xlWorkbookNormal

  Note To manually set the DefaultSaveFormat method, follow these steps:
  
  1. Click the Microsoft Office Button, and then click Excel Options.
  2. Click Save.
  3. In the Save files in this format box, click the format in which you want workbooks to be saved by default.
  4. Click OK to close the Excel Options dialog box.
  
  
  Method 2: Use the SaveAs method with the AccessMode parameter
  
  To use the SaveAs method, use the AccessMode parameter.
  
  The following VBA code is an example of how to use the SaveAs method with the AccessMode parameter.

  ActiveWorkbook.SaveAs FileName:="filename.xls", AccessMode:=xlShared, FileFormat:=xlExcel8

  Note The value of the FileFormat property must be the same value as the DefaultSaveFormat method.
   

Read our site other related articles...

• Why Your PC Has a Windows Registry Error
• What is Device Driver and Why Cause the Driver Errors
• Why My Computer Freezes Randomly and How to Fix
• How to Clean the Registry When It is Bloated
• How to Backup the Windows Registry in Windows 7/Vista/XP
• Screen on My Laptop Goes Black Suddenly How to Fix
• Make Your Windows 7 Boot Time Faster from Dual-Boot System
• fix io device error 1117
• fix error code 14
• error code 619
• fix run-time error 429

 

Microsoft help links for windows runtime error 1004

Back to Top

• You receive a "Runtime error 1004" error message when you try to copy and to paste filtered data programmatically in an Excel 2003 workbook
   
• XL2000: JPN: VBA Macro Causes Run-Time Error 1004 If AutoComplete Uses IME
   
• Copying worksheet programmatically causes run-time error 1004 in Excel
   
• You receive a "Run-time Error 1004" error message when you make changes to legend entries in an chart in Excel
   
• You receive a "Runtime 1004 compile" error message when you use VBA to open a password protected file 
   
• An Explanation of Trappable Errors(1004) in Visual Basic for Apps
   
• Run-time error '1004': Method '' of object '_Global' failed
   
• Run-time error '1004': Unable to set the FormulaArray property of the Range class.
   
• XL2002: Error Message: Run-Time Error '1004': Programmatic Access to the Visual Basic Project Is Not Trusted

 

• If you still haven't fixed the windows runtime 1004 problem:
  
  1. Please try the tool windows registry optimizer, it safely cleans PC errors & invalid entries cause slow speed, blue screen, deadlock errors and crashing, and repair registry problems to speedup your computer performances. It is easy to use. And you can scan your PC errors for free first!
  
  2. Some pc error is related to driver problems, Driver Update software is designed to quickly locate the most current drivers specific to your computer system, you can run a free scan for your pc driver update first.

 

That is we find the informations to fix pc VBA runtime error 1004 in windows, hope our page is helpful to you, if you still need more guide detail, please contact the microsoft support for further help.

 

 

www.pchealthadvisor.com

(Simple Steps:>>Download >>Install >>Free Scan >>Repair. that's all.)

 

 

PC error? Windows error? Registry error? - Find and fix on windowsxpregistrycleaner.com. Thanks for your visiting and we wait for you using our site again in the future! :)

Search Computer Errors on Our Site

Back to Top

Run time error 1004 Home > Categories > PC Common Errors - Update: December 17, 2010

>>> VBA Run-Time Error 1004 How to Fix?