If you wanted to open the file direct as a binary then do it that way.
If you want to manipulate the file directly with excel methods then you are
best recording a macro. convert it to vba code and copy that to vb for the
actions you require.
>> Workbooks.Open Filename:= _
"D:\Documents and Settings\Administrator.DEV-01.000\My
Documents\aml.xls"
Range("B23").Select
prefix with a created excel object
-----Original Message-----
From: Staci Grogan [mailto:staas2sean@a...]
Sent: 18 February 2003 20:57
To: professional vb
Subject: [pro_vb] Filesystem Object
I need to open an excel file thru vba code on an after update. I believe
I will need to know filesytem object but i am not too familiar with
this. Please help.