Business Intelligence

Get Involved. Join the Conversation.

Topic

    Kim Hall
    Smart View and VBA and submitting data
    Topic posted June 24, 2019 by Kim HallGreen Ribbon: 100+ Points, tagged Business Intelligence 
    21 Views
    Title:
    Smart View and VBA and submitting data
    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: