Results 1 to 5 of 5
  1. #1
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20

    Convert Macro to VBA using VBA

    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!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    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.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  4. #4
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    They are general macros. I was afraid it would have to be one at a time. Thank you!

  5. #5
    jsblume is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    20
    "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.

    Quote Originally Posted by ranman256 View Post
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-13-2015, 01:33 PM
  2. Convert recalc VBA expression to Macro
    By mikenificent in forum Access
    Replies: 9
    Last Post: 10-22-2012, 07:14 AM
  3. Replies: 2
    Last Post: 05-05-2012, 02:34 AM
  4. Convert SearchForRecord Macro to VBA
    By Phred in forum Programming
    Replies: 4
    Last Post: 02-29-2012, 04:02 PM
  5. Convert Excel Macro to Access Query
    By crownedzero in forum Queries
    Replies: 1
    Last Post: 06-22-2009, 02:13 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums