How do I execute a function in a different workbook of excel

Question

1.00/5 (1 vote)

See more:

Actually I have 2 (allready loaded) Excel-Workbooks.
I want to execute a function (and get it's returning value) in Workbook_1, but the Function belongs to Workbook_2.
The Function itself is working properly but I don't know to access it.
Normally I don't work with Excel-VBS but now I have this problem - with VB.Net I know what I have to do ... but VBS ... :(

What I have tried:

Tried to find something with Google - but no Success ... :(
I hope, anyone can guide me the right way ...

Posted 22-Aug-18 11:00am

Ralf Meier

Updated 27-Aug-18 0:11am

v4

Add a Solution

Comments

gacar 23-Aug-18 18:23pm

You can ask to him. https://www.codeproject.com/script/Membership/View.aspx?mid=4072603

Ralf Meier 28-Aug-18 13:28pm

Your Link to another Codeproject-Member wasn't useful. I know 'ppolymorphe' and if he has an answer to me he would have give it to me.
Do you have downvoted me ? ... and why ?

ZurdoDev 24-Aug-18 8:09am

First google result, excel - How to call function from another specific workbook in VBA? - Stack Overflow[^]

Ralf Meier 27-Aug-18 6:07am

To get a useful Google-Result it's allways necessary to have (or know) the right Keywords ... ;-)
So thanks for your Tip - it wasn't the Solution but it pointed me to the Solution ... :)

ZurdoDev 27-Aug-18 7:52am

True about the keywords, but the keywords I used where the same ones in your title. Just saying.

Ralf Meier 27-Aug-18 14:43pm

Thank you for downvoting my question and also my Solution.
I suppose that you (or I ???) didn't understand the sense of this forum ... would you please be so kind and help me with this question too ...?

ZurdoDev 27-Aug-18 15:15pm

I did not downvote you.

Ralf Meier 28-Aug-18 13:27pm

I'm sorry for compromising you ... I had a look at your reputation-points and if you have had downvoted me the negative points for me must be much greater.
So ... perhaps it was 'gacar' - but I don't know the reason. But of course : his comment which links to another Codeproject-Member wasn't useful ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ralf Meier · Accepted Answer · 2018-08-27T00:12:00

By the Tip of "011111100010‬" I found this as my Solution :

VB

Sub test()

arg1 = 9
arg2 = 6

arg3 = Application.Run("'Test-Mappe2.xlsm'!Modul1.Add", arg1, arg2)

End Sub

For testing I wrote a Function called Add which is placed in Modul1 inside my 2nd Workbook (Test-Mappe2.xlsm).
This Function has to add both Arguments and deliver it's Sum back.
The Method Test is placed in my 1st Workbook (Test-Mappe1.xlsm).