Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Using docx files from Access VBA with pre-2007 Word

Posted on 2010-11-24
16
Medium Priority
?
377 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 1500 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
Independent Software Vendors: 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
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: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 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