Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
lee lee is offline
external usenet poster
 
Posts: 184
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.programming
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,

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

  #4   Report Post  
Posted to microsoft.public.excel.programming
lee lee is offline
external usenet poster
 
Posts: 184
Default 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,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating new excel docs with links Shinra14 Excel Discussion (Misc queries) 1 April 4th 07 07:18 PM
Creating Word Docs from Excel Data [email protected] Excel Discussion (Misc queries) 1 October 8th 06 02:55 AM
Import cells from excel into word and create multiple word docs scdaddy7269 Excel Programming 2 March 20th 06 07:03 PM
Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs mr_melvis Excel Worksheet Functions 1 April 8th 05 03:00 AM
converting excel docs to word docs rolercster New Users to Excel 2 January 4th 05 07:11 PM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"