Word VBA Errors

Hello,

I have a VB application which calls the templates stored on a network share.
These templates support wordbasic. Everything was fine untill Office 2003,
but when i upraded to Office 2007 the word templates have stopped working.
Whenever the VB application tries to open the file it throws an error "Sub or
Funcion not defined" and "Microsoft Visual Basic" written in the title bar.
I've also added the network share in the trusted locations. Can anybody help
me solve this issue please?

Jonathan
Mon May 12 07:50:57 PDT 2008


"Shoukhat Khan" <ShoukhatKhan@discussions.microsoft.com> wrote in message
news:1B616F1F-1BB8-4B03-BAE2-91FD3BF4C188@microsoft.com...
> Hello,
>
> I have a VB application which calls the templates stored on a network
> share.
> These templates support wordbasic. Everything was fine untill Office 2003,
> but when i upraded to Office 2007 the word templates have stopped working.
> Whenever the VB application tries to open the file it throws an error "Sub
> or
> Funcion not defined" and "Microsoft Visual Basic" written in the title
> bar.
> I've also added the network share in the trusted locations. Can anybody
> help
> me solve this issue please?
>

You need to open up the VBA editor and find out which line of code is
causing the error. Once you know which line of code is causing the error,
you can start working out what needs to be changed to prevent it.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

ShoukhatKhan
Mon May 12 08:07:01 PDT 2008

Thanks for the reply Jonathan, I tried to see the code through VBA editor and
the code seems to be blank. Maybe it has been protected or has disallowed
access to see it. I have the original templates, how do i see the code
through VBA editor?

"Jonathan West" wrote:

>
> "Shoukhat Khan" <ShoukhatKhan@discussions.microsoft.com> wrote in message
> news:1B616F1F-1BB8-4B03-BAE2-91FD3BF4C188@microsoft.com...
> > Hello,
> >
> > I have a VB application which calls the templates stored on a network
> > share.
> > These templates support wordbasic. Everything was fine untill Office 2003,
> > but when i upraded to Office 2007 the word templates have stopped working.
> > Whenever the VB application tries to open the file it throws an error "Sub
> > or
> > Funcion not defined" and "Microsoft Visual Basic" written in the title
> > bar.
> > I've also added the network share in the trusted locations. Can anybody
> > help
> > me solve this issue please?
> >
>
> You need to open up the VBA editor and find out which line of code is
> causing the error. Once you know which line of code is causing the error,
> you can start working out what needs to be changed to prevent it.
>
>
> --
> Regards
> Jonathan West - Word MVP
> www.intelligentdocuments.co.uk
> Please reply to the newsgroup
>
>

Jonathan
Mon May 12 08:26:26 PDT 2008


"Shoukhat Khan" <ShoukhatKhan@discussions.microsoft.com> wrote in message
news:DD994640-E669-4AD4-9784-16A4C34DF9C1@microsoft.com...
> Thanks for the reply Jonathan, I tried to see the code through VBA editor
> and
> the code seems to be blank. Maybe it has been protected or has disallowed
> access to see it. I have the original templates, how do i see the code
> through VBA editor?

Press Alt-F11 to open the editor. In the pane on the left, which shows the
list of documents and templates that might contain code, double-click on the
template you want. If the code is password-protected, then you will be
prompted for the password.

If the code you want is in an add-in rather than in Normal.dotm or in a
template attached to a document, then you need to open the add-in as a
document before you will be able to see the code in the VBA editor.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

ShoukhatKhan
Mon May 12 08:51:01 PDT 2008

Hello Jonathan,

Maybe my questions would be a bit too light as i am not so well verse with
owrd templates and macros. I tried to see the code as suggested by you, but
if i open the template normally through File...Open command it never shows me
the macros. If i use my VB application to call the template then only it
shows the code. Any idea how i can overcome this?

"Jonathan West" wrote:

>
> "Shoukhat Khan" <ShoukhatKhan@discussions.microsoft.com> wrote in message
> news:DD994640-E669-4AD4-9784-16A4C34DF9C1@microsoft.com...
> > Thanks for the reply Jonathan, I tried to see the code through VBA editor
> > and
> > the code seems to be blank. Maybe it has been protected or has disallowed
> > access to see it. I have the original templates, how do i see the code
> > through VBA editor?
>
> Press Alt-F11 to open the editor. In the pane on the left, which shows the
> list of documents and templates that might contain code, double-click on the
> template you want. If the code is password-protected, then you will be
> prompted for the password.
>
> If the code you want is in an add-in rather than in Normal.dotm or in a
> template attached to a document, then you need to open the add-in as a
> document before you will be able to see the code in the VBA editor.
>
>
> --
> Regards
> Jonathan West - Word MVP
> www.intelligentdocuments.co.uk
> Please reply to the newsgroup
>
>
>

Jonathan
Mon May 12 09:15:58 PDT 2008


"Shoukhat Khan" <ShoukhatKhan@discussions.microsoft.com> wrote in message
news:3F5C6EC0-6CD0-4247-9689-EAA84C83DE62@microsoft.com...
> Hello Jonathan,
>
> Maybe my questions would be a bit too light as i am not so well verse with
> owrd templates and macros. I tried to see the code as suggested by you,
> but
> if i open the template normally through File...Open command it never shows
> me
> the macros. If i use my VB application to call the template then only it
> shows the code. Any idea how i can overcome this?
>

Open the template. Then open the VBA editor. Then double-click on the
template's VB project in the VBA editor. if there is a password, you will
now be prompted for it.

If you want to get to grips with the basics of Word programming, take a look
at these articles. The fact is that if you don't have some idea of what you
are doing in terms of writing VBA code, you are unlikely to be able to work
out what is going wrong with the code which somebody else wrote.

What do I do with macros sent to me by other newsgroup readers to help me
out?
http://www.word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

Creating a macro with no programming experience using the recorder
http://www.word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm

Getting To Grips With VBA Basics In 15 Minutes
http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

There are lots more articles on the Word MVPs website - VBA is something you
never entirely finish learning - but these should get you started.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

ShoukhatKhan
Mon May 12 09:29:01 PDT 2008

Thanks for this information Jonathan, one more thing what i noticed was, If i
open try to get into VB editor to see the macros all of them have
disappeared. The macros which i can see for the same document under
Office2003 are not visible in Office2007. Is it any security issue which is
stopping these macros from loading.

I have also enabled all the macros in the trust centre and also added the
netowrk share in the trusted locations.

"Jonathan West" wrote:

>
> "Shoukhat Khan" <ShoukhatKhan@discussions.microsoft.com> wrote in message
> news:3F5C6EC0-6CD0-4247-9689-EAA84C83DE62@microsoft.com...
> > Hello Jonathan,
> >
> > Maybe my questions would be a bit too light as i am not so well verse with
> > owrd templates and macros. I tried to see the code as suggested by you,
> > but
> > if i open the template normally through File...Open command it never shows
> > me
> > the macros. If i use my VB application to call the template then only it
> > shows the code. Any idea how i can overcome this?
> >
>
> Open the template. Then open the VBA editor. Then double-click on the
> template's VB project in the VBA editor. if there is a password, you will
> now be prompted for it.
>
> If you want to get to grips with the basics of Word programming, take a look
> at these articles. The fact is that if you don't have some idea of what you
> are doing in terms of writing VBA code, you are unlikely to be able to work
> out what is going wrong with the code which somebody else wrote.
>
> What do I do with macros sent to me by other newsgroup readers to help me
> out?
> http://www.word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm
>
> Creating a macro with no programming experience using the recorder
> http://www.word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
>
> Getting To Grips With VBA Basics In 15 Minutes
> http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm
>
> There are lots more articles on the Word MVPs website - VBA is something you
> never entirely finish learning - but these should get you started.
>
>
> --
> Regards
> Jonathan West - Word MVP
> www.intelligentdocuments.co.uk
> Please reply to the newsgroup
>
>