Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DeaPeaJay

  1. DeaPeaJay

    Convenient Macro running

    See that's the thing, I have no idea what computer it will be run on. I didn't think there'd be a simple solution,(I never expect that from MS). I just thought I'd ask =)
  2. DeaPeaJay

    Convenient Macro running

    I've just finished work on a huge macro that needs to be run every month or so. This may seem like a dumb question, but I've looked everywhere and I can't seem to find anything. Is there a way to make the macro easily runnable without having to open the application it uses (Visio) then importing...
  3. DeaPeaJay

    Code execution interrupted

    Ok, I thought my problem was gone. Basically, I'm running the code. It's making modifications to hundreds and hundreds of cells in a long list via a For..Next loop. When I exit out of the for next loop I move onto another one with some intermediate code in between the two massive loops. THAT's...
  4. DeaPeaJay

    Code execution interrupted

    Thank You. Thank You. Thank You. I can't believe I missed that. Apparently, that was the reason for my other problems too.
  5. DeaPeaJay

    Code execution interrupted

    My code is constantly being interrupted for no reason in random spots. It's almost as if I'm constantly pressing ctrl-break (which I'm not) I ran it through once flawlessly. Now, it's another story. I can't make any sense of this... very frustrating. I could make a microsoft bashing remark...
  6. DeaPeaJay

    On Error GoTo problem

    Well for my purposes, it's probably not worth it to use the file search property anyway. I'll stick with the Dir wildcard :-)
  7. DeaPeaJay

    On Error GoTo problem

    I have Microsoft Office 11.0 Object Library ticked, and i get the same error
  8. DeaPeaJay

    On Error GoTo problem

    PHV, THANK YOU. That works like a charm. You all have been lots of help!
  9. DeaPeaJay

    On Error GoTo problem

    oh, yah its in Visio
  10. DeaPeaJay

    On Error GoTo problem

    Zathras, That would have been super if that script worked. That's what I've been wanting to do. But it threw up the unsupported property or method error on me :(
  11. DeaPeaJay

    On Error GoTo problem

    Hey, thank you all. I'm learning here, AND you fixed my problem :D Thanks
  12. DeaPeaJay

    On Error GoTo problem

    I'm trying to cycle through numerous Visio files in a folder, all with the same naming convention. "Complex99.vsd". So I have a counter that increments in a for loop and is concatenated to the filename string. But not all filenames are actually there. Some may jump from "Complex3.vsd" to...
See more

Part and Inventory Search

Back
Top