compiler error

[Cor van der Bliek]

Why is this code in my module wrong?
Public Persfile As String
Public Sub AutoNew()
Set Persfile = "C:\"
UserForm.Show
End Sub

I simply want to declare a stringvariable for all my procedures.
Thanks.

 

[Dave Lett]

Hi,

I could be way off on this, but I think it has to do with using the Set
statement, so you could try simply removing that word.

Public Persfile As String
Public Sub AutoNew()
Persfile = "C:\"
UserForm.Show
End Sub

I _think_ it has to do with the Set statement, which you use to assign an
object reference, but a String is not an object.

HTH,
Dave

 

[Andi Mayer]

Why is this code in my module wrong?
Public Persfile As String
Public Sub AutoNew()
Set Persfile = "C:\"
UserForm.Show
End Sub

I simply want to declare a stringvariable for all my procedures.
Thanks.

PersFile is no Object, it's string

objects use Set, with other variables you leave the set out

 

[Cor van der Bliek]

This does the trick. Thanks for reminding.

PersFile is no Object, it's string

objects use Set, with other variables you leave the set out