Solved

Using docx files from Access VBA with pre-2007 Word

Posted on 2010-11-24
16
370 Views
Last Modified: 2012-06-21
I have this app in Access 2007. It makes use of linked Word docx files. When I run this app on a PC with Office pre-2007. Word does not recognise the files - understandable. So I tried to install on this PC the File Format Converter.
2 points:

      would this solve my problem when running my app in association with pre-2007 Word?
     
      Assuming it would, when I try to install the File Format Converter, I am told an earlier version is already there and to get rid of it - but I can't find it in control panel > add or remove programs.

Help!

Many thanks.

0
Comment
Question by:Peborgh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 7
16 Comments
 
LVL 15

Accepted Solution

by:
gplana earned 500 total points
ID: 34206823
You should download last version of "Microsoft Office 2007 Compatibility pack" from Microsoft at
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

This should solve the problem.
0
 

Author Comment

by:Peborgh
ID: 34207045
Thanks,

It's good to know it should cure the problem. Do you have any ideas about the second point, deleting the existing one?

peter
0
 

Author Comment

by:Peborgh
ID: 34207062
FORGET IT! I have just found where to delete the last one.


peter
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Expert Comment

by:gplana
ID: 34207117
In theory, when you install last version, previous version should be replaced.
0
 

Author Comment

by:Peborgh
ID: 34207252
OK, I have installed the latest FFC. When I try to simply open a docx file, I get:

    The document name or path is invalid.

...Try various things: check permissions and use file open dialog box.

When I try open the file via my Access app, I get:

     Error 5121 The document path is not valid. Etc...

... the same!

The path IS valid, I am looking at it.

Any further ideas, anyone?

Thanks,

peter
0
 
LVL 15

Expert Comment

by:gplana
ID: 34207467
Does it works if you try to open the file directly ? (i.e. not from MS-Access, but from Windows explorer).
0
 

Author Comment

by:Peborgh
ID: 34208090
That's the first thing I described in my post.

Keep thinking!

peter
0
 
LVL 15

Expert Comment

by:gplana
ID: 34209157
Yes but AFTER installing "Microsoft Office 2007 Compatibility Pack", could you open the Word document directly from Word 2000-2003 ?
0
 

Author Comment

by:Peborgh
ID: 34209457
NOt in either. Sorry if my descriptions were ambiguous, as described in my post at 05:31 above. It was Office 2002 (XP).

peter
0
 

Author Comment

by:Peborgh
ID: 34213221
Problem solved by getting my app to find out which version of Office Word is present and accordingly manipulate .doc or .docx. Slightlky fiddly but neat, I thought...

peter
0
 
LVL 15

Expert Comment

by:gplana
ID: 34213883
It should work on any version from Word 2000 to Word 2003, so Word 2002 also accepts the compatibility pack.

I'm not sure if I understood your last message
0
 

Author Comment

by:Peborgh
ID: 34214359
My app discovers what version of Office lives on the PC it inhabits and adapts its VBA code to .doc or .docx accordingly.

peter
0
 
LVL 15

Expert Comment

by:gplana
ID: 34214437
that's ok. Happy to know the problem is solved now.
0
 

Author Comment

by:Peborgh
ID: 34214605
Out of curiosity, tell me. English is not your first language, is it? Thank you for your efforts.

peter
0
 
LVL 15

Expert Comment

by:gplana
ID: 34217207
Yes, Peter. You are right.
0
 

Author Closing Comment

by:Peborgh
ID: 34237592
It should have worked but in the dn I found my own way out of the problem...
Thanks anyway, especially as you were working in a foreign language.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

632 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