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 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - 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 response

Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,168
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