Version of Windows?

[Bob Valentine]

Group:

I need to determine the user's version of Windows. What is the VBA code to
do this?


I also need to know if a folder exists. What is the VBA code to do this?

Thanks,
BobV

 

[Cheryl Fischer]

Hello Bob,

I need to determine the user's version of Windows. What is the VBA code to
do this?

There is code at the following link which should do that for you:

http://www.mvps.org/access/api/api0055.htm

I also need to know if a folder exists. What is the VBA code to do this?

Using the Dir() function with its "vbDirectory" argument should do that for
you:

If Len(Trim(Dir("C:\MyFolder", vbDirectory))) = 0 Then
'do something
End If

hth,

 

[Bob Valentine]

Cheryl:

Thank you for the information. This is what I was looking for. I really
appreciate the time you spent responding to my question.

BobV

 

[Cheryl Fischer]

You're welcome. Good luck with your project.