Recent content by certifydgangsta

Thanks namliam. Do you have any references that you recommend for learning more about exporting from access into an excel template?

Thanks for the quick help Mile-O. I'm currently formatting the data from Access, but it is taking too long and there are users waiting to use the files. I was hoping that doing the formatting once the user opens the workbook would spread the time taken to format across multiple workbooks and...

I have some code that exports two hundred workbooks using various queries. I'm trying to add code to each workbook so that when the workbook opens it formats the data. I have all the formatting code complete, it is the access VBA code that adds VBA into each workbook that I cannot figure out...

When in doubt just throw 'ws.' or 'wk.' in front of anything and it will work!

I finally got the code to work! I'm posting the code just in case anyone else runs into a similar problem. Dim xl As New Excel.Application Dim wf As Excel.WorksheetFunction Dim wk As Excel.Workbook Dim ws As Excel.Worksheet Dim strPath As String Dim j As Long...

Thanks namliam, that helped me fix the code in my other post!

I've done some googling, but haven't had much luck finding an in-depth guide on manipulating excel workbooks using MS Access VBA. Does anyone have any recommendations? Thanks for any input!

I'm receiving a "run-time error '1004': method 'Cells' of object '_global' failed" error on the line of code that starts with, "If wf.CountA". Interestingly, in your code, the 'Range' object isn't causing the problem anymore, while, before you cleaned up my code, the 'Range' object gave an error...

I am trying to delete every column in sheet1 that has no data in row 2 to the last row. There are headers in row 1.

I guess my difficulty is figuring out what is considered a variable that needs declaration compared to code that doesn't need declaration. I thought Range, like CountA, doesn't require a declaration. I declared the Range variable and added a worksheet variable (ws) to prevent the same error...

Thanks for helping me out lagbolt. With your help, I tweaked the code around and can now successfully run the code on the first try, but when I run the code a second time I receive the error "run-time error '1004': method 'range' of object '_global' failed". The run time error falls on the "For...

I receive the error "Run-time error '1004': Application-defined or object-defined error" on the line of code that starts with 'If Execel.Application'...

The part of the code that I am struggling with is trying to loop through each column of sheet1 to detect if rows 2 through the last row have no data in them.

I thought it was easier to show the excel vba code above, but this is the code that I have so far for access vba. Dim CurrentFolder As String Dim CurrentCycle As String Dim ApXL As Object Dim xlWBk As Object Dim xlWSh As Object Dim strPath As String Dim ws As Excel.worksheet Dim j As Integer...

I am trying to use this code in MS Access and am referencing an external excel worksheet. Thank you in advance for any help that you may provide.