Macro Toolworks Products Discussion Forums :: General Discussion
Board Index Latest Posts Welcome Guest   
 Subject :microsoft excel 2010.. 13-10-2010 03:22:36 
hugblue@hotmail.com
Joined: 13-10-2010 01:09:07
Posts: 100
Location: sweden
hi ..

are there any excel commands ???
i use microsoft office 2010.

could be to :
open excel document
search or find data in excel document.
write searches to variables.

and if not. plz implement it.

thz.

if there are such commands.
please describe them. then the program would be worth gold for me. smiling.

- - -

and how do i learn vbscript. what books are good to start with, were to begin
with that.
IP Logged
Last Edited On: 13-10-2010 12:32:54 By hugblue@hotmail.com for the Reason
 Subject :Re:microsoft excel 2010.. 18-10-2010 11:30:26 
petr
Joined: 15-10-2009 11:48:52
Posts: 152
Location: 
Hello,

If you want to use Office programs through automation interface then you need to use VBScript. Professional edition comes with VBScript compatible language and integrated IDE (debugger, UI designer, editor). There are very simple examples how to create VBScript macros in the help file or our web site. In addition you can try these two, for example:

http://msdn2.microsoft.com/en-us/library/ms950396.aspx
http://www.w3schools.com/vbscript/default.asp

I'm sure you will find many other if you simply search for "VBScript" on internet.
IP Logged
Page # 


Powered by ccBoard


Login and share your experience - send messages to forums and add comments to samples, commands and other resources.



Account is free of charge, easy to setup.