Search:

Type: Posts; User: Dan_W

Search: Search took 0.02 seconds.

  1. Replies
    12
    Views
    274

    Re: Converting VB6 add-in

    VBA doesn't compile DLL files. For that, you could try using TwinBasic which I've started exploring and looks very promising.
  2. Replies
    12
    Views
    274

    Re: Converting VB6 add-in

    In trying to improve in VBA, I end up converting projects written in VB6 to VBA fairly frequently. It really all depends on what it is that you add-in tries to do. If it's just a matter of converting...
  3. Replies
    1
    Views
    391

    Re: VBA Combine PNG/JPG to an animated Gif

    When you say you want to combine PNG/JPG files to an animated GIF, do you mean that you want to add each of the PNG/JPG images to an existing animated GIF as separate frames? Or that you what to...
  4. Replies
    16
    Views
    928

    Re: Using Word dictionary for spell check

    I wonder if perhaps you're code is referencing the wrong Word library (i.e., I'm using the Word 16.0 Object Library), but then I would expect an different error message/problem. What does your code...
  5. Re: [Ppt] How to execute commandbar control for triangle and double arrow?

    Not sure how to go about adjusting the commandbars enabled property for either shape, but hopefully the following VBA code will work for you. If you paste them in a standard module, you should then...
  6. Re: [Add-In] Large Project Organiser (alternative Project Explorer)

    Thank you very much! :-)
  7. Replies
    8
    Views
    630

    Re: Error while adapting VBA code

    Your most code snippet will result in the 438 error for the same reason - like ActiveDocument, Selection is a member of the Application (and not of the Document).
    Referring to your original code,...
  8. Replies
    8
    Views
    630

    Re: Error while adapting VBA code

    I tried it in VBA, and the line of code in question (as provided by you) did not work for me, but I didn't expect it to either.
    As westconn1 explained, Wdoc is itself a Document, and ActiveDocument...
  9. Re: Formula - Keep destination formatting

    Sounds as though the destination cell has conditional formatting applied to it.
  10. Replies
    10
    Views
    795

    Re: i need to make 3d viewer

    Well the website is, yes, but the projects that were on it have been reuploaded onto Github here. Did you not the see I link I posted?
  11. Replies
    10
    Views
    795

    Re: i need to make 3d viewer

    The author of the project, Peter Wilson, has a number of other 3D/Graphics projects on PSC, including some tutorials - so if the 3D Studio doesn't fully meet your needs, maybe the rest of PW's...
  12. Replies
    10
    Views
    795

    Re: i need to make 3d viewer

    By no means is it on the same level as The Trick's demo above, but there is a 3D Studio project will imports .X files (which I understand you were after from you other thread) available on Github...
  13. Replies
    14
    Views
    7,661

    Re: [VB6/VBA] Timer class.

    My apologies for the late reply - it's been hectic at work.

    The Trick - thank you very much for offering to look at my code. Given MountainMan's explanation re: EBMode, I don't want to waste your...
  14. Replies
    14
    Views
    7,661

    Re: [VB6/VBA] Timer class.

    @MountainMan - I've also can't seem to get the timer to decouple from the modal UserForm (Office 365/64bit) - I don't suppose you've managed to solve this? I've tried relocating the m_cTimers...
  15. Replies
    7
    Views
    670

    Re: Accessing data in Excel

    Hi

    In addition to the comments above, the Range reference is problematic:- Range(row & "A") would equate to cell 3A, rather than A3, for example.

    The following should work:


    Set ExcelApp =...
  16. Re: Marking an excel file with a key from system

    The suggestions above are likely the most straight-forward (and to easy to implement) solutions, but I thought I'd just throw into the mix the method detailed in Chip Peason's blog about writing and...
  17. Replies
    25
    Views
    2,478

    Re: How Recognize geometric shapes

    I was wondering the same thing. I wanted to ask OP, but he has been a bit quiet today since it became apparent I wasn't just going to do his assignment for him...! :-)
    My reason for being curious...
  18. Replies
    25
    Views
    2,478

    Re: How Recognize geometric shapes

    This is bizarre - I was helping someone else on a very similar 'problem' just this morning.

    I've been helping out on some Office/VBA forums by answering questions, etc., and was this morning...
  19. Replies
    7
    Views
    1,431

    Re: Calculator Simple usercontrol

    I ought to say that, for my part, I am extremely grateful to you and others who continue to share your work in the Codebank. I must confess that I don't have VB6, but I do code in VBA so I can...
Results 1 to 19 of 19



Click Here to Expand Forum to Full Width