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.
Excel Add In
Moderators: EViews Gareth, EViews Moderator, EViews Esther
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Excel Add In
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
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
Who is online
Users browsing this forum: No registered users and 33 guests