Copying my macro to other PCs

  • Thread starter Thread starter Sharad Naik
  • Start date Start date
S

Sharad Naik

I have created macro project in outlook (Ms Outlook 2003), which contains
several user forms, and a couple of modules. Tested it and working to my
satisfaction.

Now I want to implement this project on serveral users PCs.

Apart from exporting the userform files, module files, and 'This outlook
session' file, and then importing them on other users pcs. is there
anathoer way to copy the entire porject on other serveral users pcs?
In case of Winword, I could simply copy and replace 'normal.dot'. Is there a
simillar way to just copy and replace a single file, for outlook macro
projects?

Thanks in advance,

Sharad
 
Hi Sharad,

the project is stored in a *.otm file that you can copy and deplay. But
doing this you would overwrite any exisiting project on the other
machines.
 
Hello Michael,

I also thought the same thing.
But I can find any *.otm file on my PC.
I gave search ("Show hidden files and Show show system files in enabled on
my PC.) but *.otm file does not exist.
In the project, it actually shows the name as VBAProject1.OTM, and yet no
any .otm file exists on my computer.

Sharad
 
Hi Sharad,

OL stores the project in "VbaProject.otm", by default under:

Documents and Settings\(User]\ApplicationData\Microsoft\Outlook.

If you have stored your project then the file must be somewhere. Maybe
it is possible to change that directory? Please check that.
 
Thanks Michael,
I found the file in the same folder as you mentioned.
And now it even shows it when I search for *.otm
Don't know why it wasn't showing it yesterday.

Thanks
Sharad
Michael Bauer said:
Hi Sharad,

OL stores the project in "VbaProject.otm", by default under:

Documents and Settings\(User]\ApplicationData\Microsoft\Outlook.

If you have stored your project then the file must be somewhere. Maybe
it is possible to change that directory? Please check that.

--
Viele Grüße
Michael Bauer


Sharad Naik said:
Hello Michael,

I also thought the same thing.
But I can find any *.otm file on my PC.
I gave search ("Show hidden files and Show show system files in enabled on
my PC.) but *.otm file does not exist.
In the project, it actually shows the name as VBAProject1.OTM, and yet no
any .otm file exists on my computer.

Sharad
 
Back
Top