I have this visual basic code that opens an excell workbook generated by a database.
This workbook have always same amount of columns but different amount of lines.
The pivot table is to be created programatically
So my code opens the workbook but it selects a fixed range.
HOw can I make it select the correct range programatically?