Smart View - Connect to a Shared Database

ekrom8

New Member
Joined
Mar 12, 2018
Messages
3
[FONT=&quot]Hello,

I am fairly new to Oracle Smart View and have been recently assigned to debug an issue with establishing a connection to our National Sales connection. Establishing a connection requires logging in with a username and password.

How do I properly establish a connection to National Sales and Zoom In on "All Customers" (Manual Input). My code so far is:

Microsoft Excel Objects
This Workbook:

'Opens form to access workbook
Private Sub Workbook_Open()
U_login.Show
End Sub

Forms
U_login

Private Sub CommandButton1_Click()
U_ID = UID.Value
PASS_W = PASS_WORD.Value
Beep
U_login.Hide

End Sub

Module3

'Deletes previous customer list and adds new based on segment selection
Sheets("Customer List").Select
range("I1").Select
ActiveCell.FormulaR1C1 = "=Location"
range("H1").Select
ActiveCell.FormulaR1C1 = "=Segment"
Columns("A:A").Select
selection.ClearContents
range("A3").Select
ActiveCell.FormulaR1C1 = "All Customers"
range("A3").Select

x = HypInvalidateSSO()
x = HypConnect(Empty, U_ID, PASS_W, "Sales-NationalSales")
x = HypSetConnAliasTable(Empty, "Default")
x = HypSetOption(HSV_EXCEL_FORMATTING, 30, "Customer List")
x = HypZoomIn(Empty, Empty, 1, False)

Now when I get to HypConnect and I check the connections established it says there are none. When I continue to press F8 the debug message box appears. Please bear with me as I am not that great with VBA. Would be a great learning lesson if someone could show me a code to properly establish connection to a shared database. Thanks!

-Evan
:confused:
[/FONT]

[FONT=&quot][/FONT]
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top