VBS Encoded in to excel

[DANZIG]

Hello,
I was curious about encoding vbs in to an excel workbook. I mostly write vbs administration scripts and have them use excel as the output media. Doing that requires 2 files the preformatted xls file and the vbs script file.

My question, is there a way of encoding the vbs code in to an xls file using vba? The idea is that I could distribute the xls file and when it's opened the code would execute with out requiring the vbs script to be a separate file.

Also, what is a good vba reference book to get started in vba coming from a vbs administration scripting back ground?

Thanks in advance.

 

[shrubble]

I'm not clear on the VBS thing.

"VB6 From the ground up" (Gary Cornell), while it's a straight VB book, carries over to VBA VERY well. The more I use VBA, the less it seems any different to VB at all...

Hope this helps

-Shrubble

http://www.ishrubble.com