VBA To Log To External File - Cell Value Dependent

I have a file that pings some data to an external file. Everything works great. I'd like to expand on it, if possible, though. This file will be given to 6 different groups of people. Each person will have to select their group from a drop down box. Depending on which group they are in, I need a different external file to be chosen. I don't know if a variable can be added to the current code to add in those different group choices or not. I'm curious if someone might can take a look at it and see if it can be altered to accommodate what I'm trying to achieve?

The attached example file will explain everything clearly.

So obviously it can't be a constant anymore but a String variable …

LogFileName = "P:\Engineering\Engineering Tool Logs\" & [B7] & ".txt"

So that’s all I would change?

Originally Posted by Marc L

So obviously it can't be a constant anymore but a String variable …

LogFileName = "P:\Engineering\Engineering Tool Logs\" & [B7] & ".txt"

Ok... after I read this, it makes sense what you are saying now but I'm having an issue getting it to work. My actual file contains more sheets and the variable is located on a sheet in the background so I need the LogFileName to point to B7 in that sheet, not the active sheet. I've tried different variations of your suggestion but can't seem to get it to work.

Please Login or Register  to view this content.

Can you tell me where I'm messing up in the path there?

Please Login or Register  to view this content.

To add: I'm getting the Compile Error: Constant Expression Required and it's highlighting .Range

Remove [ and ]

Originally Posted by Gtrtim112

Please Login or Register  to view this content.

Can you tell me where I'm messing up in the path there?

LogFileName = "P:\Engineering\Engineering Tool Logs\" & Sheets("Variables").[B7] & ".txt" …

Quote Originally Posted by Marc L View Post
LogFileName = "P:\Engineering\Engineering Tool Logs\" & Sheets("Variables").[B7] & ".txt" …

I'm still getting the same error. Now, though, it's highlighting ".B7"

Please Login or Register  to view this content.

Originally Posted by Gtrtim112

Quote Originally Posted by Marc L View Post
LogFileName = "P:\Engineering\Engineering Tool Logs\" & Sheets("Variables").[B7] & ".txt" …

I'm still getting the same error. Now, though, it's highlighting ".B7"

Please Login or Register  to view this content.

It is also highlighting the very first line:

Please Login or Register  to view this content.

As I yet wrote in post #2 so again « it can't be a constant anymore but a String variable » ! So just compare my post #8 and your post #9 …

Originally Posted by Marc L

As I yet wrote in post #2 so again « it can't be a constant anymore but a String variable » ! So just compare my post #8 and your post #9 …

Marc, I get what you are saying but I don’t know how to change it.

Originally Posted by Gtrtim112

Marc, I get what you are saying but I don’t know how to change it.

Do I just take out the “Const”?

As the codeline was yet written twice in posts #2 & 8 without 'Const' …

Found the answer I was looking for...

Thanks to all that tried to help me and sorry if I didn't understand the answers given to me. I'm not good with code. I know how to put it in if it's spelled out for me but I can't interpret most of it.

This is the code that worked for me (with slight modification on the path):

Please Login or Register  to view this content.

Originally Posted by Marc L

As the codeline was yet written twice in posts #2 & 8 without 'Const' …

As info... Excel would not accept it without "Const" in it. The whole line highlighted in red when I did that.

Originally Posted by Gtrtim112

As info... Excel would not accept it without "Const" in it. The whole line highlighted in red when I did that.

Photo of error attached

Your bad again ! As your codeline is very not mine, compare them ‼ That's just about to well read, nothing else …

As a reminder, in VBA the declaration of any variable must be in a Dim codeline like you can see in your code or in VBA help.

Originally Posted by Marc L

Your bad again ! As your codeline is very not mine, compare them ‼ That's just about to well read, nothing else …

As a reminder, in VBA the declaration of any variable must be in a Dim codeline like you can see in your code or in VBA help.

Marc,

I'm not sure what I've done to make you angry at my questions but rest assured that you should not feel the need to answer me ever again. I came here for help and I've been using this forum for about 6 years without the first issue. Not everyone knows code like you, nor can we interpret what you post as easily as you think. You take for granted that you know VBA while others are still learning. You definitely do not have a future in training as you would not have the patience with people such as myself. So, thank you for making feel like I should not have came here for assistance in the first place but I will continue using this forum as a source for help as everyone else that has helped me in the past, have done so without the condescending attitude that you've presented towards me.
I would just like to note also, that I made sure to leave you positive reputation for your meager attempt to help me because it's the right thing to do and you definitely seem to need some positivity in your life.

Good day