View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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,