Tagged Questions
0
votes
1answer
15 views
Excel DNA registering COM libraries in HKLM
I have a question about Excel DNA. I have a .DNA file which, using ExcelDNAPack, creates a .XLL Excel Add-In. I have chosen for the DLLs to be packed into the XLL.
When we load the XLL (as an Add-In, ...
1
vote
2answers
69 views
How to set combo box text and value fields
How to set combo box text field and value field in Excel VBA, like we set for dropdown list in web applications, For example,
DropdownList.DataTextField ="EmpName";
DropdownList.DataValueField = ...
0
votes
1answer
55 views
Integrating ASP.NET Page With MS Excel as DB
I want to create a ASP.NET application which will fetch and store data from excel. For eg. currently i have automated excel reports using VBA and Macros, and user have to oem all the excels to get the ...
0
votes
1answer
47 views
controlling excel through dotnet?
I am trying to run a stored proc which inserts data into tables. After doing that, I am refreshing the excel that is stored in my local machine(this excel has data connections to the db)
I am having ...
0
votes
1answer
52 views
Remove excel document action pane before saving excel workbook
I wish to clear document action pane controls before workbook shutdown. So that next time when I open that workbook action pane will not there. Basically I wish to detach action pane before workbook ...
0
votes
1answer
201 views
Fetch data from a Website into an Excel file with the hyperlinks in it
When I fetch data from a webpage to an Excel file using Macro it saves the data in the Excel file as it is supposed to be. My requirement is that it should save the data in the Excel with the ...
1
vote
2answers
555 views
Excel.Worksheet.Cells[row,col] = “=Formula” vs. Range.set_Value(Missing.Value, arrayFormulas)
Excel.Worksheet.Cells[row,col] = "=Formula / reference"
While in the above Excel updates the formula / reference and shows the result in the datasheet, in the code below, when using ...
0
votes
0answers
172 views
C# Cant read VBA Macros from Excel. (Line count 0)
I am trying to get the VBA Macros from an Excel File.
The file does not have password, and the vb project does not seem to be password protected
because I am opening it without setting the current ...
0
votes
1answer
125 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
129 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
vote
1answer
571 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
68 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
169 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
68 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
645 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 = ...
