Hi!
I'm converting an Access 2003 database to 2016. It has 56 macros. Is there a macro collection that I can iterate through and export/convert to VBA, the same way I can do to export modules to a text file?
Thanks!
Hi!
I'm converting an Access 2003 database to 2016. It has 56 macros. Is there a macro collection that I can iterate through and export/convert to VBA, the same way I can do to export modules to a text file?
Thanks!
I thought the Convert macro did them all.
There's also an export to text, the exports them all to text files, then just import them back as macros.
If these are embedded macros, have to convert each form individually.
If these are general macros, not sure if all will convert at same time or have to convert individually. Try it and find out. https://www.accessallinone.com/how-t...ndalone-macro/
It is probably possible to write code to cycle through the objects and perform this action but probably faster to just do it manually the one time.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
They are general macros. I was afraid it would have to be one at a time. Thank you!
"Convert macros to VBA" only does the one open in design view. The grammar on the command is incorrect. "Export" I've only found when right-clicking on a macro - and the only option is to Access.