Using docx files from Access VBA with pre-2007 Word
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
FORGET IT! I have just found where to delete the last one.
peter
peter
In theory, when you install last version, previous version should be replaced.
ASKER
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
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
Does it works if you try to open the file directly ? (i.e. not from MS-Access, but from Windows explorer).
ASKER
That's the first thing I described in my post.
Keep thinking!
peter
Keep thinking!
peter
Yes but AFTER installing "Microsoft Office 2007 Compatibility Pack", could you open the Word document directly from Word 2000-2003 ?
ASKER
NOt in either. Sorry if my descriptions were ambiguous, as described in my post at 05:31 above. It was Office 2002 (XP).
peter
peter
ASKER
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
peter
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
I'm not sure if I understood your last message
ASKER
My app discovers what version of Office lives on the PC it inhabits and adapts its VBA code to .doc or .docx accordingly.
peter
peter
that's ok. Happy to know the problem is solved now.
ASKER
Out of curiosity, tell me. English is not your first language, is it? Thank you for your efforts.
peter
peter
Yes, Peter. You are right.
ASKER
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.
Thanks anyway, especially as you were working in a foreign language.
ASKER
It's good to know it should cure the problem. Do you have any ideas about the second point, deleting the existing one?
peter