S
Steven Taylor
I am trying to change the data source of my pivot table.
The code that I normally use is:
ActiveCell.PivotTable.PivotCache.Connection
= "ODBC;DSN=GENERAL LEDGER;"
However I keep getting the follwoing message:
Run-time error '1004':
Application-defined or object-defined error
Does anybody have any suggestions as to my this might be
happening? TIA.
Steven
The code that I normally use is:
ActiveCell.PivotTable.PivotCache.Connection
= "ODBC;DSN=GENERAL LEDGER;"
However I keep getting the follwoing message:
Run-time error '1004':
Application-defined or object-defined error
Does anybody have any suggestions as to my this might be
happening? TIA.
Steven