ah. i wasn't aware i could use the standard excel object hierarchy directly from a vbs script. handy that.
replacing
source_content = source_file.ReadAll function
with
source_content = source_file.activesheet.cells(1,1).value
seemed to work fine.
I guess my worry is that if something...
Isn't that what I am doing in my first two lines? The file is opening fine, I just apparently don't know the syntax for reading the data once it is open.
saving as csv really isn't an option, since downstream scientific machine processes require the file in xlsx format.
Hi all,
Stupid, basic question I am sure, but I am having trouble having a VBScript file open & access data from an xlsx file. My method works fine for .txt and .csv files, but not sure on the syntax needed for .xlsx files.
set FSO_source = createobject("Excel.Application")
set source_file...
Hi all,
Can anyone answer me the following:
1. When selecting a complex set of objects (individually or grouped) and moving the selection with the mouse, why does Visio insist on destroying the alignments between the individual objects?
2. Is there an option anywhere than can be used to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.