Skip to Content
author's profile photo Former Member
Former Member

Method to check any excel file is open or not on presentation server or pc

I am downloading the data of ALV to Excel using OLE methods, but before downloading how can i check that any excel file is already open on PC or not?

We have options to check whether the excel file is already open or not with the known name but how we can check for the opened file without knowing its name or path?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on May 19, 2015 at 01:39 PM

    Hi!

    Maybe checking that Excel is running as a process will be sufficient for you?

    Then you can google the macro easily like for example this one. Besides that, another idea is suggested there - getting a list of open windows. Please, have a look.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 16, 2015 at 01:47 PM

    Hi Yash

    try to upload and download the file in the presentation.

    If file is already opened you receive an exception.

    I used cl_gui_frontend_serivces methods (gui_upload and gui_download)

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.