Discussions
Categories
- 197.2K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
VBA and Smart View add-ins
Hello colleagues,
This is my first post in Oracle community, that's why I would like to say HELLO to all of you.
I need your expertise.
I creating VBS macro in outlook to automate HFM refresh process (take excel attachment refresh and reply). I stuck in the part responsible for load ad-ins in Excel part. Please see below:
Set xlApp = CreateObject("excel.application")
xlApp.Visible = True
xlApp.COMAddIns("Hyperion.CommonAddin").Connect = True
xlApp.Workbooks.Open ("C:\Oracle\SmartView\bin\HsTbar.xla")
Set xlApp = xlApp.Workbooks.Open(link_to_file, UpdateLinks:=False)
Above code create Excel application, run Smartview add-ins and open the specific file. Unfortunately Smart View add-in not load successfully.
Would you mind help me/ give some advise?
Kind Regards,
Luc
Answers
-
I suggest you post in a VBA community
-
its been an issue for a long time, if excel is not already opened and you call a Smart View sheet from an application, Smart View does not load properly.
generally i tell users just to launch excel first (any blank sheet) so that it loads Smart View properly, then the sheet with the Smart View usage.
-
Hello Dan Gagnon,
Not good news from your side.
I tried to run empty excel (used below vb script code), but I have no idea how to co-opereate with this "new" excel file. How to open requested file (I prefer opening the file without links update). Is this possible?
Sub run_excel()CreateObject("WScript.Shell").run "excel.exe /e"Set excelwb = Nothing Set excel = GetObject(, "Excel.Application")End Sub
regards,
Luc
-
This is a VBScript that I use (it works on the current PBCS version, has its own issues though)
'#################################################################################'' Script : ReportExtract.vbs' Author : Celvin Kattookaran - Original Version' Description : To Extract Webforms from PBCS and email them as an Zip file' Date : 4th August 2016' ------------------------------------------------------------------------------' ------------------------------------------------------------------------------' Updates :' Author Date Description''' "1st argument is the location of the base folder"' "2nd argument is the location of the log folder"''' ------------------------------------------------------------------------------' celvin.v.kattookaran 4th August 2016 Creation' '' #################################################################################' ----------------------------------------------------------------------------------------------------------------------' -- Variable declarations --' ----------------------------------------------------------------------------------------------------------------------' Option Explicit Dim arg Dim aArg(2) Dim i i=0For each arg in Wscript.Arguments aArg(i) = arg i = i + 1 NextSet objEXCEL = CreateObject("Excel.Application")' Opens the Reporting Macro WorkbookobjEXCEL.Workbooks.Open aArg(0) & "\Macros\" & Cstr(aArg(2))objEXCEL.visible = true' Run the macro in the workbook' Pass the log file location to the workbookobjEXCEL.Application.Run "Main.Main", Cstr(aArg(0)), Cstr(aArg(1))' Save the workbookobjEXCEL.ActiveWorkbook.SaveobjEXCEL.ActiveWindow.Close' Quit EXCELobjEXCEL.QuitSet objEXCEL = Nothing
You can then call this in a batch file
call %BASE_DIR%\Exes\ReportExtract.vbs %base_dir% %ZBB_LOG_DIR% CreateReports.xlsm
Regards
CK
-
Hello Celvin,
Thanks for the advise.
Would you help with below?
First of all I can't use your code, (due to issue with SmartView tab (it's opening like my first screenshot))
- Set objEXCEL = CreateObject("Excel.Application")
- objEXCEL.Workbooks.Open aArg(0) & "\Macros\" & Cstr(aArg(2))
Is there an option for opening the excel file without links update using batch file? and handling from vbs code?
Have a nice day,
Luc
-
You might have to look at the reg settings, I think somewhere there is a setting to load the com addins at startup.
Regards
CK