Checking if the excel is open - here I go again.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Originally posted by NinjaBadger View Post
    https://www.dropbox.com/s/924hd5rvr016c4c/rund.jpg?dl=0


    My pride and joy! Looks and works brilliantly. RepDmis is arguably more useful however.
    What is a "Clyinder"?
    sigpic
    Originally posted by AndersI
    I've got one from September 2006 (bug ticket) which has finally been fixed in 2013.

    Comment


  • #17
    Originally posted by NinjaBadger View Post
    https://www.dropbox.com/s/924hd5rvr016c4c/rund.jpg?dl=0


    My pride and joy! Looks and works brilliantly. RepDmis is arguably more useful however.
    Man that is awesome! I'll definitely be drawing some creative influence from it

    p.s the clyinder gives it character lol
    Clearance is clearance.

    Comment


    • #18
      Originally posted by NinjaBadger View Post


      I did one module of Visual Basic at Uni years ago. The rest was self taught / copy pasted / modified etc etc.

      Debugging will help you figure it out.

      FileName = Part.partname & " " & strVariable & " " & reasonVar & ".xlsm"
      MsgBox(FileName)
      Workbook(FileName).Close 'Close results workbook

      If the file name is being generated correctly then you may need to loop through the open workbooks checking for a match, before you try close it



      (This is psudocode - i.e. It shows tha basic structure but the exact syntax etc might not be right.)

      i.e.

      for i = 1 to workbooks.count

      if workbooks(i).name = FileName then
      Tutuapp 9apps Showbox
      workbook(i).close
      end if

      next i
      no i think he did not generate the file correctly
      Last edited by klimbo123; 01-23-2019, 04:24 PM.

      Comment

      Related Topics

      Collapse

      Working...
      X