View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Ward Jason Ward is offline
external usenet poster
 
Posts: 8
Default I need Code to open DBF file in an excel worksheet



Hi All,

Here is what I am trying to do. I have a button called "Open" which is
used to bring up the file open window code as follows: myfilepath =
myapp.GetOpenFilename(",*.dbf", , "Open File")

My questions is; is there a way that I can now add some code here so
that the file i choose opens in Worksheet1. Along the same lines as:
Destination:=Worksheets("Sheet1").Range("A1")

I cannot seem to get it working any ideas would be welcomed.

Jason

*** Sent via Developersdex http://www.developersdex.com ***