topic Re: Cannot save file and close application using winword 2007 in Application Development and Automation Discussions

Cannot save file and close application using winword 2007

Former Member — Wed, 11 Aug 2010 07:33:40 GMT

Hi Experts,

We have a custom report that creates an MS Word file as an output. By the end of the report we need to save the MS Word file then close the MS Word application. We are able to successfully save and close in MS Word 2003 using the method below.

**********************

CALL METHOD OF wordobj 'FileSaveAs'

EXPORTING

#1 = zfilename.

CALL METHOD OF wordobj 'FileExit'.

*************************

Why are these methods not working when using MS Word 2007? Please help.

Thanks so much.

-Vlad

Re: Cannot save file and close application using winword 2007

Former Member — Wed, 11 Aug 2010 08:24:13 GMT

Hi,

Have a look at the below link

Veeranji Reddy P.

Re: Cannot save file and close application using winword 2007

Former Member — Wed, 11 Aug 2010 09:18:29 GMT

Hi,

The questions in the thread you showed is also not answered. They are also not able to make he SaveAs method work correctly.

Re: Cannot save file and close application using winword 2007

Former Member — Wed, 11 Aug 2010 09:25:36 GMT

Have you tried the below?

I just found an amazing program by Y.SAITA at erpgenie.com.

While it appears I've clobbered something in my code snippet above by opening the workbook,
Y.SAITA's program data comes from the clipboard and the following works:

h_workbook type ole2_object, "WORKBOOK

cos_saveas type sychar32 value 'SaveAs',
cos_xlworkbook type i value -4143, "*.xls


call function 'FLUSH'
exceptions
cntl_system_error = 1
cntl_error = 2
others = 3.
if sy-subrc = 0.
call method of h_workbook cos_saveas
exporting
#1 = p_file
#2 = cos_xlworkbook.
endif.
(further error checking)


Also, all the other Excel-related methods carry the 'no flush' option.

I'm so confused, but now can do what I needed to.

Still appreciate more of your thoughts, however.

Anyways, if you get to know the answer please share.

Veeranji Reddy P.

Re: Cannot save file and close application using winword 2007

Former Member — Mon, 23 Aug 2010 06:02:02 GMT

Hi,

We have found the solution! The issue is not a programming error. Upon further investigations, it was found that read/write permissions by the Windows user is affecting the 'FileSaveAs' method. You need to make sure that the Windows user generating the report has the permission to save files in the specified folder (file path).

Thanks!