Thanks Tsuji, the provision of the 'else' and error handling helped me track it down, and in the end it wasn't down to the vbs - it was a missing .js file in the directory containing the linked document (doh!) - your code is a lot tidier than mine, so it's going in! Thanks again, a great help.
Hi, can anyone help a newbie? First post.
I'm using XMLHTTP to test for the existence of an HTM file with VBScript, providing a link if it does (Cant rely on client environment to allow FileSystemObject without annoying ActiveX prompts). Usual thing, works fine on app. 90% of the XP and 2000...
If you're going for cross-browser compatibility, my suggestion won't work, but if you're looking for an IE4+ only solution, DHTML offers a quick option:
<object type="text/x-scriptlet" width=100% height="250" data="data.htm">
</object>
Put the above in the <BODY> section where you want the...
Unless the activeX object you are trying to access is digitally signed, you'll always get the error you report, if security settings are configured to report it. I had this problem with FileSystemObject once (needed to check existence of a file) with the same results - but on using...
Something that I tend to use for this is a very simple function that can be used to derive the total amount of populated rows in a sheet (plus 1).
Define a function i.e:
Public Function TotalRows(sngSheet As Single, Col As Single) As Single
Dim i As Integer
i = 1
Do While...
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.