[Solved] Database Range Source
Posted: Tue Oct 31, 2017 5:57 pm
I have been working on a macro in a Calc file that will update database ranges/links to a Base database. This is the macro as it stands now.
I have it mostly complete, but would like to provide information messages. I would like to display the Source information as shown near the bottom of the Define Database Range window in the attached file. I have used Xray to try to see if this Source is available, but cannot find it.
Is this available to a macro program? If I am missing it, could someone provide some pointers or code sample to get me started?
Thanks in advance.
Code: Select all
Sub RefreshDBRanges
Dim oDBRangesEnum as Object
Dim oNext as Object
oDBRangesEnum = thisComponent.DatabaseRanges.createEnumeration()
While oDBRangesEnum.hasMoreElements()
oNext = oDBRangesEnum.nextElement()
oNext.refresh()
Wend
MsgBox ("Update Complete", MB_OK, "UPDATE COMPLETE")
End Sub
Is this available to a macro program? If I am missing it, could someone provide some pointers or code sample to get me started?
Thanks in advance.