View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
maryj maryj is offline
external usenet poster
 
Posts: 76
Default fixed width import

I need to import a fixed width text file on a daily basis. The format will
always be the same but the title is different. The text file will always be
in the same folder on my computer. I have tried recording a macro using the
import wizard, but it hard codes the file name. How can I add something to
prompt me for the file name?

Thanks for your help!
--
maryj