Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
editing .xla files
I am in over my head here.
I have a custom "add-in" that is a series of 4 macros that used to work in Excel 2003. Now in Excel 2007, one macro is now giving a "Runtime error '1004' Autofill method of range class failed" error. What can I do to debug this? This add-in is saved as a ".xla" file. I have limited experience with macros and wanted to find out if I could open this up to attempt to edit. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
editing .xla files
Unless the VB project is password protected you should be able to edit the
code in the VBE just as you would for a normal workbook with code. Then, when you want to save the changed add-in, click the save button on the VBE Standard toolbar, making sure the add-in is the active project. -- Jim "Joe" wrote in message ... |I am in over my head here. | I have a custom "add-in" that is a series of 4 macros that used to work in | Excel 2003. Now in Excel 2007, one macro is now giving a "Runtime error | '1004' Autofill method of range class failed" error. | What can I do to debug this? This add-in is saved as a ".xla" file. | I have limited experience with macros and wanted to find out if I could open | this up to attempt to edit. | Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vista & XP editing web files | Excel Discussion (Misc queries) | |||
How to preset password for editing for new files generated in exce | Excel Programming | |||
EXCEL files locked for editing | Excel Discussion (Misc queries) | |||
Editing Shortcut files | Excel Programming | |||
Can I use Excel, opening and editing files, online? | Excel Discussion (Misc queries) |