Hi Folks,

Short summary of my problem: Is there a way to have a macro check who is logged in on a computer and store that information?

Explanation why I need this:

For our main customer, we send invoices once a month and currently, we use a macro which copies the relevant information to a new spreadsheet, sorts it by department (because each department has to pay it's own bills...what a surprise) and automatically saves that spreadsheet as mm-yyyy.xlsx (e.g. 09-2015.xlsx).
However, our secretary then still has to copy the data per department to a Word file, which she then sends to our financial dept., who turn it into an official invoice. Since we usually have quite a large number of invoices per month, making the Word files can sometimes take half a day or more and that's a bit of a waste of time.

We now, finally, have 'permission' from our financial dept. to send pdf's instead of Word files and of course, making a pdf from Excel can easily be incorporated in the macro.
But here comes the problem: We work with a very strict quality control system and need some way to verify who did what. I was first thinking about making some kind of popup window in the macro in which the person running the macro needs to fill in his/her initials before the macro continues. And to have the macro include those initials in the name of the excelsheet when it's saved.

But as our QA manager pointed out: I can just as easily fill in somebody else's initials. Of course, we expect people not to do that, but the board of accreditation will probably see that differently (they usually do).

So what we were thinking now is to have the macro check who is logged in on the computer on which the macro is run and include those data in the spreadsheet, either in a set place on one of the sheets or, preferably, in the file-name.
And of course, we know that it is still possible to run the macro on a computer on which somebody else is logged in but hey....we can't cover everything.

Hope you can help me.

Cheers,
Thirsa