View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Rename filename.csv

Look at VBA's help for FileCopy or Name.



Rob wrote:

Hi,

I am wanting to use some OpenText code to open a file but the file is
currently named with an CSV extension. Whilst I could go to File Manager
and rename this with a TXT extension, I'd like to do this from within Excel
or create a copy and name it with a TXT extension. Is this possible?

Thanks, Rob


--

Dave Peterson