Save all Word macros to a txt file or Word document
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00
Save all Word macros to a txt file or Word document
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?
-
- Administrator
- Posts: 78536
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Save all Word macros to a txt file or Word document
.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.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Save all Word macros to a txt file or Word document
So why not just email the file(s) containing the macros?
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00
Re: Save all Word macros to a txt file or Word document
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?
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Save all Word macros to a txt file or Word document
Maybe you need to use SneekerNet (i.e physically take a copy of the files to the relevant workstation).
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00
Re: Save all Word macros to a txt file or Word document
Yes, in the end this might be necessary. We are blocked from using flash drives, so might have to use a CD.
-
- Microsoft MVP
- Posts: 1319
- Joined: 24 May 2013, 15:33
- Location: Warminster, PA
Re: Save all Word macros to a txt file or Word document
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.
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00
Re: Save all Word macros to a txt file or Word document
Hi Jay and thanks, unfortunately, zip files are blocked as well.
-
- Administrator
- Posts: 78536
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Save all Word macros to a txt file or Word document
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
ren *.bas *.txt
And back:
ren *.txt *.bas
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00