Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Smart View and VBA and submitting data

Question
104
Views
0
Comments
Rank 1 - Community Starter

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:

'Sheets("HFM Data Load").Select
Sheets("HFM Data Load").Range("B3:C3").Value = Sheets("data input").Range("F14")
Sheets("HFM Data Load").Range("B2:C2").Value = Sheets("data input").Range("E15")
 

If I manually change the numbers (with NO other edits) the submit works.  I have check the cell type on the source tab and they are numeric. . .

What gives????

THANK you for your help!

 

 

 

 

 

 

 

 

Version

SmartView 11.1.2.5.810 (Bbd 149)

Code Snippet

'Sheets("HFM Data Load").Select
Sheets("HFM Data Load").Range("B3:C3").Value = Sheets("data input").Range("F14")
Sheets("HFM Data Load").Range("B2:C2").Value = Sheets("data input").Range("E15")
Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.