Creating Word docs from Excel with VBA

L

Lee

I am a newbie to Excel 2007 and Word 2007. I wrote the code in Excel 2007 to
create a Word 2007 document which has a *.docx extension but I can't open it
up unless I change the extension to *.doc; I get a cryptic error message
suggesting what the problem might be but none of them apply.

However, if I create a Word document within Word 2007 and save it with a
*.docx extension it opens back up just fine. It seems like when the Word
document is created with Excel VBA code there is a problem.

Does anyone have any idea what might be going on?
Thanks in Advance,
 
J

JLGWhiz

Do you still have a previous version of Work on your system? If you do, it
is possible that when you open from Excel, you are opening the older version
and it will not save as .docx. If you are sure you are opening in Word 2007,
then I have no clue why it will not take the .docx.
 
L

Lee

I checked and I don't have any previous version of Microsoft Word, just
Office 2007 (Word and Excel). Does anyone else have any ideas what might be
going on?
Regards,
 
L

Lee

Problem Solved. Actually, John Walkenbach (Mr. Spreadsheet) pointed out that
the problem was created because I had Word 2007 setup to use DOC as the
default save format. I hope this dialog helps someone else in the future.
Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top