I have exported a lot of Outlook Macros to Bas files. Now how can i import all Bas files into the outlook moodules in one shot.

Posted on 2008-10-24
Last Modified: 2012-05-05

I have exported a lot of Outlook Macros to Bas files. Now how can i import all Bas files into the outlook moodules in one shot.
Is there a inbuilt way or a script that can do this

Question by:bsharath
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 76

Expert Comment

by:David Lee
ID: 22798757

This process cannot be scripted.  If you open the VB editor, you can click File > Import File and pull files back in.  I expect you can select more than one file at a time, but I'm not certain.
LVL 11

Author Comment

ID: 22798781
No it only alows to select 1 bas file at a time.

In times when the machine is rebuilt or given the bas files to others it becomes difficult to import 1 by 1...

Any other ideas...
LVL 76

Accepted Solution

David Lee earned 500 total points
ID: 22799138
There aren't any other options.  I suppose you could use copy and paste to merge all of your bas files into a single file and then import it.  That might not work well though since it'd dump all of your code into a single module.  

When I move to a new computer or rebuild my existing one, I make a copy of the Outlook file that stores the code and drop it on the new system  No importing or exporting.  That file is named VbaProject.OTM and is in the folder C:\Documents and Settings\<username>\Application Data\Microsoft\Outlook.  Part of that path is in a hidden folder, so be sure to set Explorer to view hidden files and folders.
LVL 11

Author Comment

ID: 22799179
Thank U ...Thats a good idea...
LVL 76

Expert Comment

by:David Lee
ID: 22799325
You're welcome.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question