View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
JoyB JoyB is offline
external usenet poster
 
Posts: 2
Default Need Macro to rename excel files

I am trying to rename several non-excel files. . . I bring in all the file names in a given directory into Excel (column A) and want to rename the file using columns A - D. . . . I don't want to open the file and do a saveas. . . When I use the ".Execute() 0 " line, it never seems to find the file name. . . . Any suggestions? I hate using windows explorer to rename files . . . Thanks!