Tagged Questions
0
votes
1answer
47 views
Excel Crashing when running COM object with Thread
I am experiencing an error in Excel while running a COM (Home made) Timer.
Basically Excel instantiate the Timer, initializes it and starts it. The Timer then ticks every X milliseconds raising an ...
1
vote
1answer
55 views
Remove excel document action pane
We can attach document action pane to any excel file using Developer-> expansion pack-> Microsoft action pane -> attach.
Once the excel is saved and opening it again will have previously stored excel ...
-1
votes
0answers
34 views
retrieval of structure information from Hex Code [closed]
I am having a hex code (Graphic image embedded in this hex) which needs to be convert to proper binary code.
After this conversion, i have to view embedded graphic image in the binary code.
Kindly ...
-1
votes
0answers
27 views
How can i call skill code using xlsx 2010 and vlto wrappers? [closed]
Actually i am using for designing allegro and skill code and web based application i am trying to call skil code using xlsx2010 addin plugin i have to call skil code i am unable to figure that please ...
0
votes
1answer
285 views
How to label Excel X and Y axes in 2d graph
I am stumped on a problem that seems easy, labeling X and Y axes!
I am creating an Excel graph inside VS2010 with C#. It is a 2D XY scatter chart. But I can't control the label of the X axis! I ...
0
votes
0answers
37 views
Why does changing any attribute of PageSetup in Excel set a PrintArea?
I have an algorithm that changes various layout properties of an Excel sheet. I found a workbook online that has a sheet with an interesting behavior that I am trying to understand. When I run through ...
1
vote
1answer
75 views
How to convert this VBA Excel code to C#
I am trying to convert excel VBA code to c#. This code must be executed outside excel and I am going to convert my excel macros to do so. Here is the code to convert
ActiveWindow.Zoom = 85
...
1
vote
0answers
40 views
Difference between DisplayDocumentActionTaskPane and Visible property
I am working on excel vsto solution.
Not able to understand exact difference between below properties.
1. Application.DisplayDocumentActionTaskPane
2. Application.CommandBars["Task Pane"].Visible = ...
0
votes
1answer
373 views
Excel:the file you are trying to open is in a different format error
Below is the code to copy worksheet to a new excel file,but throws error like "the file you are trying to open is in a different format" when I open it.What is wrong here?
String startPath = ...
0
votes
1answer
112 views
C#:Copy protected worksheet to another excel file
I was trying to copy paste one protected worksheet to another excel file but i`m getting error like
"Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))"
C# Code:
try
{
...
0
votes
1answer
196 views
Un Protecting excel VBA Project through SendKeys
I am facing a issue while unprotecting the VBA Project of the protected excel.
IntPtr hWnd = FindWindow(null, ES.oXL.VBE.MainWindow.Caption);//Find window
if (hWnd != IntPtr.Zero)
{
bool ...
1
vote
1answer
328 views
How to unlock protected vbaproject in a excel file from C#?
Could somebody tel me how to unlock the vba project of my protected excel file?
I tried with below C# code:
Exc.wbook = (Excel._Workbook)Exc.Workbooks.Open(FilePath, 0, false, 5, "", "", false, ...
0
votes
0answers
64 views
Cannot perform operation since the project is protected
I am trying to open a protected Excel macro sheet from C# and change the macro function. I have done it using sendkeys and while debugging it is working. But when I put this code in server I am ...
-9
votes
1answer
120 views
C#:Examples to unprotect excel Macro sheet from C# [closed]
Are there any better websites where I can get better examples to UnProtect my protected vba macro excel sheet from C#.?
I tried alomost all possible cases,like "workbook.unprotect()","sendkeys",when ...
1
vote
2answers
222 views
Unprotect excel sheet
Following is my C# code,where i`m trying to unlock protected sheet by passing password,but it still not unlocking the sheet, I need to add some macro to the sheet .
Code:
const string excelFile = ...
0
votes
0answers
142 views
Problems in using Excel Sheet contains functions (Macro) in C# code?
I have an excel file that contains some methods written in VB I think. I want to know any way makes me use these methods in C# code. I tried to make a connection with the file using ...
0
votes
1answer
124 views
Select range in aspose
Do you know an equivalent to VBA code:
Range(Selection, Selection.End(xlToRight)).Select
In Aspose.Cells. It seems that its only possible to select the last cell in the entire row:
public ...
1
vote
1answer
185 views
Change macros text in Excel programmatically
I've got about thousand of Excel (xls, old format) files spread out across many folders on the hard-drive. These files have the same macros that connects to a database. And the macros contains ...
0
votes
4answers
352 views
Using Excel in C# to transfer Cell Values to a 2D string array
I need someone to create a method that will get me all the cell values in an excel spreadsheet into a 2D array.
I'm making it using ribbons in C# to work with Excel but i just can't get it to work.
...
0
votes
2answers
254 views
Getting Cell Values from Excel API C#
I have a ribbon that i made for Excel along with a cs File to perform as the core of the add-in.
When a button is clicked on the CustomRibbon I want to parse the data values for one of the rows.
...
0
votes
0answers
139 views
Sometimes popup window disappears in Excel
I am working on excel vsto project. I have implemented ProgressBar window to show background progress. I have written one public method to run this background form. It's working properly but sometime ...
5
votes
2answers
196 views
Read excel application status bar text
Is there any way to get excel application status bar text?
Any answer would be appreciated.
7
votes
2answers
266 views
Checking whether focus is set to excel cell
I am working on VSTO Project. I need to detect the input focus in Excel vsto project.
I want to check whether focus is on excel cell or it is on other excel component like find dialog, document ...
0
votes
0answers
93 views
Changing title text of document action pane excel
I am working on VSTO Excel application. I need to change the title text of excel document action panel. is it possible to change that.
My project is of excel workbook type. I have written code in ...
1
vote
1answer
38 views
Excel Codemodule properties
I got a problem trying to retrieve name property of a codemodule from code (C#).
When I alt+f11 my excel file I have the following:
Chart1
Sheet2
Sheet3
ThisWorkbook
When displaying properties for ...
3
votes
1answer
100 views
how to identify that a worksheet is minimized?
How to identify the current active worksheet is minimized ?
I do not want to run my operation when the current worksheet in excel is minimized. I am using excel interop and C#
0
votes
0answers
55 views
Can a managed Excel UDF add-in return a clickable Hyperlink?
I have created a managed (C#) udf add-in that returns the a URL.
At the moment, it shows as a column of text in Excel and needs to be converted via the Hyperlink function.
I've read the docs and ...
0
votes
2answers
115 views
Optimizing database calls in an Excel Add In
I am writing a DLL in .NET (C#) which can be loaded as a plugin in Excel. The DLL will provide many functions which can be used as formulas in Excel, to lookup certain values from the database of an ...
1
vote
1answer
272 views
Distinguish Save and Autosave events in Microsoft Excel Add in
I have two Microsoft Excel 2007/2010 C# Addin projects. How can I distinguish regular "Save"/"Save As" commands that are called by user and "AutoSave" event that is periodically invoked by Excel ...
1
vote
1answer
149 views
Selecting custom reference name for a .NET (COM) tlb library when exposing it for VBA add reference dialog
What I have is a C#, .NET 4.5 ComVisible(true) library that is being consumed by an Excel 2010 VBA client.
I have two questions:
1 -
In VBA when I add a reference to my tlb from "Tools -> ...
0
votes
0answers
57 views
Modless dialog hangs when displayed from C# out of proc server
I am invoking an Out of proc server from Excel macro, and display a modless dialog. But the dialog hangs. any message loop problem..!?
Here is the C# out of proc server
...
0
votes
1answer
231 views
parser to convert .net dictionary or list to VBA's equivalent dictionary or collection
i have to pass the .net dictionary or list type of object to VBA.
but when i am passing the .net dictionary at VBA side i am not able to see the elements of dictionary on .net side.
My code in C#
...
0
votes
1answer
73 views
how to identify if the given selection contains an array formula
I want to delete a non contigious range which contains array formula. I have custom logic to delete this non contigiuos range area by area. So if the area contains any array formula which cant be ...
1
vote
0answers
184 views
Excel Range.Formula is taking time to give an output in c#
I have created an Excel 2007 Addin Application.
I am accessing a particular range formula but it is taking more time than the equivalent in VBA.
My code in C#
Excel.Range rng = ...
0
votes
1answer
263 views
Copy vba code to another xlsm file using Open XML from a template xlsm file
I use this code to add VbaPart of the template xlsm file into another .
When i open the vb section duplicate entries get added for each sheet as well as the "ThisWorkBook".
Below is the screen shot ...
1
vote
0answers
110 views
CurrentThread.CurrentUICulture -how to set via excel VBA
CurrentThread.CurrentUICulture -through C# we can set this value, but is it possible to set this via VBA. in an xla file..
2
votes
1answer
57 views
Auto Updater for excel files
I have a custom auto updater for some software that I wrote. The software consists of a number of DLLs along with an .xla file. Currently, my auto updater works as shown below
1) Check server to see ...
0
votes
0answers
34 views
What tools/ways of doing to share C++ libs between Excel and Server side C# processes?
I would like to implement some low level calculation librairies in C++. Ideally, I would like to use the functions developed in C++ :
From an Excel front-end for some users to make synchroneous use ...
0
votes
0answers
230 views
C# exceldna return multi cell result
When i call a UDF defined using exceldna in C# , am getting result as a single cell.
Instead , my result is a two dimension array and i want to spread it across multiple cells.
How will i do it ?
0
votes
1answer
77 views
Get the Excel xlGeneralFormatName in C#
I'm trying to get the
xlGeneralFormatName
From Excel, like this:
Excel.Application _excelApp;
Excel.Workbook _excelWB;
_excelApp = new Excel.Application();
...
0
votes
0answers
82 views
How to trigger Backend job on a web server and return results?
I am planning to do the following:
Users will go to a website and click buttons, which will trigger a task to do some calculation in an Excel spreadsheet(s). Both the website / spreadsheet(s) are ...
5
votes
3answers
618 views
Text replace in VBA code of Excel files
we have several tens of macro enabled excel files, each of those contains few VBA modules and in each of those modules there are SQL server names and userid/passwords of the sql login.
I wonder if I ...
1
vote
1answer
149 views
Add xsd files to the data directory of the office clickonce deployment
I have the deployed excel document solution to the server using clickonce. xsd files are not being deployed though i have added these files in my solution and kept the properties as
...
1
vote
0answers
41 views
Active cell address [duplicate]
Possible Duplicate:
How can i get the Cell address from excel
Is it possible to get active cell address like A1048576 in excel using vsto or c# or any hint using vba.
I am able to get ...
2
votes
1answer
406 views
Excel VBA project not getting closed
I have a COM addin in which I am handling excel events. I click Alt F11 to view the VBA project related to an excel. However, when I close the workbook the Excel VBA project in the project explorer is ...
1
vote
1answer
431 views
SQL job failed to run a C#.net console application
I have a simple excel file that has the following code:
Private Sub Workbook_Open()
MsgBox "Hello World!"
End Sub
I tried to run a sql job to open this excel file but it failed, became ...
0
votes
0answers
64 views
Pin file excel 2010
Is it possible to get a list of recently pinned workbooks in excel 2010
Im trying and searching abt it but not getting a proper solutions
I am able to find recent files through
...
1
vote
1answer
98 views
dollar-o-gram: how is this developed in excel? [closed]
Reference here
I've got a situation where a chart of the dollar-o-gram format would look great.
What is the simplest way to develop this chart ?
I have knowledge of the following:
Excel VBA
...
1
vote
0answers
151 views
Casting to a dynamic type and Invoking a method on an InternalCOMObject returned from a dynamic COM Object
We have a Third Party COM component that we are attempting to call from a Silverlight 5 OOB application using the AutomationFactory and dynamic objects. We are able to "Create" the COM Object and call ...
2
votes
2answers
300 views
Excel Formula & Metadata
Is there any way to extract underlying metadata of various excel formulas. I am building this framework in C# that uses excel formula, and interested in knowing each formula input arguments, their ...
