View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Open txt file using vba code


Hi Tom,

You should be able to record a macro to open the file. If you need further
help to modify the recorded code to make it more dynamic to say match a
filename in an existing worksheet or something then post the code you
recorded and describe how you want to make the code more dynamic.

--
Regards,

OssieMac


"tom" wrote:

In MS-excel2003, when we click on a button we have to open a txt file which
we already assigned.Please suggest vba code for this.