|
 64bit workaround for VBA ChartViewer control |
| Posted by andrew demerchant on Mar-22-2022 20:55 |
|
Do you have a suggested workaround for getting the same, or similar, functionally as the ChartViewer Control in VBA 64bit? I've got some older VBA applications that I use that control for, so I can zoom, and pan around in a chart. Is there some way or doing that or making that work using a 64bit install? Thanks!
Andrew |
| Re: 64bit workaround for VBA ChartViewer control |
| Posted by Peter Kwan on Mar-23-2022 23:38 |
|
Hi Andrew,
Unluckily, for the ChartViewer ActiveX control, it only supports 32-bit. For 64-bit, you can still plot the chart, but you would need to use the regular Image control to display the chart, and it would not have the chart user interaction features (zoom/pan ...).
If your application is an office application, may be you can try port your code to use Visual Studio Tools for Office (VSTO). The VSTO allows you to use .NET Window Forms controls in office applications. The programming language will become VB for .NET (instead of VBA).
ChartDirector for .NET includes the WinChartViewer control, which is a Windows Forms control, and works in both 32-bit and 64-bit.
Regards
Peter Kwan |
|
Forum Home
Search
Message List
Post Message