excel macro wil niet werken

Question

wat doe ik verkeerd

Sub OpslBestand()
Dim NieuwFact As Variant
'kopiëren document als nieuwe factuur
Active Workbook.Copy
NieuwFact = "C:\Users\Gebruiker\Desktop\factuur\klant_" & Range("B2").Value & ".xlsx"
ActiveWorkbook.SaveAs NieuwFact, FileFormat:=xlOpenXMLWorkbook
ActiveWorkbook.Close
VolgFact
End Sub

Answer 1

Hi,

Microsoft Excel is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated Microsoft Excel forum over here:
https://answers.microsoft.com/de-de/msoffice/forum/msoffice_excel

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon