Steve

Posts: n/a

Help amending code

Hi

I have the following code set to a commandbutton:

Workbooks.Open Filename:= _
"\\Statistics\Year 05-06\September.xls"

However, if the sheet is already open in the background, I get an error
message. What can I add to this code so that, if the sheet is already
open, it just switches over to it?

TIA

Steve

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change case...help please	Terry	Excel Worksheet Functions	14	October 2nd 05 12:29 PM
Macro for changing text to Proper Case	JPriest	Excel Worksheet Functions	3	August 8th 05 09:31 PM
Using other workbooks..	DavidMunday	Excel Worksheet Functions	2	July 1st 05 07:35 AM
Make Change Case in Excel a format rather than formula	Kevin	Excel Worksheet Functions	1	March 18th 05 08:53 PM
Help with Amending this Code Please	[email protected]	Excel Worksheet Functions	4	February 1st 05 07:04 PM

All times are GMT +1. The time now is 02:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us