Results 1 to 2 of 2

Thread: Run a module

  1. #1
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47

    Unanswered: Run a module

    I have a module i want to run inside a macro, i use open module and all this does is open up the visual basic design. How can i call to it get it to run?
    I have only two pieces of code which run a file copy from one folder to another.I also have another series of macros which run and i want this to run after them.


    Sub ArchiveBackup()
    FileCopy "C:\Program Files\LTS\PPL\Data\ExportedWeeks.xls", "C:\Program Files\LTS\PPL\Archive\ExportedWeeks\ExportedWeeks" & Format(Now, " DD.M.YYYY-HH.mm.ss") & ".xls "
    FileCopy "C:\Program Files\LTS\PPL\Navision\shipment lines.txt", "C:\Program Files\LTS\PPL\Archive\shipmentlines\Shipment lines" & Format(Now, " DD.M.YYYY-HH.mm.ss") & "..txt"

    End Sub


    Thanks dave

  2. #2
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47
    ok sorted.. used a it as a function and Inside the macro used the Run code command

Posting Permissions

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