If / Instr command to change variable

[danboy122]

Hi,

I'm very much a newbie to VBA, i am in the middle of writing up something at the minute that is just pulling off data from AD and has the option to check the users filestore / profile size.

Everything is working ok so far, just that when checking on the profile size its reporting back it hasn't be found even though the user does have one.

Our domain used to us an Enviroment Variable that set the users profile to *%ProfilePathExtension%

* represents the users unique ID

The profile path is now *.STRIDE

I need something within the code that converts the "*%ProfilePathExtension%" to "*.STRIDE"

If anyone can offer any help, as i have seen Instr stuff on the web and dont know if this would be the route to take.

Regards,
Dan

[Bob Phillips]

Do you mean

[vba]

myPPE = Environ("ProfilePathExtension")[/vba]