Search results

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

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

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