Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

workbooks activate error

  Asked By: Ira    Date: Nov 16    Category: MS Office    Views: 820
  

i have a macro which includes a statement workbooks("IATOOL").execute.
This statement works on my machine while it doesnt work on some machines.Gives
error out of range.Any idea why so

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Daisy Phillips     Answered On: Nov 16

The execute  method initiates an action. A workbook is not an action and
cannot be executed. Did you mean to use Activate? If not, could you give us
more information on what you are trying to do?

 
Answer #2    Answered By: Keiko Mori     Answered On: Nov 16


I am extrememly sorry..I meant workbooks("name")activate. I have checked for the
vba references but to no avail. The excel version is also same 2003. That's a
very basic statement  then why should it give error  on some machines while on
others it works  fine?

 
Answer #3    Answered By: Code Guru     Answered On: Nov 16

Some things you could check:

Was the specified workbook open on the machines where the command failed?
Was the name of the workbook spelt correctly?
Were some of the machines set to show file extensions so they would need the
.xls on the workbook name?

If none of these helps, what error  message was produced?

 
Answer #4    Answered By: Qadriyyah Malik     Answered On: Nov 16

I was able to reslove the issue.Actually i didnt put the extension.xls.Hence
some machines gave error
I have modified the stement from workbooks("IATOOL").activate to
workbooks(IATOOL.xls")

 
Answer #5    Answered By: Terry Williams     Answered On: Nov 16

I would try the following statement.

Workbooks("IATOOL.xls").activate

 
Didn't find what you were looking for? Find more on workbooks activate error Or get search suggestion and latest updates.




Tagged: