by MollyMoo » Mon Apr 29, 2019 1:55 pm
I'm trying to log the Quick Pick List on to an Excel worksheet. I'm expecting the BA Quick Pick List to be copied to the relevant sheet when BA is connected to the workbook. Is this correct?
If so, the documentation says:
"So for example if you are logging the current market prices to Sheet1 and want to export the Quick Pick List then you need to name a separate sheet Sheet1_QuickPickList and tick the option."
So I created a worksheet in my Excel workbook and ticked the logging option in the Excel options and connected BA to my (unopened) workbook. Nothing is displayed on the logging worksheet.
I'm logging the current market to a worksheet called "Gruss", which is logical Sheet1. I've tried naming the QP logging worksheet "Sheet1_QuickPickList", "Gruss_QuickPickList" and just "QuickPickList", but still nothing is displayed when the workbook is connected to BA. What am I doing wrong?