Solved

Using docx files from Access VBA with pre-2007 Word

Posted on 2010-11-24
16
367 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
Windows running painfully slow? Try these tips..

Stay away from Speed Up Computer Programs that do more harm than good.
Try these tips instead.
Step by step instructions in trouble shooting Windows Performance issues.

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

739 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