Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Filesystem Object


Message #1 by "Staci Grogan" <staas2sean@a...> on Tue, 18 Feb 2003 20:51:51
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.


  Return to Index