View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron Michel Pierron is offline
external usenet poster
 
Posts: 214
Default Creating Subdirectory in "Default User" App Data

Hi NickHK,
Yes, you are right, but sometimes, I am a little lazy.
:-) MP


"NickHK" a écrit dans le message de news:
...
As I was reminded the other, you should not use the numerals for the
Environ
variables as the can return different values between computers.
Environ("APPDATA") will always be the same.

NickHK

"Michel Pierron" wrote in message
...
Hi pagates,
MkDir Environ(2) & "\Our Company"

MP

"pagates" a écrit dans le message de
news:
...
Hello All,

We have an Excel Add-In that creates an INI file in a subfolder under

the
Application Data section of the current user ("C:\Documents and
Settings\CURRENTUSER\Application Data\Our Company\Our
Product\OurOptions.INI"). If the Add-In is used in a background

process,
it
attempts to create the folders under the Default User (usually
"C:\Documents
and Settings\Default User\Application Data"). The problem is, it

doesn't
have permission to do so, and hangs the process. However, if the "Our
Company" folder exists, it does have permission and creates the "Our
Product"
folder with no problem.

Does anybody know of a way to create the "Our Company" folder
automatically
under the Default User's Application Data path?

Thanks,
PAGates