TextBox1 input path below:


The code is:
The SaveAs Filename:=TextBox1 & amp; "" & amp; K (I) & amp; ". XLSX "

Prompt error, error content below:


Please help ~ ~ ~!!!!!

CodePudding user response:

" C: \ what file? Exist?

CodePudding user response:

reference 1st floor milaoshu1020 response:

" C: \ what file? Exist?

Does not exist, I by statements, select directory, TextBox1 display is directory address, I want to put the new workbook, in this directory,

CodePudding user response:

Your "51 a12100" screenshots of text content and don't go with you,
Did you make wrong object ""???