![]() (this will just ignore the code lines with an error)Īnd at the end of the code, put something like But if you want to have more control of the errors, i'd recomend you to use The first code you posted was made with the macro recorder, so there's always a way to make it simpler. I tried adding a resume function in for the error handler.and that was a nighmare I don't wish to repeat.Īnyway.if you have any suggestions.I'd really appreciate it. (so far the 2 reports I set up like this w/out the error handler part - don't always run, but I am not entirely convinced that it is the report - i am thinking it has something to do with the server timing out - and the original way - does make it so you refresh one data source at a time - but there is still no error handling - so it crashes too) Instead of the way it is - but I could be wrong. I think that we should be able to use something simpler like this: BackgroundQuery:=FalseĪctiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |