How to get SharePoint Available for "Save As" function

This functions, e.g.:

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

are still beta and only available for Office Insiders. If they are released they are only available for Office 365 subscribers, as mentioned in the article.

Andreas.

Option Explicit

Sub Example_Combinations()
Dim C As Collection, Item, i As Integer

Set C = Combinations(Array("A", "B", "C", "D", "E", "F"), 4)
For Each Item In C
i = i + 1
Debug.Print i; ":", Join(Item)
Next
End Sub

Function Combinations(Arr, ByVal Count As Integer) As Collection
'Gibt alle Kombinationen von Count Elementen in Arr als Arrays in einer Collection zurück
'Returns all combinations of Count elements in Arr as arrays in a collection
Dim Index() As Long
Dim Result()
Dim i As Long, j As Integer
'Create a collection
Set Combinations = New Collection
'Return empty collection if Count exceed the bound's of Arr
If LBound(Arr) + Count - 1 > UBound(Arr) Or Count < 1 Then Exit Function
'Setup space for index and result array
ReDim Index(1 To Count) As Long
ReDim Result(1 To Count)
'Setup index for first combination
For i = 1 To Count
Index(i) = LBound(Arr) + i - 1
Next
Do
'Build combination
For i = 1 To Count
Result(i) = Arr(Index(i))
Next
'Save it
Combinations.Add Result
'Get next index
i = Count
j = 0
Do
'Max. position for this index reached?
If Index(i) = UBound(Arr) - Count + i Then
j = j + 1
'Move index before up one step in next loop
i = i - 1
If i < 1 Then Exit Function
Else
'Increment position
Index(i) = Index(i) + 1
'Setup next indices
For j = 1 To j
i = i + 1
Index(i) = Index(i - 1) + 1
Next
Exit Do
End If
Loop
Loop
End Function

<br />

Hallo Zusammen,
<br />das war (leider) die Antwort von MS Support:
<br />"I have checked with my internal team regarding this issue and have an update on this. As of now currently the feature to disable the Power Automate option in the SharePoint site is not available anymore. Developer has implemented this in the past but due to some issue this was disabled again. Even after successfully executing the power shell commands the options cannot be disable from the SharePoint sites.
<br />

<br />We apologize for the inconvenience you have faced. The developer team is working on this feature to put back in to the place, but we don't have an ETA on this. As this might take long time to get available. "
<br />Also aktuell offensichtlich keine Option...
<br />SG
<br />Stefan
<br />

Hallo Andreas,

ich habe die Funktionen für Längen- und Breitengrade noch verändert, damit man nicht mit LEFT, MID und FIND arbeiten muss:

Function GetLatidue(Address As String) As Double    Dim Coordinates As String

    Dim varCo As Variant

    

    'Get the coordinates for the given address.

    Coordinates = GetCoordinates(Address)

    

    'Return the latitude as number (double).

    If Coordinates <> "" Then

        varCo = Split(Coordinates, "/")

        GetLatidue = varCo(0)

    End IfEnd Function
Function GetLongitude(Address As String) As Double    Dim Coordinates As String

    Dim varCo As Variant

    

    'Get the coordinates for the given address.

    Coordinates = GetCoordinates(Address)

    

    'Return the longitude as number (double).

    If Coordinates <> "" Then

        varCo = Split(Coordinates, "/")

        GetLongitude = varCo(1)

    End If    

End Function

Diese Änderung sind auch auf OneDrive ersichtlich.

Mit freundlichen Grüßen

Claus

Function SumTanH(ByVal n As Long) As Double

Dim i As Long

With WorksheetFunction

For i = 1 To n

SumTanH = SumTanH + .TanH(n + 1) * n

Next

End With

End Function