open DBF and save as CSV

_t_oak

New Member
Joined
Mar 11, 2021
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi, i'm relatively new to using Excel and writing macro's. I have 11 folders with around 130 DBF files with Data from a customers machine, I need a way to automate the conversion of these to CSV or xslx so i'm not having to manually open and save as almost 1500 files.

thanks,

Tom :)
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,394
Office Version
  1. 365
Platform
  1. Windows
Welcome to the Board!

If you open a blank Excel file, turn on your Macro Recorder and record yourself opening, saving, and closing one of these files, then shutting off the Macro Recorder, you will have the code you need to do that part of it. Then, you just need to wrap that code in a loop that loops through all the files.

If you need help with that, follow the steps I mentioned above and paste your recorded code here for us to see.
Then let us know the file paths where these 130 DBF files are found.
 

_t_oak

New Member
Joined
Mar 11, 2021
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Welcome to the Board!

If you open a blank Excel file, turn on your Macro Recorder and record yourself opening, saving, and closing one of these files, then shutting off the Macro Recorder, you will have the code you need to do that part of it. Then, you just need to wrap that code in a loop that loops through all the files.

If you need help with that, follow the steps I mentioned above and paste your recorded code here for us to see.
Then let us know the file paths where these 130 DBF files are found.
hi joe,

i did some googling and did pretty much exactly that and am now wrapping it up.
thank you for the advice
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,394
Office Version
  1. 365
Platform
  1. Windows
i did some googling and did pretty much exactly that and am now wrapping it up.
thank you for the advice
Excellent! Glad to hear it!

If you run into any trouble, post your code and question here, and we can help you put the finishing touches on it.
 

Forum statistics

Threads
1,143,637
Messages
5,719,972
Members
422,253
Latest member
frankie2016tata

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top