Posted to microsoft.public.excel.programming

Boris[_3_] Boris[_3_] is offline

external usenet poster

Posts: 12

Open a workbook from a written path

On Mon, 22 Sep 2008 15:09:15 -0700 (PDT), HappySenior wrote:

Gary and Boris,
I get a subs-script out of range on both proposed solutions. I used
"A20" as my range. Ideas?
Don in Montana

Have you changed "Sheet1" to the name of your worksheet and entered "A20"
as a range?

B.

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
open Workbook path	Boba	Excel Programming	6	May 7th 08 11:04 PM
Can a macro be written that when you open a workbook the zoom will be set for each sheet?	Marc	Excel Programming	5	April 6th 06 02:14 AM
Open Workbook using URL instead of network path	Raul	Excel Programming	5	March 1st 06 03:53 PM
Get path of open workbook	Peridox	Excel Programming	1	November 29th 05 05:46 AM
how to open workbook without hardcoding path	Michael Turner	Excel Programming	3	November 20th 03 12:12 PM

All times are GMT +1. The time now is 09:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us