Looking for VBA code.

Closed
MUKUL_1308 Posts 8 Registration date Friday 15 June 2018 Status Member Last seen 5 July 2018 - 15 Jun 2018 à 17:36
Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 - 15 Jun 2018 à 18:07
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..
Related:

1 response

Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 11,166
15 Jun 2018 à 18:07
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