Tagged Questions
15
votes
2answers
1k views
How to invoke an action during powerpoint slideshow programmatically?
I am automating a Powerpoint scenario using Coded UI & VSTO. In my powerpoint presentation I have created an 'Action' setting on a shape to launch notepad. During slideshow I need to invoke this ...
13
votes
5answers
761 views
How do I associate my application with a pinned program on the Windows 7 taskbar?
We have an application, let's call it MyApp. On installation, we create a desktop icon for MyApp, which basically calls MyLauncher.exe /launch MyApp.exe. MyLauncher does some useful stuff (check for ...
12
votes
1answer
2k views
Accessing a VSTO application-addin types from VBA (Excel)
We have a VSTO application-addin (not a document-addin) for Excel, and we want to expose an event to VBA code so that the VBA macro can do some action when this event fires in the addin. How can I ...
10
votes
8answers
914 views
What if any links exist to free Excel “helper” class libraries for C#?
I'm looking for any available free Excel "helper" classes that are written for .net (doesn't have to be C#).
I'd like to evaluate what others consider to be useful and generic static (and non static) ...
8
votes
6answers
823 views
Create automation macro support within an application
I need to get an automation macro like thing within our desktop application. The desktop app will probably be in VB.NET or C#.net.
The reason is to enable the user to record and replay certain tasks ...
8
votes
4answers
8k views
Recommended way to read and write .ini files in VBA
Are any methods available in VBA to read and write INI files? I know I could use;
Open "C:\test.ini" For Input As #1
...and parse the data. Instead I am trying to see what tools are already ...
8
votes
1answer
523 views
Execute button inside a ribbon
I want to write a script (C# or AutoIT or VBScript.. whatever works) which should
Get reference of already open outlook application
Iterate through ribbons to find a specific button
Execute that ...
7
votes
11answers
2k views
What's wrong with output parameters?
Both in SQL and C#, I've never really liked output parameters. I never passed parameters ByRef in VB6, either. Something about counting on side effects to get something done just bothers me.
I know ...
7
votes
4answers
2k views
Is there a way to overload the constructor / initialize procedure for a class in VBA?
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class:
public class MyClass()
{
public MyClass(String s) { ... }
}
This overrides the default ...
7
votes
6answers
4k views
Can't instantiate a COM object written in C# from VBA (VB6 ok)
Using VS 2008, here is my COM object
using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.InteropServices;
using System.Windows.Forms;
namespace TestCom
{
...
7
votes
2answers
379 views
Execute .NET 3.0 code from Office 2003
I've created a DLL in C# using the .NET 3.0 framework.
Below is the code of my DLL
namespace CompanyName.Net
{
[Guid("F7075E8D-A6BD-4590-A3B5-7728C94E372F")]
...
6
votes
5answers
9k views
Is it possible to convert VBA to C#?
I have a few modules of block of code in vba to run on few access databases. I would like to know how should i proceed if i wanted to convert the coding to c# environment. And is it possible to ...
6
votes
3answers
413 views
Communicating between C# and VBA
At the request of my boss I created a small set of scripts that are used to periodically monitor the status of certain devices and processes. This info is subsequently processed using a relatively ...
6
votes
2answers
944 views
MS Access without VBA?
A simple question: Is it possible to use C# instead of VBA for MS Access? Can I extend Access applications with windows forms and (or) WPF? Would such a scenario make sense?
6
votes
4answers
1k views
SMS connecting to a phone from C# and getting a response
I wrote code to send an SMS using my GSM phone which is attached to the computer through COM port. The code is below.
The problem is I do see that it is in the outbox of the phone and it actually ...
