PC Review


Reply
Thread Tools Rate Thread

Copying my macro to other PCs

 
 
Sharad Naik
Guest
Posts: n/a
 
      5th Nov 2004
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


 
Reply With Quote
 
 
 
 
Michael Bauer
Guest
Posts: n/a
 
      6th Nov 2004
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" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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
>
>


 
Reply With Quote
 
Sharad Naik
Guest
Posts: n/a
 
      6th Nov 2004
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" <(E-Mail Removed)> wrote in message
news:umv3qP$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
>> 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
>>
>>

>



 
Reply With Quote
 
Michael Bauer
Guest
Posts: n/a
 
      7th Nov 2004
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" <(E-Mail Removed)> wrote in message
news:OK5Zhl$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:umv3qP$(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > news:#(E-Mail Removed)...
> >> 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
> >>
> >>

> >

>
>


 
Reply With Quote
 
Sharad Naik
Guest
Posts: n/a
 
      7th Nov 2004
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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:OK5Zhl$(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:umv3qP$(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> > news:#(E-Mail Removed)...
>> >> 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
>> >>
>> >>
>> >

>>
>>

>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Macro John Calder Microsoft Excel New Users 3 3rd Apr 2009 10:21 AM
copying using a macro divad Microsoft Excel Worksheet Functions 3 27th Jun 2008 10:49 PM
copying with a Macro =?Utf-8?B?RG9uVA==?= Microsoft Excel Worksheet Functions 2 24th Mar 2006 08:45 PM
Copying with a macro =?Utf-8?B?RG9uVA==?= Microsoft Excel Worksheet Functions 2 23rd Mar 2006 04:04 AM
Macro copying macro code TNSKHelp Microsoft Excel Programming 1 17th Jun 2005 05:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:03 AM.