Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
I would like to embed and image into an excel spreadsheet using .vbs
I would like to embed an image into an excel spreadsheet via code. the image is "C:/image.png" and I want to embed it into sheet1:cell:a1:a1 I can put a hyperlink by using this code oEngine.ActiveSheet.Hyperlinks.Add objSheet.Cells(Row, 6), "", screenshotname, screenshotname But I'd like to... -
read xml using vbs to get name value
I have tried this but with no luck Dim sFSpec : sFSpec = "J:\RTA\BT_UC_010.logic" Dim oXDoc : Set oXDoc = CreateObject("Msxml2.DOMDocument") oXDoc.setProperty "SelectionLanguage", "XPath" oXDoc.async = False oXDoc.load sFSpec 'If 5960 = oXDoc.ParseError Then WScript.Echo sFSpec... -
read xml using vbs to get name value
I want to get the value pointed to by the "entityclass name=" thus giving me the value of "Event" - I have attached the file for this. I can get all the node text but I need the name value I am using VBS <vertex eid="423"> <attributes>... -
Is there a way to get all object names within the current active page
I use this in my automated test tool (qtp) - is there a pure vbs method? set PageObjectColl = Browser("micclass:=Browser").Page("micclass:=Page").ChildObjects() print PageObjectColl.count For x = 0 to PageObjectColl.count-1 print PageObjectColl(x).GetROProperty("micclass") print...
