Looking for VBA code.

[Closed]
Report
Posts
8
Registration date
Friday June 15, 2018
Status
Member
Last seen
July 5, 2018
-
Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
-
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

Posts
47365
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 2, 2021
10,767
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!