Unable to Find the Existing Excel File RRS feed

  • Question

  • I have been used GetObject to access the required excel file but am unable to find that excel.

    Have multiple excel files are opened in Desktop whereas particular excel file not showing in the count.

    when i opened separately that workbook alone am getting the count.

    Please advise.

    my VB Script code :

    Set xlapp = Getobject(,"Excel.application")

    set wbs = xlapp.wokbooks

    msgbox wbs.count ' here am getting count as 0 instead of 1

    Tuesday, July 2, 2019 6:44 AM

All replies