I have a userform which I would like to transfer the data the several worksheets.

[walid ali]

Hi

I have a userform which I would like to transfer the data the several worksheets.

However, I could not get the correct vba code, To enter data from a UserForm into two separate worksheets without opening Excel spreadsheets.

Please help me with the following:

1) I want to enter the data from the UserForm into two separate Excel files consisting of 4 columns in each of the two files, through the Input in UserForm textbox.

2) Neither Excel file should be opened.

There is a problem with all the codecs I've worked on, which is that after executing the command, one of the two files opens, which I don't want to happen.


Thank you.


With Regards
Waleed

[davesexcel]

You need to supply additional information.

Your previous thread look similar to this thread.

You have to open the other workbooks in order to add data to it.

[walid ali]

Unfortunately this is not helpful
Hope my post was clear to you
Thanks

[AliGW]

@Walid Ali

The post was perfectly clear and NOT unhelpful, unlike your reply, which is. If you are not prepared to give extra detail, don't expect any help. YOU are the one asking for help!!!

[walid ali]

Hi
And thanks for your interest

I've tried all of these suggestions but to no avail
What I want to do is enter data from UserForm directly into Excel files using VBA

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[walid ali]

Sorry, I didn't read your reply completely

Yes, I understand now

Thank you so much ...

Well ... what additional details are needed
Do you want to attach two Excel files that I want to work on?.

What I would like to clarify here is that my work file is in a different spin "Arabic language"

I wanted to know how to do what was needed

Anyway, if you want me to attach my work file
This is a beautiful thing ... I would be grateful for your help

[davesexcel]

Supply the required workbooks and the workbook with the UserForm.

[walid ali]

good morning

I apologize for my late reply


I would like to copy 4 columns from one workbook to another
Columns are "A - I - M - N"
And upon modification or addition
A change occurs in another file.

Hope that was clear and hope for help.

Neither Excel file should be opened.



1 - The first "Final workbook" UserForm



Just send pictures for clarification
It is important to look at the pictures


Attachment 708555

Attachment 708556

Attachment 708557

Attachment 708558


2 - The second workbook "Student Fee" to copy data to




thank you for your help

[davesexcel]

Neither Excel file should be opened.

This is not possible,
Good luck.

[catnam]

As the last responder said to you, you cannot do what you want without the workbooks being open.

What might work is to password protect both workbooks, then in the code, unprotect & open, the source workbook, copy the data, close & password protect source workbook, then open destination workbook with password, paste the data & close, then reapply password protection to the destination workbook. it all happens in the blink of an eye!

Both workbooks may need to be in the same folder. This should go extremely fast and the users will never know either workbook was opened. Just my suggestion.

But whatever you do, you will need to upload the actual files you are working on, to get the proper help you need. I believe the forum is designed to assist you (with your actual files), not create a file for you from scratch, based just on a picture or your request. I believe you must pay for that type of assistance, which I think is available here.

By uploading your actual file, you are showing others that you are trying, thus they will be more willing to help, just out the goodness of their heart, free of charge. Good Luck.

[walid ali]

Thanks for your interest. I will work with all of your recommendations

[catnam]

This link maybe helpful:

https://www.youtube.com/watch?v=wGdw...eshKumarTakyar

and check out the following Thread on this forum:

Unprotect, Execute Code, Reapply Protection for Multiple Sheets

[walid ali]

Thank you