Converting XL4 Macro Sheet to VBA
I have an Excel Template that has an Excel 4 Macro Sheet in it. I understand
that MS Word can convert WordBasic Macros to VBA. Can Excel similarly convert a macro sheet into VBA automatically? I'm sure the resulting code might need some tweaking, but it would be better than starting from scratch. Thanks much, Geoff |
Converting XL4 Macro Sheet to VBA
No, it can't. This is a manual job in Excel.
On Thu, 25 Nov 2004 22:39:08 -0500, "Geoff Martin" wrote: I have an Excel Template that has an Excel 4 Macro Sheet in it. I understand that MS Word can convert WordBasic Macros to VBA. Can Excel similarly convert a macro sheet into VBA automatically? I'm sure the resulting code might need some tweaking, but it would be better than starting from scratch. Thanks much, Geoff |
Converting XL4 Macro Sheet to VBA
Out of town for weekend...Thanks for the info, Myrna.
I've never translated a macro sheet to vba and my main interest is in modifying the "userform" that is generated. The default button that has the focus, etc. Is there a general strategy anyone can recommend? Thanks much, Geoff "Myrna Larson" wrote in message ... No, it can't. This is a manual job in Excel. On Thu, 25 Nov 2004 22:39:08 -0500, "Geoff Martin" wrote: I have an Excel Template that has an Excel 4 Macro Sheet in it. I understand that MS Word can convert WordBasic Macros to VBA. Can Excel similarly convert a macro sheet into VBA automatically? I'm sure the resulting code might need some tweaking, but it would be better than starting from scratch. Thanks much, Geoff |
All times are GMT +1. The time now is 11:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com