Consulting

Results 1 to 2 of 2

Thread: VBA problem can anybody help

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    VBA problem can anybody help

    Sub VolgFact()
    Range("Uren!R3").Value = Range("Uren!R3").Value + 1
    Range("Voorblad!I40:I46").ClearContents
    Range("Voorblad!L9:M9").ClearContents
    Range("Uren!Q11:Q30").ClearContents
    Range("Uren!D11:E31").ClearContents
    Range("Uren!Q1:R1").ClearContents
    Range("Declaratie!C11:D31").ClearContents
    Range("Declaratie!M11:M30").ClearContents
    Range("Uren!E33").Value = Date
    End Sub

    Public Sub OpslBestand()
    Dim NieuwFact As Variant
    'kopiëren document als nieuwe factuur
    ActiveSheet.Copy
    NieuwFact = "C:\Users\Mili\Documents\Brank Scaffold\Test\Fact" & Range("Uren!Q3:R3").Value & ".xlsx" 
    ActiveWorkbook.SaveAs NieuwFact, FileFormat:=xlOpenXMLWorkbook
    ActiveWorkbook.Close
    VolgFact
    End Sub

    get Fact1
    need - Week 00 2016-0000 Brank Scaffold
    Last edited by SamT; 01-16-2016 at 08:22 PM. Reason: Added CODE Tags with # Icon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •