Click here to Skip to main content
15,914,070 members
Home / Discussions / C#
   

C#

 
AnswerRe: Detecting thumb drive insertion and suppressing Autorun. Pin
Perspx20-Sep-08 9:26
Perspx20-Sep-08 9:26 
GeneralRe: Detecting thumb drive insertion and suppressing Autorun. Pin
ihaxxu21-Sep-08 10:33
ihaxxu21-Sep-08 10:33 
QuestionPls pls pls help me been working on it for weeks Pin
yefeng_law20-Sep-08 7:16
yefeng_law20-Sep-08 7:16 
AnswerRe: Pls pls pls help me been working on it for weeks Pin
Harvey Saayman20-Sep-08 9:45
Harvey Saayman20-Sep-08 9:45 
GeneralRe: Pls pls pls help me been working on it for weeks Pin
Colin Angus Mackay20-Sep-08 12:15
Colin Angus Mackay20-Sep-08 12:15 
GeneralRe: Pls pls pls help me been working on it for weeks Pin
yefeng_law20-Sep-08 19:09
yefeng_law20-Sep-08 19:09 
GeneralRe: Pls pls pls help me been working on it for weeks Pin
yefeng_law20-Sep-08 18:46
yefeng_law20-Sep-08 18:46 
QuestionGet refference to active excel instance and callback? Pin
s-p-s20-Sep-08 5:23
s-p-s20-Sep-08 5:23 
Hi all...

I'm writing a small application, that monitors the active excel workbook (The excel window that is currently opened and active). The applicatition then monitors the active-row, get the data from the first coloumb of that row and looks it up in a database.

I have managed to get a reference to excel, using Interop-marshal (see code below), but this only gives me a reference to the first excel workbook opened. If the user switches to another excel workbook, I want to change my reference as well.

Second question: Is there a way to detect if the active-cell has changed. currently I have to read the active-cell continiously to see if it has changed.

Thank you very much, (in advance)
(sorry about my english)

using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;     // Needed for Missing.Value

//Excel Application Object
Excel.Application oExcelApp;

try
{
   //Get reference to Excel.Application from the ROT.
   oExcelApp = (Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");

   debugLabel.Text = "Lookup ID: " + oExcelApp.get_Range("A" + oExcelApp.ActiveCell.Row.ToString(), Missing.Value).Text;

//Release the reference.
oExcelApp = null;
}
catch (Exception)
{
   debugLabel.Text = "Lookup ID: Ikke Fundet";
}

QuestionCapture a link click to open a web page... Pin
devzav20-Sep-08 4:51
devzav20-Sep-08 4:51 
AnswerRe: Capture a link click to open a web page... Pin
#realJSOP20-Sep-08 9:49
professional#realJSOP20-Sep-08 9:49 
QuestionMultiQC & QCFile-LinkA interfacing. Pin
Dinker Batra20-Sep-08 3:26
Dinker Batra20-Sep-08 3:26 
AnswerRe: MultiQC & QCFile-LinkA interfacing. Pin
danmol20-Sep-08 23:33
danmol20-Sep-08 23:33 
GeneralRe: MultiQC & QCFile-LinkA interfacing. Pin
danmol20-Sep-08 23:34
danmol20-Sep-08 23:34 
GeneralRe: MultiQC & QCFile-LinkA interfacing. Pin
Dinker Batra20-Sep-08 23:42
Dinker Batra20-Sep-08 23:42 
Questionretrieve a msaccess column description Pin
djjedi20-Sep-08 2:50
djjedi20-Sep-08 2:50 
AnswerRe: retrieve a msaccess column description Pin
Harvey Saayman20-Sep-08 9:47
Harvey Saayman20-Sep-08 9:47 
GeneralRe: retrieve a msaccess column description Pin
djjedi20-Sep-08 11:04
djjedi20-Sep-08 11:04 
GeneralRe: retrieve a msaccess column description Pin
Harvey Saayman20-Sep-08 11:12
Harvey Saayman20-Sep-08 11:12 
GeneralRe: retrieve a msaccess column description Pin
djjedi23-Sep-08 1:48
djjedi23-Sep-08 1:48 
QuestionHow to save with unique ID Pin
manju#12320-Sep-08 2:25
manju#12320-Sep-08 2:25 
AnswerRe: How to save with unique ID Pin
User 665820-Sep-08 2:39
User 665820-Sep-08 2:39 
GeneralRe: How to save with unique ID Pin
HosamAly20-Sep-08 3:42
HosamAly20-Sep-08 3:42 
AnswerRe: How to save with unique ID Pin
#realJSOP20-Sep-08 9:47
professional#realJSOP20-Sep-08 9:47 
QuestionDid the compiler inline my method? Pin
HosamAly20-Sep-08 2:05
HosamAly20-Sep-08 2:05 
AnswerRe: Did the compiler inline my method? Pin
User 665820-Sep-08 2:41
User 665820-Sep-08 2:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.