Sign in to follow this  
Followers 0
bshoenhair

Excel Com Support needed

3 posts in this topic

Fairly new to Com in AutoIt Beta

Maybe a simple solution but I am used to VBSript Com and am unable to figure out this issue.

How can I check if an Excel WorkBook is open with the new Com support of the AutoIt Beta ?

Share this post


Link to post
Share on other sites



Fairly new to Com in AutoIt Beta

Maybe a simple solution but I am used to VBSript Com and am unable to figure out this issue.

How can I check if an Excel WorkBook is open with the new Com support of the AutoIt Beta ?

<{POST_SNAPBACK}>

Can you post the VBS code you would use to do the same thing?

Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl

MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model

Automate input type=file (Related)

Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded  Better Better?

IE.au3 issues with Vista - Workarounds

SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead?

Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble

Share this post


Link to post
Share on other sites

Never Mind I figured it out

For $Wb In $Excel.Workbooks
      If $Wb.Name = $WorkBookName Then;Enter ToDo Code Here
Next

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0