I've been working on a project in VBA, and what its doing is reading an
excel file and writing out a fixed format text file using some of the
data in the excel file. I'm writing out the text file using the # Print
Statement.

What I need is a way to specify the drive and path for the text file
that will be output. If it were straight VB I could use the DriveList
and DirList controls, but I cannot seem to find an equivalent in VBA.

I don't believe Common Dialog Control will work either because I'm not
saving the excel file. I'm taking data from the excel file and writing
it to the text file. The Cdlg will save the excel file after the dialog
box is closed.

Does anyone know if those controls exist in VBA? And if not, is there a
suggested work around?


---
Message posted from http://www.ExcelForum.com/