get other workbook objects values

[baha17]

Hi,
I wanna run the code which will read it through other workbook.But
following command giving an error
For Each Sht In Workbooks("H:\Copy of GSM ROSTER.xls").Sheets . how
can I read the other workbook object without copy. by the way when my
sheet opens,it opens Copy o ("H:\Copy of GSM ROSTER.xls" as read
only.Any idea how to refer to new open table.
Thanks for the help

 

[Chip Pearson]

Don't put the full path name in the Workbooks collection index. Instead, use
just the unqualified file name with no drive or path info. E.g.,

For Each Sht In Workbooks("Copy of GSM Roster.xls").Sheets

Or, you can use a Workbook reference when you open the file. E.g.,

Dim WB As Workbook
Set WB = Application.Workbooks.Open("H:\Copy Of GSM Roster.xls")
For Each Sht In WB.Sheets


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[baha17]

Don't put the full path name in the Workbooks collection index. Instead, use
just the unqualified file name with no drive or path info. E.g.,

For Each Sht In Workbooks("Copy of GSM Roster.xls").Sheets

Or, you can use a Workbook reference when you open the file. E.g.,

Dim WB As Workbook
Set WB = Application.Workbooks.Open("H:\Copy Of GSM Roster.xls")
For Each Sht In WB.Sheets

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
    Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)






- Show quoted text -

Thanks chip,
it works perfect,
have a nice day
regards,
baha