SaveAsText acMacro

  • Thread starter Thread starter George
  • Start date Start date
G

George

I'm trying to list the contents of macros in database that
is not CurrentDB.

Listing the macro contents of CurrentDb is accomplished
using:

SaveAsText acMacro, strDocument, strFilename

I tried copying the "foreign" macro to the CurrentDB,
using
app.DoCmd.CopyObject , "CurrentDoc_Macro", acMacro, _
strDocument

but that failed.
Is there another way to save a foreign macro as text, or
otherwise list its contents other than SaveAsText?

Is there a better strategy to list the macros in a user-
specified .mdb? (I don't want to use Tools, Analyze,
Documenter).

Thanks for your help.
George
 
SaveAsText is a method on application object, so try:
app.SaveAsText acMacro, strDocument, strFilename
 
Back
Top