export module as .bas file with vba code

[rob.low]

Hi all
Need some help Please

looking to export a module from my database as a .bas file

is there any way of doing this via vba code ? say from a command button maybe?

any help will be really appreciated

thanks

Rob

 

[DCrake]

This demo dos the whole hog and documents a whole mdb. You could extract the section that deals with modules and change the extension type from txt to bas.

Database documenter

David

 

[rob.low]

HI there DCrake.

Thanks for the quick reply and that was what i was looking for thank you it works great

Was wondering is there a way i can do this with a mde file also ??

thanks again

rob

 

[rob.low]

Hi All sorted now

thanks for your help with this DCrake.


Rob

 

[DCrake]

Don't think you can with MDE's as they code is compiled. Did you try it though? and what wqs your results?

David

 

[rob.low]

Hi
I did try with a mde and got an error message saying it couldent find the file.

Rob

 

[DCrake]

Haven't got access to the demo at the moment but I think it filters only mdb's in the code. You could look there to double check, and if need be change it to mde.

David