Share via

Creating a Macro to Upload to Oracle

Anonymous
2017-12-22T15:38:03+00:00

Hello,

I work in corporate finance and as a result I do a lot of journal uploads. I was wondering if there is a way to create a Macro that would allow me to automatically upload into Oracle. I have tried to figure this out on my own, but I have been unsuccessful in my attempts.

The upload button on Oracle is found in the ribbon, so I'm not sure if there is a way to create a Macro to do this.

Any help would be appreciated and a screenshot for reference can be found below.

Thank you,

Thomas

Moved from: Office/Excel/Windows other/Office 2016

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-12-22T15:41:20+00:00

    That Oracle tab on the ribbon is a custom Add-in created by Oracle for Excel.

    You could record a macro of you going through the steps of doing an upload and then run the macro to test if that would work.

    Here are instructions on how to record a macro:

    https://support.office.com/en-us/article/Automa...

    0 comments
  2. Anonymous
    2017-12-22T16:38:42+00:00

    Thank you for the reply Jason. I recorded the Macro and the upload was not picked up. Please see the VBA code below.

    Sub Automatic_Upload()

        Range("E9").FormulaR1C1 = "=EOMONTH(TODAY(),0)"

        Range("B20").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B21").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B22").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B24").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B25").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B26").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B27").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B28").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B29").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B31").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B32").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B33").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B34").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B35").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B36").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B37").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B38").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B39").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B40").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B41").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B42").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B43").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B44").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B45").Select

        ActiveCell.FormulaR1C1 = " "

        Range("B46").Select

    End Sub

    0 comments
  3. Anonymous
    2017-12-22T19:56:25+00:00

    It looks like that since it was an add-in its not being recorded in the macro. Is there documentation from Oracle about their add-in?

    0 comments
  4. Anonymous
    2017-12-26T17:06:46+00:00

    I am not seeing any type of documentation. The files are Web ADI templates that can be uploaded straight to Oracle. I'm not sure if this helps, but unfortunately that is all I can find.

    The Oracle add-in only pops up when you enable macros too.

    0 comments