Excel Add In

For questions about EViews Add-ins available from the EViews Add-ins webpage. Note each add-in available on our webpage will have its own individual thread.

Moderators: EViews Gareth, EViews Moderator, EViews Esther

Redwing153
Posts: 30
Joined: Sat May 30, 2015 5:10 am

Excel Add In

Postby Redwing153 » Fri Jun 19, 2015 9:39 am

At the risk of seeming somewhat obsessed with the excel add in...

It doesn't give the option to link/get charts - is there a reason for this? Are any future updates likely to incorporate this possibility?
I realise charts can be copied/link pasted in as objects, but that isn't really enough for me as I want to be able to change the (eviews link) reference for a number of such chart objects (without manually editing the reference in the formula bar).

I assume this could be done with VBA, but apart from recording macros I have very little experience of this.
Does anyone know of a solution?
Thanks.

R.

EViews Steve
EViews Developer
Posts: 790
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Excel Add In

Postby EViews Steve » Sat Jun 20, 2015 6:39 am

There are currently no any plans to add support for remapping linked OLE charts/graphs from within the add-in.

You'll have to write your own VBA macro to perform the mass-link change. I did a quick google search to see how you would do this. First, you'll need to get a list of the list sources in your workbook so you'll need to call Workbook.LinkSources:
https://msdn.microsoft.com/en-us/librar ... 21922.aspx

Next, you'll need to call Workbook.UpdateLink to update each link:
https://msdn.microsoft.com/en-us/librar ... 95741.aspx

Hope this helps...

Steve


Return to “Add-in Support”

Who is online

Users browsing this forum: No registered users and 24 guests