Where to start with vbscript?

Hi all,

I've been given a small fairly trivial project to automatically
perform some operations on a spreadsheet like calculate days from
dates and create charts. I've figured vbscript is a good option, I've
seen code snippets that can get me most of what I need, but I'm
wondering where there is say an API or some sort of users guid that
will provide me with the info I need when I come across problems.

Thanks

Lionel.

lionelv
Tue Feb 27 20:54:01 CST 2007

The MSDN has all I need. Thanks

Lionel.


On Feb 28, 9:26 am, "lion...@gmail.com" <lion...@gmail.com> wrote:
> Hi all,
>
> I've been given a small fairly trivial project to automatically
> perform some operations on a spreadsheet like calculate days from
> dates and create charts. I've figured vbscript is a good option, I've
> seen code snippets that can get me most of what I need, but I'm
> wondering where there is say an API or some sort of users guid that
> will provide me with the info I need when I come across problems.
>
> Thanks
>
> Lionel.

TDM
Wed Feb 28 10:58:34 CST 2007


<lionelv@gmail.com> wrote in message
news:1172618763.514273.128440@v33g2000cwv.googlegroups.com...
> Hi all,
>
> I've been given a small fairly trivial project to automatically
> perform some operations on a spreadsheet like calculate days from
> dates and create charts. I've figured vbscript is a good option, I've
> seen code snippets that can get me most of what I need, but I'm
> wondering where there is say an API or some sort of users guid that
> will provide me with the info I need when I come across problems.
>
> Thanks
>
> Lionel.
>

Lionel,

I am guessing you will really be using VBA, not sure why you would
want to use VBS on a spreadsheet when VBA is available. For VBA,
I use the help CHM, you can find the CHM in the Office install.

For Office 2003 :

For Excel
"C:\Program Files\Microsoft Office\OFFICE11\1033\VBAXL10.CHM"
For PowerPoint
"C:\Program Files\Microsoft Office\OFFICE11\1033\VBAPP10.CHM"
For Outlook
"C:\Program Files\Microsoft Office\OFFICE11\1033\VBAOL11.CHM"
For Word
"C:\Program Files\Microsoft Office\OFFICE11\1033\VBAWD10.CHM"


TDM

lionelv
Thu Mar 01 17:12:44 CST 2007

Thanks to both replies. Right you are about using VBA. I'm a Java/C++
programmer/developer etc. whatever :). As such I don't really know
much about what VBA is but that's the reference I've been using from
the MSDN. Still struggling to find specific things that I need to do,
but that's what usenet is for when google fails :).

Lionel.




On Mar 1, 2:58 am, "TDM" <rpu...@gmail.com> wrote:
> <lion...@gmail.com> wrote in message
>
> news:1172618763.514273.128440@v33g2000cwv.googlegroups.com...
>
> > Hi all,
>
> > I've been given a small fairly trivial project to automatically
> > perform some operations on a spreadsheet like calculate days from
> > dates and create charts. I've figured vbscript is a good option, I've
> > seen code snippets that can get me most of what I need, but I'm
> > wondering where there is say an API or some sort of users guid that
> > will provide me with the info I need when I come across problems.
>
> > Thanks
>
> > Lionel.
>
> Lionel,
>
> I am guessing you will really be using VBA, not sure why you would
> want to use VBS on a spreadsheet when VBA is available. For VBA,
> I use the help CHM, you can find the CHM in the Office install.
>
> For Office 2003 :
>
> For Excel
> "C:\Program Files\Microsoft Office\OFFICE11\1033\VBAXL10.CHM"
> For PowerPoint
> "C:\Program Files\Microsoft Office\OFFICE11\1033\VBAPP10.CHM"
> For Outlook
> "C:\Program Files\Microsoft Office\OFFICE11\1033\VBAOL11.CHM"
> For Word
> "C:\Program Files\Microsoft Office\OFFICE11\1033\VBAWD10.CHM"
>
> TDM

m

Blue
Fri Mar 02 11:11:59 CST 2007

On Feb 27, 6:26 pm, "lion...@gmail.com" <lion...@gmail.com> wrote:
> Hi all,
>
> I've been given a small fairly trivial project to automatically
> perform some operations on a spreadsheet like calculate days from
> dates and create charts. I've figured vbscript is a good option, I've
> seen code snippets that can get me most of what I need, but I'm
> wondering where there is say an API or some sort of users guid that
> will provide me with the info I need when I come across problems.
>
> Thanks
>
> Lionel.

I have been learning VBScript hap-hazzardly with the help of some
books and this group mainly. The best IDE that I've seen would have
to be Adersoft VbsEdit and Sapien's PrimalScript would be a close
second. However, these cost money and I'm too cheap to buy them!

I love VBScript because you don't need an expensive compiler to run
it. All you need is Notepad and IE5 (and up) installed on and you're
off to the races! I have been looking for a VBScript bible of sorts
but I don't think one exists except for the script56 help file.