syed_iqbal
02-11-2017, 06:21 PM
hi,
I written VBA code in my project. but now i need to add some more lines regarding folder options.
while running code, first, macro should ask "choose main folder". Then automatically subfolder should create with the name "today's date" (Ex: 12-Feb-2017) in main folder. we need to assign the total path (drive,main folder and subfolder) to any string variable. if main folder drive is "C:\" or any external device then macro should not accept.
Thank you in advance for helping me.
regards
syed
I written VBA code in my project. but now i need to add some more lines regarding folder options.
while running code, first, macro should ask "choose main folder". Then automatically subfolder should create with the name "today's date" (Ex: 12-Feb-2017) in main folder. we need to assign the total path (drive,main folder and subfolder) to any string variable. if main folder drive is "C:\" or any external device then macro should not accept.
Thank you in advance for helping me.
regards
syed