VBA code for command button [Solved/Closed]

MUKUL_1308 5 Posts Friday June 15, 2018Registration date June 21, 2018 Last seen - Jun 15, 2018 at 07:58 PM - Latest reply: MUKUL_1308 5 Posts Friday June 15, 2018Registration date June 21, 2018 Last seen
- Jun 20, 2018 at 06:10 PM
hello everyone,
i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate worksheet in the same workbook(abc123.xlsm). now the next thing is I want to create a common command button which moves data of each sheet into different excels files(could be named as target1.xlsx , target2.xlsx, target3.xlsx . . . . . . .. up to target10.xlsx). all target files are available in different folder named as "track". i am unable to create a vba code for that command button .
the thing that command button should do is :
" open target file then move data then save and then close the target file "

please help me for this..
See more 

4 replies

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Jun 17, 2018 at 09:07 PM
0
Thank you
Have you ever rerecorded a SAVE AS macro?

I encourage you to actually record a MACRO, and look at the code!

MUKUL_1308 5 Posts Friday June 15, 2018Registration date June 21, 2018 Last seen - Jun 19, 2018 at 02:45 PM
sir,
it's still not working
ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Jun 19, 2018 at 04:37 PM
Did you record a macro? Post it here, and I will assist with changing it to a Dynamic Script!
MUKUL_1308 5 Posts Friday June 15, 2018Registration date June 21, 2018 Last seen - Jun 20, 2018 at 06:10 PM
Sir,
thank you so much now it's working perfectly. thanks a lot.