Set the file name for a TransferText macro through VB

[Matt Weaver]

Is there any way to programmatically set the file name path for a
TransferText macro through Visual Basic, or through another macro?
TIA!

Matt

 

[Matt Weaver]

One other point -- I know it's possible to execute a transferText
through a docmd, but that's not what I'm looking to do here. I really do
want to set the macro property through VB.

 

[Mike Painter]

One other point -- I know it's possible to execute a transferText
through a docmd, but that's not what I'm looking to do here. I really do
want to set the macro property through VB.

I know of no way but never use macros. It is easy in code and gives you
control that you don't have in a macro.