Good Afternoon Everyone,
I am moving a Subroutine from a form's VBA code to a Public Module. I made a simple change by adding an extra parameter to make it more universal. The original sub definition and call were:
Private Sub Process_XL_Macro(ProcType As Integer)
with call
Process_XL_Macro(Rename_FieldNames)
Rename_FieldNames is defined as a constant
After moving to the Public Module the definition is:
Public Sub Process_XL_Macro(Fname as string, ProcType As Integer)
will call
Process_XL_Macro (fName, Rename_FieldNames)
fName is the Path\Filename string
When adding the call to code, I get "Expecting =" error. Any suggestions of the cause. Remove the Fname parameter appears to work fine. Using Access 2010 on Windows 7.
Rod
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar