Thread: [Solved] Updating tables in Word
View Single Post
 
Old 04-11-2025, 11:32 AM
Italophile Italophile is offline Windows 11 Office 2021
Expert
 
Join Date: Mar 2022
Posts: 554
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

There is a compile error in the code you have posted for Function WorkbookIsOpen.
Code:
Set wb = xlApp.Workbooks(filePath) ' Try to get the workbook
the variable xlApp does not exist in this scope.

In your new variable declarations
Code:
Dim chartObj As Excel.chartObject
should be

Code:
Dim chartObj As Excel.Chart
Reply With Quote