word automation

Question

Hi,

I have 2 questions about using word automation here.

1. when I use "copy to (file name) type delimited", is there any specific type for word or I can just stay with delimited?

2. If I want to save doc to docx by using saveas(forceext(file name,"docx")), it will cause an error (incompatible issue). I can use it to save xls to xlsx but can't do this for word. any hints?

thanks for your time

Char

Answer 1

Hi Char,

1. i suggest you to stay with delimited because you can open delimited file in word.

2. give sample code for this question.

Kalpesh

---

Please "Mark as Answer" if this post answered your question. :)

Kalpesh Chhatrala | Software Developer | Rajkot | India

Kalpesh 's Blog

VFP Form to C#, Vb.Net Conversion Utility

Answer 2

Kalpesh,

this is the code I use to save as into another extension in word but I receive an error.

oleApp.ActiveDocument.SaveAs(forceext(file name,"docx"))

thanks

Char

Answer 3

Giving the document an extension of DOCX doesn't make it a DOCX. If you want to save it in the DOCX format, you need to pass the optional second parameter to SaveAs, specifying the format you want. I think the right value is 12, but you can find the list here: http://msdn.microsoft.com/en-us/library/ff839952.aspx.

Of course, you can only save in DOCX format if you're in Word 2007 or later, or have the compatibility add-on for Word 2003.

Tamar

P.S. Saving an Excel workbook with an extension of XSLX doesn't make it an XSLX file, either. Same solution.

Answer 4

Giving the document an extension of DOCX doesn't make it a DOCX. If you want to save it in the DOCX format, you need to pass the optional second parameter to SaveAs, specifying the format you want. I think the right value is 12, but you can find the list here: http://msdn.microsoft.com/en-us/library/ff839952.aspx.

Of course, you can only save in DOCX format if you're in Word 2007 or later, or have the compatibility add-on for Word 2003.

Tamar

P.S. Saving an Excel workbook with an extension of XSLX doesn't make it an XSLX file, either. Same solution.

How do I know the excel file made in Excel 2003 or Excel 2007?

Sandor

---

Sandor

Answer 5

Check the workbook's FileFormat property.

Tamar