Hi Guys
I am new to excel vba and can't make this work.. This is scenario, the value in R2 cell changes at anytime during day and has just changed to AB12CD34EF567. Now I want excel to create a text file name with this cell value in C:\Users\Dell\Downloads.
The catch here is I want this file to be created without *.txt extension. For example, If manually I am creating this file then the procedure would be clicking FILE menu from text file, select SAVE AS option, Give file name as AB12CD34EF567. (notice there is a (.) dot, at the end of file name), select SAVE AS TYPE to ALL FILES, and save the file name.
I do not want any manual intervention in above procedure..
I am new to excel vba and can't make this work.. This is scenario, the value in R2 cell changes at anytime during day and has just changed to AB12CD34EF567. Now I want excel to create a text file name with this cell value in C:\Users\Dell\Downloads.
The catch here is I want this file to be created without *.txt extension. For example, If manually I am creating this file then the procedure would be clicking FILE menu from text file, select SAVE AS option, Give file name as AB12CD34EF567. (notice there is a (.) dot, at the end of file name), select SAVE AS TYPE to ALL FILES, and save the file name.
I do not want any manual intervention in above procedure..