Solved

Using docx files from Access VBA with pre-2007 Word

Posted on 2010-11-24
16
356 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
 
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now