Search:

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

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...

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...

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...

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...

Thank you very much! :-)

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,...

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...

Sounds as though the destination cell has conditional formatting applied to it.

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?

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...

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...

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...

@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...

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 =...

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...

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...

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...

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...