vbscript - Calling a path variable through GetObject() -


what variable created through set name = getobject() calls variable path created before, being path = "z:\vbscript\changeinvnr\batchinput.xlsx", , directed excel file.

my code, doesn't work, is:

set path = createobject("z:\vbscript\changeinvnr\batchinput.xlsx")  dim objexcel dim objsheet  set objexcel = getobject(path)  set objsheet = objexcel.sheets("sheet1")  

which kind of object should path in order called getobject() , how should created - string, object, others?


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -