Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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
5
Medium Priority
?
709 Views
Last Modified: 2012-05-05
Hi,

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

Regards
Sharath
0
Comment
Question by:bsharath
  • 3
  • 2
5 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 22798757
Sharath,

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.
0
 
LVL 11

Author Comment

by:bsharath
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...
0
 
LVL 76

Accepted Solution

by:
David Lee earned 2000 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.
0
 
LVL 11

Author Comment

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

Expert Comment

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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

As a Microsoft Exchange user, you must have known the importance of an Offline storage table (OST) file. It is nothing new for an Outlook user to be dependent on a .ost file during a server break down or a problematic Internet connection. In such a…
Often, the users face difficulty in accessing Outlook 2016 PST files on Windows 10 computer. One of the reasons behind it is the improper functioning of MS Outlook when the user tries to open it. MS Outlook suddenly stops working, or it will not op…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

577 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