DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Excel OCX does not support Add Ins

 
Post new topic   Reply to topic    DPlot Forum Index -> Excel
View previous topic :: View next topic  
Author Message
dai50



Joined: 04 Aug 2006
Posts: 1

PostPosted: Fri Aug 04, 2006 9:02 am    Post subject: Excel OCX does not support Add Ins Reply with quote

I'm working with an application which exports data to an Excel template and automatically calls a macro to carry out any processing. I have built macros into the template to select data ranges and generate a series of plots using DPlot as an Add in. Although, this works fine, I need to be able to allow the user to manually select other ranges and generate other plots BUT addins do not show on the menu structure, including DPlot. Is this a property of calling Excel (OCX) from another application which can be modified?

If I close and save the sheet generated from the template, I can access the DPlot add in and manually carry out the plots.

Any help here would be gratefully received..

Dai
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Fri Aug 04, 2006 11:14 am    Post subject: Reply with quote

Dai,
Unfortunately I have no experience at all with OCX's, but my guess is that either 1) it cannot be done or 2) it is a user account issue. If you're running the OCX and try to save a file as a "Microsoft Excel Add-In (*.xla)" file, Excel will generally set the default folder to the proper folder for storing Add-Ins under the currently active user account. If you try this and it is NOT c:\Documents and Settings\<username>\Application
Data\Microsoft\Addins... what is it?
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Excel All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group