Save all Word macros to a txt file or Word document

[gailb]

I have many macros in Word that I'd like to e-mail to another computer, but unfortunately due to network restrictions, the normal .bas export will not e-mail. Is there a way to save all macros to a txt file or maybe even to a Word file?

[HansV]

.bas files are actually plain text files, so you could either change the extension to .txt either when you export a module, or afterwards in File Explorer.

[macropod]

So why not just email the file(s) containing the macros?

[gailb]

Whatever the settings are that IT has set on the server, any files with macros are blocked from being delivered. Also, a .bas file extension is blocked as well. I changed the extension to .txt and that worked but won't be very efficient for all the modules I have with Word. Any other ideas?

[macropod]

Maybe you need to use SneekerNet (i.e physically take a copy of the files to the relevant workstation).

[gailb]

Yes, in the end this might be necessary. We are blocked from using flash drives, so might have to use a CD.

[Jay Freedman]

Try exporting all the macros to .bas files, preferably all in the same folder, and then adding all of them to a zip file. It should be possible to email or otherwise deliver the zip file to another computer, where it can be unzipped and the .bas files imported.

[gailb]

Hi Jay and thanks, unfortunately, zip files are blocked as well.

[HansV]

You can use a command prompt window to rename all .bas files in the current directory to .txt:

ren *.bas *.txt

And back:

ren *.txt *.bas

[gailb]

Thanks Hans