unable to load & save a workbook from a VBA function

[Paul VanLeer]

Here's what I have so far

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

please check commands sintax on Help, don't create personal commands

[Paul VanLeer]

still doesn't work .... here's what I have now

Please Login or Register  to view this content.

thanks

[Norie]

Where are you trying to use the function?

If it's on a worksheet then it's not going to work.

[Paul VanLeer]

what do I have to do to use this function in a worksheet in one workbook,
to operate on another workbook ?

[Norie]

Can you just clarify exactly where you are trying to use the function?

Are you trying to use it in a cell?

[patel45]

why do you use a function and not a sub ? try this

Please Login or Register  to view this content.

[Paul VanLeer]

no joy ... here's what I have

Please Login or Register  to view this content.

[Norie]

Paul

Are you going to reveal where you are trying to use this and how it isn't working?

If you are trying to use it in cell on a worksheet it just isn't going to happen.

PS Please use code tags when posting code, kind of a rule.

[Paul VanLeer]

in cell H23 Funds.Fidelity
in cell J23 =LRS(H23)

in cell H24 Funds.Franklin
in cell J24 =LRS(H24)

H columns are either blank or the name of a workbook in the same folder

does this answer your question ?
thanks

[Norie]

You can't use a user defined function on a worksheet to do what you want.

[Paul VanLeer]

ok ... sigh .
then how do I do what I want to do ?

[Paul VanLeer]

is there a way for me to load, save selected workbooks in a folder ?
thanks

[Norie]

Yes, but not with a UDF.

[Paul VanLeer]

if not with a UDF, then what can I use ?

[patel45]

you can use a sub, as I showed you

[arlu1201]

Paul,

Welcome to the forum.

I have added code tags to all your posts. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

[Paul VanLeer]

ok ... now using a button to invoke LRS_List() ... making progress, but still doesn't work
automatic calculations a load time never complete .... see line by line comments

Please Login or Register  to view this content.