macro calling from personalwb.xlsb - what was the previous workbook?

[giani1984]

HI!
I have written a macro what need to use my colleges during their works.
They get 200 excels a day, and they have to use to make contracts...
This workbooks are wrong. My colleges have to change the x character to y in some cells...
My plan is that:
I save my macro to their computers, to their excels personalworkbook.xlsb, and I take an little icon to their excels quick access toolbar...

My problem:
My college open one source excel of the 200... He start running my macro. My macro start in his personalwb.xlsb... But, my macro don't know, which excel does he calling from???

Could somebody to help, how can i reference the previous workbook in my macro, what hasn't run in the source, previous excels?

Thenk you!
John

[p24leclerc]

In your macro in Personnal.xlsb, you can use ActiveWorkbook.Name to know which workbook called the macro.
ActiveSheet would refer to the active sheet where Excel was when the macro was called.
It should be as simple as that.