Copying my macro to other PCs

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.

--
Viele Grüße
Michael Bauer


"Sharad Naik" <sharadnaik@nospam-vsnl.net> wrote in message
news:#IJiqE1wEHA.1292@TK2MSFTNGP10.phx.gbl...
> 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
>
>

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
"Michael Bauer" <mib00@t-online.de> wrote in message
news:umv3qP$wEHA.1512@TK2MSFTNGP12.phx.gbl...
> 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.
>
> --
> Viele Grüße
> Michael Bauer
>
>
> "Sharad Naik" <sharadnaik@nospam-vsnl.net> wrote in message
> news:#IJiqE1wEHA.1292@TK2MSFTNGP10.phx.gbl...
>> 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,

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" <sharadnaik@nospam-vsnl.net> wrote in message
news:OK5Zhl$wEHA.2624@TK2MSFTNGP11.phx.gbl...
> 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
> "Michael Bauer" <mib00@t-online.de> wrote in message
> news:umv3qP$wEHA.1512@TK2MSFTNGP12.phx.gbl...
> > 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.
> >
> > --
> > Viele Grüße
> > Michael Bauer
> >
> >
> > "Sharad Naik" <sharadnaik@nospam-vsnl.net> wrote in message
> > news:#IJiqE1wEHA.1292@TK2MSFTNGP10.phx.gbl...
> >> 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
> >>
> >>
> >
>
>

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" <mib00@t-online.de> wrote in message
news:%23KGvbgKxEHA.2624@TK2MSFTNGP11.phx.gbl...
> 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" <sharadnaik@nospam-vsnl.net> wrote in message
> news:OK5Zhl$wEHA.2624@TK2MSFTNGP11.phx.gbl...
>> 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
>> "Michael Bauer" <mib00@t-online.de> wrote in message
>> news:umv3qP$wEHA.1512@TK2MSFTNGP12.phx.gbl...
>> > 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.
>> >
>> > --
>> > Viele Grüße
>> > Michael Bauer
>> >
>> >
>> > "Sharad Naik" <sharadnaik@nospam-vsnl.net> wrote in message
>> > news:#IJiqE1wEHA.1292@TK2MSFTNGP10.phx.gbl...
>> >> 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
>> >>
>> >>
>> >
>>
>>
>