I'm wondering if I can do some editing to an excel file either during one of my docmd modules or if this is something I have to do afterwards.
- Runs query and outputs to excel (xlsx) with a specific file naming convention "AccountNumber_AccountName_Month_Year".
- In terms of scope, I'm creating over 200 unique reports by account number
- As an FYI, when checking the file after Module 1, the scroll bar is not covering any tabs
Where I need Help
- Runs query and adds a new tab called "Details" to the excel file created in Module one based on that specific account number
Upon completion, I get the first attached image 'Scoll Bar before' jgp which covers the Details tab.
Is there anyway to get the file to move the scroll bar so that it's not covering up the 2nd tab. This will avoid the question of, 'Where's the details?' which I have to respond by telling them to move the bar over to the right as in the 'Scroll Bar After' jpg