Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Performance Management Applications
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jul 14, 2011 11:17 PM by
SmartView 11 - HypRetrieveRange refresh the complete sheet not range, why?
Jan 27, 2010 3:05 AM
I wrote the follow code like the example in the smartsheet_admin_guide:
+Declare Function HypRetrieveRange Lib "HsAddin.dll" (ByVal vtSheetName As _+
Variant, ByVal vtRange As Variant, ByVal vtConnName As Variant) As Long
Y = HypRetrieveRange("Tabelle1", Selection.Cells, "DE09ROH")
If X = 0 Then
MsgBox ("Retrieve successful.")
MsgBox ("Retrieve failed.")
Also i tried it with a regular range like
but if i click on my button on
which refers to my macro the complete sheet
will be refreshed but not the marked range only.
Why does the function refresh the complete sheet and not the selected range? Where is the bug in my code or is it not possible to refresh only a selected range?
Many thanks for every help. :-)
Btw: I used HFM 22.214.171.124 with EPMA-Application and SmartView 11 with Office XP (Office 2002) and Windows XP Professional SP2 on the client pc´s.
Edited by: MartinKlein on 27.01.2010 09:57
This content has been marked as final.
Show 1 reply
Re: SmartView 11 - HypRetrieveRange refresh the complete sheet not range, why?
Jul 14, 2011 11:17 PM
in response to
Even we are facing similar issues, if you have got the answer to the above query can you please share with us.