Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
'-----------------------------------------------------------------------------------------------------
'Deze variabelen gebruiken bij Late Binding...
'-----------------------------------------------------------------------------------------------------
''Dim xlApp As Object
''Dim xlWBk As Object
''Dim xlWSht As Object
''Dim xlRng As Object
'================================================================
'-----------------------------------------------------------------------------------------------------
'Deze variabelen gebruiken bij Early Binding...
'-------------------------------------------------------------------------------------------------------------
Dim xlApp As Excel.Application
Dim xlWBk As Excel.Workbook
Dim xlWSht As Excel.Worksheet
Dim xlRng As Excel.Range
'================================================================
Set xlApp = CreateObject("Excel.Application") 'Create an Excel instance
xlApp.Visible = False 'Control whether or not to show Excel to your user
For x = LBound(sFiles) To UBound(sFiles)
Application.Echo False
DoCmd.Hourglass True
DoCmd.Echo False, "Bezig met: " & sFiles(x)
Set xlWBk = xlApp.Workbooks.Open(sFiles(x), True) 'Open the specified workbook
Set xlWSht = xlWBk.Worksheets("Medewerkers")
With xlWSht
.Activate
.Unprotect Password:="x"
.Visible = xlSheetVisible
End With
i = 1
Set xlRng = xlWSht.Cells(1, i)
xlRng.CurrentRegion.Delete
On Error Resume Next
xlWSht.Range("A1").Select
xlRng.Select
For Each fld In rst.Fields
Set xlRng = xlWSht.Cells(1, i)
xlRng.Value = fld.Name
i = i + 1
Next
rst.MoveFirst
xlWSht.Range("A2").CopyFromRecordset rst
With xlApp.Application
.ScreenUpdating = True
.EnableEvents = True
End With
With xlWSht
.Activate
.Protect Password:="x", UserInterfaceOnly:=False
.Visible = xlSheetHidden
End With
xlWBk.Close SaveChanges:=True
Call EditActie
Next x
For Each xlWBk In Workbooks
xlWBk.Close SaveChanges:=True
Next
xlApp.Application.Quit
xlApp.Quit
Set xlRng = Nothing
Set xlWSht = Nothing
Set xlWBk = Nothing
Set xlApp = Nothing
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.