UserName Variable

Hello,

I'm trying to make a template file that will save to the correct pathway when either my co-workers or I use it. Right now, I'm declaring the variable in the main module with the following code.

Please Login or Register  to view this content.

Then calling the variable in about 4 other modules like this.

Please Login or Register  to view this content.

When I try to run the code, I'm getting a compile error. The error says Expected variable or procedure, not module.

First thought is try making it a string, not a variant. However, would like to see the whole code together with what line it errors on.

making it into a string didn't work. The main code errors out the first time I call the variable. Here is a little bit more of the code until it errors out when I call SAP

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by xlnitwit

Hi,

Did you change the name of your module to XqsId (or Path)?

Nope. Is that necessary?

Originally Posted by xlnitwit

This code line

Please Login or Register  to view this content.

should be at the top of your code module, before any sub routines and should look like this

Please Login or Register  to view this content.

The error message you are getting would imply that your variable name is the same as the name of one of your modules.

Ok this worked. It turns out I had two errors, I named some modules the same name as their Sub. Also I needed to declare the variable as Public.

The method you're using won't work for everyone. You're making the assumption that everyone's desktop is in the same path, that isn't the case - something like the below is more reliable:

Please Login or Register  to view this content.

Originally Posted by Kyle123

The method you're using won't work for everyone. You're making the assumption that everyone's desktop is in the same path, that isn't the case - something like the below is more reliable:

Please Login or Register  to view this content.

This is a little advanced for me. Does the code you provided just replace the Path of the Shell command? or does it replace the whole shell command?

It's the same as you already have:

Please Login or Register  to view this content.

Originally Posted by Kyle123

It's the same as you already have:

Please Login or Register  to view this content.

The code you provided doesn't work. It says the control could not be found by id. Let me know if you know what the problem is, but for now I'm going to stick to the old code that was working. I'll update this forum after I test the macro on another computer.

Are you running this in SAP or Excel? - That's a SAP error message, not an Excel one