Rod-
If you change the procedure parameter list, then you have to change all the
calls to the procedure. Looks like you need to add a string variable before
the ProcType.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
Sent: Sunday, July 21, 2013 10:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Error after moving Sub to Public Module - help
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
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar