VBA code for command button [Solved/Closed]

Report
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
-
MUKUL_1308
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
-
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..

1 reply

Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
1,686
Have you ever rerecorded a SAVE AS macro?

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

MUKUL_1308
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018

sir,
it's still not working
ac3mark
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
1,686
Did you record a macro? Post it here, and I will assist with changing it to a Dynamic Script!
MUKUL_1308
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018

Sir,
thank you so much now it's working perfectly. thanks a lot.