Recent content by Jpernice

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...

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

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

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"...

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

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

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

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