Hello,
I would like from a button on the Excel ribbon to access page 1 or 2 of the pane directly. Can you please help me in my process.
When I finish my project, I can make it available to the community if you wish.
My project is to basically provide two functionalities to the Excel document:
- Synchronization (using WinSCP)
- Uncompress tar.gz
VBA code is also running in the workbook to work with text files
Thanks
I would like from a button on the Excel ribbon to access page 1 or 2 of the pane directly. Can you please help me in my process.
C#:
using Microsoft.Office.Tools.Ribbon;
using System.Windows.Forms;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace AE
{
public partial class Ribbon1
{
private readonly ActionsPaneControl1 TaskPane = new ActionsPaneControl1();
private void Ribbon1_Load(object sender, RibbonUIEventArgs e)
{
}
private void btServeur_Click(object sender, RibbonControlEventArgs e)
{
Globals.ThisWorkbook.Application.DisplayDocumentActionTaskPane = true;
TaskPane.Show();
}
private void btFlux_Click(object sender, RibbonControlEventArgs e)
{
Globals.ThisWorkbook.Application.DisplayDocumentActionTaskPane = true;
TaskPane.Show();
tabControl1.SelectedIndex = 1; <= error?
}
}
}
When I finish my project, I can make it available to the community if you wish.
My project is to basically provide two functionalities to the Excel document:
- Synchronization (using WinSCP)
- Uncompress tar.gz
VBA code is also running in the workbook to work with text files
Thanks
Last edited: