Tagged Questions
0
votes
0answers
10 views
Match text box to website text box in WP8 App
So I am a noob at programming and I can give you an example of what I want.
Lets say my app is using my website to access certain elements and I created a username validator which requires a text box ...
1
vote
1answer
27 views
How to copy a linked table in MS Access 2007 to local table with VBA (or C#)?
I have an Access 2007 database, c:\myDb.accdb, with a table named MASTER_TABLE that is linked to a table named TBL.MASTER_TABLE in a DB2 database named PRODUCTION.
When I open MASTER_TABLE, I'm ...
3
votes
1answer
75 views
Early Binding of a C# COM library in VBA
Although this is a long question the coding and testing part should be really easy to reproduce.
I have created two separate Class Libraries in C# and I think I am running into a name collision ...
2
votes
1answer
31 views
Connecting to a SQL server using ADODB from a C# dll
I am writing a custom Connection class in C# for Excel to be able to connect to a SQL Server.
When I use SQLConnection from System.Data.SqlClient library I am able to establish a connection. The ...
6
votes
2answers
90 views
VBA equivalent to C# using or VB.NET imports / creating aliases
Base Reference: Ten Code Conversions for VBA, Visual Basic .NET, and C#
Note: I have already created and imported a *.dll, this question is about aliases.
Let's say the programmatic name of a Test ...
-1
votes
1answer
46 views
Comparing files in folder and moving them if size smaller
im new here, have been trying to compere one file to another and if previous file in folder is bigger then move the file. I was trying to find solution for vba, batch, c# but had no luck yet. there ...
1
vote
1answer
47 views
Excel Runtime error 13
I've gone through various posts and can't figure out my problem.
I have a COM object that builds and a Excel.Range of data and hands this back to an Excel macro. This is then set to a Variant and ...
0
votes
1answer
24 views
Receiving values back after calling a sub in Access through .NET
I am creating an C# application that must call subs in an Access mdb database file.
I've created a test sub in the mdb file and I can call it from C# and also pass it parameters. That all works fine, ...
2
votes
2answers
132 views
Errors when calling certain Excel VBA macros from C#
I have been struggling and searching on this problem to no avail...
I have a few test macros that work perfectly when run from Excel, but either fail or don't work when called from C#, using the ...
0
votes
0answers
38 views
Reading VBA property set with C# within VBA workbook event
I have a C# VSTO / VBA hybrid project.
When a user opens a valid Excel workbook using my VSTO app, a VBA property is set from C# as such:
worksheet.GetType().InvokeMember("AddInIsLoaded",
...
1
vote
1answer
33 views
How to progamatically force a break in the VBE Editor
I am writing a c# application that opens a number of PI ProcessBook display files. PI Processbook is a program that has embedded Visual Basic for Applications support, including a VBE environment.
...
4
votes
1answer
101 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
50 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
70 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
31 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 ...
