Originally Posted by
balajinatarajan
It actually works, but the text files should be already present in the specified path. Could you please help me with below modifications?
Attached modified userforms,
1. Set Path button from Omni_Data_Miner should create folder mentioned in Path_Field if it does not exist and create 26 text files named in AC15:AC40 in sheet1. If already files exists clears their content.
2. Set FileName text from in Plan_Details form the values from AB2 to AB13 when Record_Selection combobox from Omni_Data_Miner sheet value is selected.
This combobox takes input from AA2 to AB13. When BT Record is selected, that is AA2 is selected then the desired file name is "BT.GEN.DES.PLANS".txt. This value from AB2 should be autopopulated in Plan_Details userform.
The aim is to generate 12 different text files from Plan_Details userform based on the 12 options chosen from Omni_Data_Minor form.
Kindly help me.
Thanks,
Balaji N
Bookmarks