Combine Two Dissimilar LO Calc Workbooks With Macros

[BossMan]

Hello @ LibreOffice Forum

I have two dissimilar Workbooks in .ods format with Macros which I wish to combine so that the functionality of the Macros is NOT impaired. The two workbooks are as follows:-

1. A shares and fund prices downloader for prices from FT.com and Yahoo.com & Shares.com. It contains Macros and five Sheets This is not my creation but comes from Lemon Fool.

2. A Portfolio management Workbook to record our (Wife and Self) NetWorth of shares and funds on a weekly basis. It contains Macros and 54 Sheets This is my creation.

I have successfully MOVED the Sheets from (2) into (1) but because of the number of sheets and other factors it takes a very long time. So if the Price Updater changes version it becomes seriously problematic. Generally speaking the Macros work so I can update Prices.

I have recently tried the reverse, that is to MOVE (1) into (2), that is, the 5 Sheets of the Price updater into the Workbook containing 54 sheets but I received a Python Error Message when I pressed the button to update the prices in the combined Workbook.

Could anyone suggest any solutions that might address the issues raised here. Macros I know very little about.

Thanks

Boss

[Villeroy]

Merge sheets of spreadsheet documents

[BossMan]

Hi Villeroy

I am in your debt yet again. Thank you. It will take some time to read the notes and “play about” with it, but I will let you know if it works for the benefit of others.

Boss