Opening .DBF into Excel

Hello All,

Currently trying to open a .DBF Database into my current workbook. I am using

Workbooks.Open(source) which works fine, except it opens the file in another workbook...

And Workbooks("myWorkbook").Open doesn't exist. Any help?

Also, what would be the procedure to save this sheet (after editing) as a .dbf?

Thanks