I'm trying to use public to declare a variable called 'NewStep' instead of dim. Here's the beginning of my code:
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
and it's not working
Compile error:
Invalid attribute in Sub or Function
Any suggestions?
Other sites I've asked this question on:
http://www.utteraccess.com/forums/sh...ost1728692&Zp=
http://www.access-programmers.co.uk/...304#post764304