Help with Microsoft Script Editor (excel 2002 on win XP)

Topic

New Reply

Hi All,

Basically I need help finding help….

I am trying to debug a works timesheet spreadsheet. And I suspect the ‘cleverness’ of the spreadsheet has been hidden in the Microsoft Script Editor. I have never used this before, only the visual basic editor, where I have created all my previous VBA code.

Does anyone have a good resource about Microsoft Script Editor. Tutorials/ howtos/ why use it???? I have tried googling for it unsuccessfully.

cheers,

david.

Reply | Quote

Replies

David
My version of XP has help built in. Typing {F1} on a field brings it up just like in VBA. Its possible that this is only available because I did an “Install everything” selection when loading Office. Naturally this help is Microsoft’s usual ‘object’ help that gives very little clue on “why”. There was a URL pointing to the Microsoft site for tutorials – but the message that came back was “Sorry couldn’t help” which I interpret to mean page-not-found, but it may have meant subscription-not-paid.

Reply | Quote

David
My version of XP has help built in. Typing {F1} on a field brings it up just like in VBA. Its possible that this is only available because I did an “Install everything” selection when loading Office. Naturally this help is Microsoft’s usual ‘object’ help that gives very little clue on “why”. There was a URL pointing to the Microsoft site for tutorials – but the message that came back was “Sorry couldn’t help” which I interpret to mean page-not-found, but it may have meant subscription-not-paid.

Reply | Quote

David,
I assume this spreadsheet is being used as an HTML or XML document somewhere (eg an office intranet)? Assuming that the language used is VBScript, you will find it is remarkably similar to VBA, albeit with fewer abilities.
I would say that, as Andrew suggested, the online help isn’t bad and if you have specific questions, feel free to post them here!
HTH

Reply | Quote

David,
I assume this spreadsheet is being used as an HTML or XML document somewhere (eg an office intranet)? Assuming that the language used is VBScript, you will find it is remarkably similar to VBA, albeit with fewer abilities.
I would say that, as Andrew suggested, the online help isn’t bad and if you have specific questions, feel free to post them here!
HTH

Reply | Quote

I’m considering jumping into the same pool. You might try a book, such as VBScript in a Nutshell or VBScript Pocket Reference. See if http://www.intranetjournal.com/corner/wrox/progref/vbt/%5B/url%5D, http://www.w3schools.com/vbscript/default.asp%5B/url%5D, http://search.microsoft.com/search/results…cript&View=msdn%5B/url%5D, http://scripting.oreilly.com/%5B/url%5D, and http://www.visualbasicscript.com/%5B/url%5D have any resources of use.

Reply | Quote