Tagged Questions
1
vote
0answers
30 views
MS Word automation: can't enable red underlines for spelling check
My code needs to enable spelling check in MS Word 2010 so user can see red underlines under misspellings.
In current version I try to do this to enable spelling check:
...
1
vote
1answer
32 views
How to call a Microsoft office outlook Macro from C#
I have a Macro which fetches some data into the excel file from the Microsoft office outlook (inbox or any other folder). To get the excel file I have to manually run the Macro in the outlook. Is ...
1
vote
2answers
38 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
26 views
Add excel macro from service account
Currently I try to write a service (run by system account) that creates macro in an Excel workbook. It seems that I can open excel, create a new workbook, add data and markup to it, but when I try to ...
0
votes
0answers
58 views
C# dll export System.Data.DataTable to VBA Excel
I would like to export a complex data type to VBA from a C# .dll.
Such as returning the data type: "System.Data.DataTable" to a VBA sub routine.
Minimal working example (MWE) below:
// C# .dll ...
1
vote
0answers
28 views
Debugging COM object initiated from VBA
In Excel VBA one can create COM object by CreateObject("NameSpace.InterfaceName").
Then calling function like myComObject.DoStuff()
Is there any way to set break point at myComObject.DoStuff() and ...
1
vote
0answers
59 views
Automate the fetching of e-mail(Gmail) body to an Excel file
Is it possible to automate the fetching of part of the e-mail body from my Gmail inbox to an Excel file? I want to get the data from my inbox which is in a table form to an Excel file. I tried to run ...
1
vote
1answer
78 views
Successfully registered COM DLL, but can't use class methods
I registered a COM DLL using regasm.exe, and now I'm trying to write a VBA script that uses a class from the DLL. The DLL is ExcelDataReaderLibrary.dll. In the C# source, the class is described as ...
0
votes
0answers
40 views
trying to register C# assembly, getting “Unable to locate input assembly…” error
I have a C# class library, and I want to register it so that I can call its functions from VBA.
The build is targeting .NET framework 4.0. In assemblyInfo.cs, I have set:
[assembly: ...
0
votes
1answer
65 views
Cannot call C# library exposed through COM in Excel VBA
I have tried to create a very basic C# library and expose it through COM interface so that I can access it from VBA, but at runtime it throws an error "Class does not support Automation or does not ...
0
votes
1answer
81 views
C# Add-in vs VBA Macro for Excel functionality
We would like to give users of our system the opportunity to drag some of the data from a database into Excel. (Only reading data, no chance of writing any data back to the DB). The users do not have ...
0
votes
1answer
113 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
3answers
95 views
How to create an Access DB with vba / c# (DBMS) [closed]
I have seen some tutorials but everything that I am trying is not working.
I want a simple project with just one textbox (where the name of the database goes) and a button that creates theAccess DB ...
0
votes
0answers
42 views
Calling into excel while user is defining formula -> exception
I have an application that calls excel macros from a c# program.
I show the excel workbook to the user, both user and program can make changes to open excel workbook. when program makes changes to ...
0
votes
1answer
33 views
What's the accepted way to distribute an Excel template with .NET dependencies?
I've created a handy-dandy excel template for myself that other people want it now as well. It has VBA and a couple of dependencies in the form of .NET /C# libraries that I've built. For the template ...
