Looking for VBA code.

Closed
MUKUL_1308
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
- Jun 15, 2018 at 05:36 PM
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
- Jun 15, 2018 at 06:07 PM
HELLO EVERYONE,
I HAD CREATED A MACRO ENABLED WORKBOOK (ABC123.XLSM)WHICH HOLDS ABOUT 10 USERFORMS AND EVERY USERFORM COMPLIES DATA TO SEPERATE WORKSHEET IN THE SAME WORKBOOK(ABC123.XLSM). NOW THE NEXT THING IS I WANT IS 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 . . . . . . .. UPTO 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

Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,312
Jun 15, 2018 at 06:07 PM
Please create a new topic and post again your message, this time, do not use capital letters.

In computer language, using only capital letters is equivalent to shouting, it is considered as aggressive and offensive.

Thank you for your understanding

Moderator
0