How do I create a macro using VBA to automatically Lock and Send an entire workbook so that I can upload data into Essbase? I have multiple sheets, but not all consecutive, that I need to load. I already have one for retrieving data, but I am struggling to replicate the process for sending.
Unfortunately, I think the Essbase help is not very intuitive. Thanks for any help you can provide.
-Mark
Unfortunately, I think the Essbase help is not very intuitive. Thanks for any help you can provide.
-Mark