ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   is excel by itself enough to do scripting? (https://www.excelbanter.com/excel-programming/313570-excel-itself-enough-do-scripting.html)

gee at excel

is excel by itself enough to do scripting?
 
Hi,

I am trying to implement Excel with more features via scripts that use VB.
1) Is that capability already built into Excel or do I need some kind of
version of VB that can support the scripts?
2)Is the VB version free or do I need some other special Excel that has the
capability built in?
3) What are your suggested books on Excel that well support the script in
Excel 2000?


Thank you,

George

--
how to exel in excel

Kevin

is excel by itself enough to do scripting?
 
With Excel you can use Visual Basic for Applications (VBA)which is built in.
Open Excel and press Alt-F11 to bring up the VBA editor. That is all you
need.

As far as good reference books, I am not sure. I would recommend just going
to the book store and browse. I have done a fair amount using Help and this
forum. You can receive answers to most of your questions here. Help can be
difficult to use, but as you learn how VBA is structured Help gets a little
easier to use.

Hope that helps!

Kevin

"gee at excel" wrote:

Hi,

I am trying to implement Excel with more features via scripts that use VB.
1) Is that capability already built into Excel or do I need some kind of
version of VB that can support the scripts?
2)Is the VB version free or do I need some other special Excel that has the
capability built in?
3) What are your suggested books on Excel that well support the script in
Excel 2000?


Thank you,

George

--
how to exel in excel



All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com