The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » Problem with Workbook.activate command

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Problem with Workbook.activate command

Resolved · Medium Priority · Version 2003

ReplyThu 15 Jan 2009, 14:24Delegate Michael said...

Problem with Workbook.activate command

I am having a problem with using the workbook.activate command across different users in my office. We are all running the same version of excel, but on some computers the code errors, as an example consider a workbook called "Example" that I would like to select as part of the program, on the problem computers this errors out at the line:

Workbooks("Example").activate

the error message stipulates that basically it doesn't understand the command. on the problem computers I ahve done the obvious things such as install the VBA and VBA analysis toolpacks, and this has not resolved the issue.
When I comment out the problem line the program runs without an issue, can anyone help me with this?

For upcoming training course dates see: Pricing & availability

ReplyWed 21 Jan 2009, 14:44Trainer Laura said...

RE: Problem with Workbook.activate command

Thank you for your question.

One thing that might be causing the error is the missing extension from the workbook name. Do the PCs having problems have autosave turned on? Saving for some reason adds the extension to the name. So the following would work after a save

Workbooks("Example.xls").Activate

If that is not the issue then you possible could at a point when you know Example is the activeworkbook, for example when you open or create it and use the following

Dim wkExample as Workbook

Set wkExample = ActiveWorkbook

And then later when you need to activate it.

wkExample.Activate

I hope that helps

Laura GB

ReplyThu 22 Jan 2009, 09:18Delegate Michael said...

RE: Problem with Workbook.activate command

Thanks Laura,

You were right it was a problem over the extension not being listed, I have made the necessary adjustments and now my code works perfectly.

Thanks again

Michael

VBA articles

· Why Use VBA In The Office 2010 Suite?
· Computer Programming Made Easy With VBA
· How VBA Can Add Power To Your PowerPoint Presentations
· Create An Excel VBA Add In
· Stay In The Loop With VBA

Please browse our web site to find out more about
access vba introduction and other Microsoft training courses.

Vba tip:

Empty The Clipboard with CutCopyMode

After each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips

How?