open hidden macro file "personal.xls" with ActiveX in Excel?

[AdamS]

Aarrghh... I've almost got this sub-vi working. It runs a macro on an Excel file to format the cells with borders, bold fonts, etc. then closes it and saves as a spec'd filename. It works if before I run it, I open Excel... personal.xls, the hidden file for running macros on all open sheets then opens too, and I can run the formatting VI. However, if I don't open Excel manually beforehand, it opens a new instance that doesn't open personal.xls... Is there a way to open personal.xls whenever my ActiveX automation VI runs?

Thanks for everyone's help... this site is great.

I included my VI:

[AdamS]

Oops... spoke too soon. I figured it out. I just did an invoke node and opened "personal.xls" up before I ran the macro. Easy. Here's the VI in case anyone's interested:

[dries_vdstr]

Hey,

Is it still possible to attach your solution?

Because it's the same file as your first attachment.

When i try to open a personal macro, i always get an error that it isn't possible to open the macro, i've made the changes in excel about the security

i don't know what to do next.

Whit kind regards

[smercurio_fc]

---

@dries_vdstr wrote:

Hey,

Is it still possible to attach your solution?

Because it's the same file as your first attachment.

When i try to open a personal macro, i always get an error that it isn't possible to open the macro, i've made the changes in excel about the security

i don't know what to do next.

Whit kind regards

---

Reposted as new question here: http://forums.ni.com/t5/LabVIEW/personal-macro/td-p/1983497

Please keep discussion in one place.