Universal VBA code

[omriar]

Hi, I'm working on a project, in it I made a workbook with codes in sheets, modules and I made userforms.

The code is supposed to process data from an analytic instrument that gives me everytime a different excel file, therefore every time I need to use this code on a different excel workbooks.

I tried to use the code while the workbook that I wrote it on is opened and everything works fine. The problem is I want the code to be available without opening that original workbook.

I would be very happy if someone will help me to solve this problem.

 

[julhs]

I may be out of my depth on this, but prepared to give it a shot!!!

Try putting it in "Personal xlsb"

My understanding is;
If ALL Workbooks you open could use it and the "Source Book" is closed, then try putting it in "Personal xlsb"

If it’s only for the the ONE Workbook, and its open then put it IN a “Module” within that Workbook.

If it’s only wanted on that particular Sheet put the code on the “Sheet”

 

[omriar]

I may be out of my depth on this, but prepared to give it a shot!!!

Try putting it in "Personal xlsb"

My understanding is;
If ALL Workbooks you open could use it and the "Source Book" is closed, then try putting it in "Personal xlsb"

If it’s only for the the ONE Workbook, and its open then put it IN a “Module” within that Workbook.

If it’s only wanted on that particular Sheet put the code on the “Sheet”

Out of your depth? I never got an answer so quick that actually worked in less than 10 minutes to implement!
Thank you, I thought it's gonna be a nightmare!

 

[julhs]

My pleasure, thanks for the feedback