Search results

Hi, I have the following piece of code for importing the .csv files from a selected folder and then renaming them into 'imported & filename' if succesful and 'failed & filename' if import failes for whatever reason (bad formating, etc.). The problem is that the first time it encounters a 'bad'...

I figured it out eventually. This does the trick: For intFile = 1 To UBound(strFileList) filename = path & strFileList(intFile) Workbooks.Open (filename) Dim wsCount As Integer Dim sheet As Worksheet For Each sheet In ActiveWorkbook.Worksheets wsCount =...

Thank you for the answer. Here's what I did do far: Dim WS_Count As Integer WS_Count = ActiveWorkbook.Worksheets.Count Dim x As Integer Dim strSheet As String On Error GoTo Handler For x = 1 To WS_Count Do...things But I...

Hi my friends, I need a little help with some code I've come up to in order to import multiple excel files each of them with a different number of worksheets into an access table. The procedure is called from an Access database. The problem I have with the code is that when it encounters a...

No, I don't think that's the problem. I must have misspelled the table name when I translated it from my language into English. However, somebody came with the suggestion that there are 2 INNER JOIN clauses, and the clause should be: Format([Transactions].[Transaction_date],"MM-YYYY")...

No, I don't think that's the problem. I must have misspelled the table name when I translated it from my language into English. However, somebody came with the suggestion that there are 2 INNER JOIN clauses, and the clause should be: Format([Transactions].[Transaction_date],"MM-YYYY")...

Ok, I tried it, still gives the same error message: Syntax error (missing operator) in query expression: 'Format([Transactions].[Transaction_date],"mm-yyyy") INNER JOIN TCounts.MonthYear'

Hello everyone, I have the table 'Transactions' containing all the transactions in an year. The columns of the table are: Transaction_date Type Value Payer_Id Status What I would like to do is a query to group up all the transactions by month, then count the transactions corresponding to each...