VBA to transfer data from one workbook to another

[Robert_Conklin]

With the help of others, I have created a workbook for our end users that allows them to submit spare part maintenance requests. The problem lies in the fact that we have 48 different locations that will be submitting these requests. Is it possible to create a command button that will only work for specified Windows user names, that when clicked will copy all of the data from the workbook to another workbook on a shared drive? In order to satisfy our internal audit we have to be able to track all of the changes, and having one location to look would take care of that.

 

[Robert_Conklin]

Done. Received the same error message. I wish I could post attachments!!

 

[Robert_Conklin]

Wait...does this code need to be created as a module or a pasted into my form code?

 

[MrKowz]

If you want, upload them to a file sharing service such as dropbox and post the link. I can try to take a look at them tonight when I'm not on a work computer.

 

[MrKowz]

Wait...does this code need to be created as a module or a pasted into my form code?

In a module

 

[Robert_Conklin]

Ok, that is where I put it. Do you have somewhere I can send these files so you can see what I am looking at?

 

[MrKowz]

Ok, that is where I put it. Do you have somewhere I can send these files so you can see what I am looking at?

See my above post about Dropbox.

 

[Robert_Conklin]

https://www.dropbox.com/sh/qq5rbvwjcxn33st/AAD7As1ngvi3pi6jH2sjGF0ha?dl=0. Hopefully you can see them with the link. I am headed home for the evening. Thanks for your help.

 

[Robert_Conklin]

Were you able to get to the files from the dropbox link?

 

[MrKowz]

Sorry, I didn't have a chance last night to take a look. You're still on my radar, though.

 

[Robert_Conklin]

No problem, thank you for your help.