User Defined Function giving me "expected: =" error

Hey everyone,

Another most likely simple solution that I cannot find the answer to after hours of searching. I've created a function that takes two strings and parses them into a textfile path. The code looks like this:

Please Login or Register  to view this content.

At first, I was just putting the whole path as a string into the CreateTextFilePath function, i.e. it was only taking one argument which was the entire path. That worked, no errors. But I wanted to add two arguments, one as the folder, one as the file. But now that I've added two arguments, I keep getting the "expected: =" error on the line that calls CreateTextFilePath. I have no idea what to change because my code is so simple. I figured that adding one additional argument wouldn't require an equals sign or some type of assignment to a variable.

Anyone have any ideas? Thanks!

-Hugh

Please Login or Register  to view this content.

Oh yea, I realize that now! I deleted the "Set"... I'm still getting the error however. Also, what is it that is confusing you? I am just trying to take the folder path, a string of my choosing to represent a file name (in this case "Something") and then have the function convert it into a string that is the path of a text file named "Something.txt." Make sense?

Also, I changed the variable names because I realize they were stupid and unnecessarily sarcastic. Maybe now it makes sense.

Hey shg, your response worked! I just removed the parentheses. Of course it's that simple... guess I'm treating VBA functions like, you know, every other programming language that has parenthetical functions!!!