Solved

Using docx files from Access VBA with pre-2007 Word

Posted on 2010-11-24
16
364 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
  • 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
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This article will show you how to use shortcut menus in the Access run-time environment.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

820 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