Recent content by Boromyr

Hi Vlad. I used your "add", but it doesn't solved problem. I tried to record a macro in excel, and I decided to try without the variable "NuovaCache". Old Code: Set NuovaCache = ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, _ SourceData:=percorso &...

It's very similar to my code...maybe I used a version of this to make my 😅

Hi all. I created a database that run queries and extracts an excel's file. This code use the generated file, count the lines, copies all data to an existing file that has a pivot table. After the copy, the code should update the pivot cache. It worked for a couple of weeks, but now, gives the...

Making this in the excel files, doesn't solved the problem. But, recording a macro, I put the same thing in the VBA code after the refresh, and it works!!! Thank you very much (y)

Already tried. I tried also ".Update" and "ActiveWorkbook.RefreshAll" but the result is the same :(

Yes. Thank you

Hello! I have a problem with an autorefresh of a pivot table. With this code, I refresh the origin of a pivot table to eliminate the "empty" field from filters. It works partially: the origin changes, filters are clean, pivot table is refreshed...but...when I go to work on filter, excel says...

I try to make the same with the same file in old version ofcDB: Print DBEngine(0)(0).TableDefs("Fatture_Scadute").Connect Text;DSN=Fatture_Scadute - specifica di collegamento;FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=850;ACCDB=YES;DATABASE=C:\Nuovo QC_DT\Input With tdf.Connect =...

@Isaac Here the image with your code of post #5 Sorry I did not see it 😅 Before I decide to write here, I looked for a solution on web for 4 days, with no result, but I think that possibilities are 2: 1) an error in the Text property of tdf.Connect in this part...

"Percorso" is "Path" in italian. I don't have much fantasy 😅

Yeah, the project has 3 directory, "utilità" (utility in italian) that contain service files for DB, Input that contain files users will update and Output where the DB works in rest of code.

Yes....

Sorry guys. I tried to translate from italian to make it easy, but it wasn't a good idea... This is the complete code, the error, the debug, the paths and the result on linked table, that work for the .xlsx file but not for the .csv Private Sub TastoSI_Click() 'On Error GoTo ErrAggTab...

Thx for the welcome :) In example i poste only 2 xlsx and 1 csv to show VB code, but the error is not on the file named with space, first & second are .xlsx and works. The problem is in the third. In the origibal DB there are 5 .xlsx that workk perfectly, and 5 .csv that cause all the same...

Hi. I'm trying to automate the updating of linked tables in a database in case of moving the main DB. For the .xlsx files, the code works. For the .csv files, the code give me error "3044 - 'C:\correctpath\Invoice_New.csv' is not a valid path. Make sure that the path name is spelled correctly...