PC Review


Reply
Thread Tools Rate Thread

Creating Word docs from Excel with VBA

 
 
Lee
Guest
Posts: n/a
 
      7th Nov 2008
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,
 
Reply With Quote
 
 
 
 
JLGWhiz
Guest
Posts: n/a
 
      7th Nov 2008
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,

 
Reply With Quote
 
Lee
Guest
Posts: n/a
 
      7th Nov 2008
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,

 
Reply With Quote
 
Lee
Guest
Posts: n/a
 
      7th Nov 2008
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,

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Creating PDF forms from Word docs Suzanne S. Barnhill Microsoft Word New Users 0 27th Jun 2011 01:25 PM
Creating Word Docs from Excel Data kyle.krisher@gmail.com Microsoft Excel Misc 1 8th Oct 2006 02:55 AM
Error creating big Word docs in asp.net =?Utf-8?B?TWVrZW4=?= Microsoft ASP .NET 1 8th Jun 2005 07:08 AM
Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs mr_melvis Microsoft Excel Worksheet Functions 1 8th Apr 2005 03:00 AM
converting excel docs to word docs =?Utf-8?B?cm9sZXJjc3Rlcg==?= Microsoft Excel New Users 2 4th Jan 2005 07:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:53 PM.