Creating Word docs from Excel with VBA
 

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,

Creating Word docs from Excel with VBA
 

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.

"Lee" wrote:

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,

Creating Word docs from Excel with VBA
 

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,

"JLGWhiz" wrote:

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.

"Lee" wrote:

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,

Creating Word docs from Excel with VBA
 

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,


"Lee" wrote:

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,