Search results

  1. J

    If statement

    Helo Quick question like to know if if this possible I put together this little bit of code. This count all the filed in folder then sent a email, Would like to know if there a way to sent out a different message depend on if the is any file. It not work any though possible Dim file1...
  2. J

    Exporting to excel

    Hello Your funtion work great except it will not close still getting run-time error 424 object required Thanks
  3. J

    Exporting to excel

    Hello Thanks for your help I got it work. Just trying to figure out run-time error 424 object required Thanks Jonathan
  4. J

    Exporting to excel

    Hello I have create a form and then create a button then copy this code into on event section Public Function SendTQ2XLWbSheet(strTQName As String, strSheetName As String, strFilePath As String) SendTQ2XLWbSheet "2", "Pop", "C:\Documents and Settings\PerniceJ\Desktop\12115\JOn\Jon.xls"...
  5. J

    Exporting to excel

    Hello I am very new at this. Thank you for your time Private Sub Command0_Click() Eval (SendTQ2XLWbSheet) End Sub
  6. J

    Exporting to excel

    Hello Thanks. Two question First I get a errot that say "Subscript out of range" Second I how do I set it to add different table to this sheet Thanks again
  7. J

    Exporting to excel

    I would like export the result all the same worksheet.weekly
  8. J

    Exporting to excel

    Hello Every week I receive new excel file that I upload into access. Then export back into excel into same Workbook and worksheet every week. Is there a export different weeks in the same worksheets? For example Weeks dollars Thanks
Back
Top Bottom