You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
17
Views
0
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics

Summary

Submit data sheet using VBA filled worksheet

Content

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!