I need help with VBA code to make a folder - in the same folder where is the file I run macro. That folder must have the name from cell A4. In this folder I need to create excel file named from cell A6.
Example:IF in cell A4 is TTX and in cell A6 is 111. I need to create folder named TTX an inside to create file 111.xls or 111.xlsx.In this file 111.xls must be copyed - with formathing - all data between column F and column ATfrom the file I run macro.
Sorry for my bad English.
Example:IF in cell A4 is TTX and in cell A6 is 111. I need to create folder named TTX an inside to create file 111.xls or 111.xlsx.In this file 111.xls must be copyed - with formathing - all data between column F and column ATfrom the file I run macro.
Sorry for my bad English.