Unable to Find the Existing Excel File

All replies

• 

  

  0

  Sign in to vote

  Hello,

  you could ask here:

  https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

  https://social.msdn.microsoft.com/Forums/en-US/home?forum=isvvba

  You should give more information there, e.g. your code using GetObject.

  Regards, Guido

  • Proposed as answer by Richard MuellerMVP, Banned Tuesday, July 2, 2019 12:58 PM

  Tuesday, July 2, 2019 6:40 AM
• 

  

  0

  Sign in to vote

  Thanks. i have posted the same at given link

  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

  • Proposed as answer by Richard MuellerMVP, Banned Tuesday, July 2, 2019 12:58 PM
  • Unproposed as answer by Richard MuellerMVP, Banned Tuesday, July 2, 2019 12:58 PM

  Tuesday, July 2, 2019 6:59 AM
• 

  

  0

  Sign in to vote

  Also try asking for help over here.

  https://social.technet.microsoft.com/Forums/scriptcenter/en-US/home?forum=ITCG

   

  ---

  
  Regards, Dave Patrick ....
  Microsoft Certified Professional
  Microsoft MVP [Windows Server] Datacenter Management
  
  Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.
  

  • Proposed as answer by Richard MuellerMVP, Banned Tuesday, July 2, 2019 12:57 PM
  • Marked as answer by pituachMVP Sunday, July 7, 2019 9:40 AM

  Tuesday, July 2, 2019 12:13 PM