excel macro wil niet werken

jerry vangerven 1 Reputation point
2020-07-02T17:57:00+00:00

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,760 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Leon Laude 85,726 Reputation points
    2020-07-02T18:05:06.167+00:00

    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

    0 comments No comments