Search results

  1. C

    Need Help passing a variable from a form action to a module

    Worked like a charm! Thanks I spent several hours on a 3 minute fix!!!:o
  2. C

    Need Help passing a variable from a form action to a module

    OK I replaced the line in the module with Public Function ProcessFileImport(ByVal sFile As String, ByVal sTable As String, ByVal intStartRow As Integer) As String How do I pass the number of rows back from the command button I tried inStartRow = 1 I get a variable not defined error. I...
  3. C

    Need Help passing a variable from a form action to a module

    I guess I don't understand the public variable piece. I don't care how I set the variable 'intstartrow' the easier the better. It will be either 1 2 or 3 depending on which spreadsheet is being imported. since each spreadsheet has its own import button I think this is the place to set it but I...
  4. C

    Need Help passing a variable from a form action to a module

    I am trying to pass a variable 'headrows' from the on event action from a form to a public module that imports spreadsheeet data from excel. This number changes depending on which spreadsheet is being imported so there is a seperate inport button for each type of spreadsheet. Here is the...
Back
Top Bottom