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
687 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 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.
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Word 2010 mail merge 3 37
Outlook 2013 will not archive 4 43
User profile Size Report 3 40
Email subject no showing 2 44
Create high volume marketing opportunities using email signatures with these top 10 DOs and DON'Ts of email signature marketing.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
The viewer will learn how to dynamically set the form action using jQuery.

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now