topic Re: VBA & Macro Issue in Inventor Forum

VBA & Macro Issue

Anonymous — Wed, 22 Feb 2017 11:08:14 GMT

Hi,

I know this has been discussed previously for other versions of Inventor but i've tried all fixes shown on other posts that i can find (see below) but i have an issue whereby when i try to open the VBA editor or macro from the ribbon bar they act like dead links. (IE they just don't do anything, no errors shown). I'm running Inventor 2017 on Windows 10 Pro.

It is really important i get this working as I have a project deadline but need to run some scripts i have on the assemble prior to issuing. Unless you fine folk know of a way to rotate components around a axis to a specific degree? This would get me out of a jam i could solve this issue at my leisure. Currently i can only do this using free rotate in assembly but for my deployment this is not accurate enough.

I rarely need to used scripts and as such i have not tried to see if the VBA & Macro ribbon bars button had worked previous. I assume not as it still doesn't work after the reinstall

I've double checked and VBA editors are working in other programs that are install (EG Office)

Attempted fixes

- Repair inventor install

- Uninstall inventor and reinstall

- disable UAC in Windows

- Uninstalled Vba7.msi manually and then reinstalled from the install files

- Checked Default.ivb is present and Inventor is pointing to it (currently in default location)

- Replaced Default.ivb in case my copy was corrupted.

Re: VBA & Macro Issue

kennyj — Wed, 22 Feb 2017 11:42:52 GMT

Hello @Anonymous, Welcome to the Forums!

As to the scripts / greyed out icons I am no help.

For the rotating parts, that I can help with!

To rotate parts in an assembly without using Free Rotate, you will utilize the Work Planes of the Part(s) and/or Assembly.

Make the workplane visible for the plane that aligns with your rotation axis, do the same for the corresponding workplane to a related part or the assembly origins. Then use Constrain, Angle. I typically will select the first angle option (2 axis), then put a constraint on each work planes and enter your angle.

If the part is cylindrical, or your have a rotation axis defined, you can use the 2nd angle option for the 3 axis as well. Once set these constraints can be driven to spin/rotate the part between start/stop points.

Turn off the workplanes when done and you should be good to go!

hope this helps,

Kenny

Re: VBA & Macro Issue

Anonymous — Wed, 22 Feb 2017 12:37:22 GMT

Thanks for the advice i will give it a go later. I don't normally have to do assemblies as i do prototyping which tend to be unibody parts so not overly up on constraints apart from mating parts next to each other etc. (the basic ones!). It's good to know its possible and the VBA issue won't hamper my deadline (hopefully).

Re: VBA & Macro Issue

Anonymous — Thu, 23 Feb 2017 21:30:23 GMT

@Anonymous wrote:
Hello @Anonymous, Welcome to the Forums!

As to the scripts / greyed out icons I am no help.

For the rotating parts, that I can help with!

To rotate parts in an assembly without using Free Rotate, you will utilize the Work Planes of the Part(s) and/or Assembly.

Make the workplane visible for the plane that aligns with your rotation axis, do the same for the corresponding workplane to a related part or the assembly origins. Then use Constrain, Angle. I typically will select the first angle option (2 axis), then put a constraint on each work planes and enter your angle.

If the part is cylindrical, or your have a rotation axis defined, you can use the 2nd angle option for the 3 axis as well. Once set these constraints can be driven to spin/rotate the part between start/stop points.

Turn off the workplanes when done and you should be good to go!

hope this helps,

Kenny

Hi Kenny,

Thanks to the advice on the constraint whilst the angle constraint is not that intuitive to use it did the trick. Whilst my issue regarding the VBA and Marco is not solved you have allowed me to hit my deadline so i can't thanks you enough.