I'm trying to use public to declare a variable called 'NewStep' instead of dim. Here's the beginning of my code:
and it's not working
Other sites I've asked this question on:
http://www.utteraccess.com/forums/s...89373&Zd=l&Zn=&Zt=108&Zs=&Zy=#Post1728692&Zp=
http://www.accessforums.net/showthread.php?p=2363#post2363
Code:
Option Compare Database
Option Explicit
Public Function CopyFilesFromR()
Dim strYourDestination As String, strFiles As String, strPath As String, StepTotal As String
Public NewStep As String
Any suggestions?Compile error:
Invalid attribute in Sub or Function
Other sites I've asked this question on:
http://www.utteraccess.com/forums/s...89373&Zd=l&Zn=&Zt=108&Zs=&Zy=#Post1728692&Zp=
http://www.accessforums.net/showthread.php?p=2363#post2363