Eliminating necessity of CMD using VBA

[cadastros]

Hey Guys,

I`m using prompt control to create .txt files to use as data for a database in excel. I`ve come up with a VBA file that opens these .txt and import those infos to a sheet. I would like to eliminate the use of prompt and generate the same files thru VBA code. Also, I would like to custumize the path of the directory that A1 cell could be used as reference to the path. The code that I`m using in prompt control is dir/s/b *dwg >c:\desktop\test.txt.

Thanks!