DATA Step, Macro, Functions and more

export to excel fails due to file name already exist

Reply
Contributor
Posts: 70

export to excel fails due to file name already exist

can rename the old file and generate the new excel file. or create a number next to the file.

Super User
Posts: 23,928

Re: export to excel fails due to file name already exist

Please take the time to add some more detail to your questions. Vague question = vague answers.

 

So the solution to what I'm assuming is your question, is to use FEXIST to check if the file already exists and if it does then create a new name and repeat until you have a unique name.  A common solution is to add a datetime stamp to the end to ensure uniqueness. I'm less of a fan of this option. 

 


@radha009 wrote:

can rename the old file and generate the new excel file. or create a number next to the file.


 

Ask a Question
Discussion stats
  • 1 reply
  • 68 views
  • 0 likes
  • 2 in conversation