how to open another excel file from vba 1

[Sarmx]

Dear Friends,

I need to access the information on another excel
file (from a current excel file) i need some help

is it possible to just read the information and not
opening the other excel file???

please send me some codes thad does this, i am an experienced programmer but very new to Excel vba...

thank you much,

ps. i use excel 2002

 

[RonRepp]

You can use ADO (see ConnectionStrings.com for appropriate constring) through VBA, but then you have to treat the Excel sheet like a database.

It would be much easier to do something like this:

Dim Act as string
Dim NewWB as string

Act=Activeworkbook.Name

NewWB=WorkbookToOpen

Workbooks.Open(NewWB)

ActiveWindow.Visible = False'If you want to hide from other users

Sheets(Act).Activate

'...Use code to access ranges for data.

I hope this helps.



Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[rmikesmith]

If interested, here is a link to a function on John Walkenbach's site that allows you to retrieve a value from a closed workbook:

http://www.j-walk.com/ss/excel/tips/tip82.htm

Regards,
Mike