Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Smart View and VBA and submitting data
Summary
Submit data sheet using VBA filled worksheetContent
Helllllloooooooo world
We are using HFM on prem - SmartView 11.1.2.5.810 (Bbd 149)
I built a data input worksheet in Excel 2016 and used VBA to feed about 10 worksheets - click a button and whaaaaalaaa all sheet are filled with exactly the same information! It is a REALLY easy VBA macro [see example below]. Then I can then refresh all the sheets using: sts = HypMenuVRefreshAll() - works like a charm.
BUUUUUTTTT, when I try to submit the data from one of the tabs updated by the macro, it gives me an error "Invalid Cell Type". Here is the code that fills the sheet: