RunCode Macro

[Moxioron]

Hello all.

I am trying to run a module via a Macro and I am having issues with the Function Name. I have never used a Macro to run code so please excuse my ignorance on the subject.

The Function Name I am using is:

Sub ImportKFile()

That is not the name of my module, but I am getting 'Microsoft can't find the name 'Public' you eneted in the expression'

Any assistance would be greatly appreciated. Thank you.

 

[HiTechCoach]

You are correct that you need to create a function is you wan to call it from a Macro.

Unfortunately you have create a Sub not a Function.

It should look something like this:

Public Function ImportKFile()

End Function

 

[Moxioron]

Thank you.

How should the Function Name be reflected in the Macro?

 

[boblarson]

Thank you.

How should the Function Name be reflected in the Macro?

In the run code action's Argument:

FunctionName()

 

[HiTechCoach]

Bob, Thanks for jumping in!

 

[boblarson]

Bob, Thanks for jumping in!

Feel free to do the same, any time.

 

[imfarhan]

Thanks , I was stuck doing similar calling sub chagne to function now its working..
kind regards
Farhan