Rename filename.csv
in [Programming]
|
From: Rob on 15 Feb 2010 09:42 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
From: Dave Peterson on 15 Feb 2010 10:11 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
From: Rob on 15 Feb 2010 10:59 Thanks Dave, easy when you know what to look up! Regards, Rob "Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message news:4B796420.E08A084D(a)verizonXSPAM.net... > 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
|
Pages: 1 Prev: sendkeys sends every other letter Excel 2007 to Outlook 2007 Next: Help file |