|
Hi!
I want to make an Excel 2003 Add-in in C# that, when is loaded by the user, it opens a Form.
I have searched in several sites and until now I only found how to make add-ins that are automatically loaded when Excel starts.
Does anybody can help me?
Thanks!
Paulo
|
|
|
|
|
You should start by reading the content in the Microsoft Visual C# Developer Center[^] for the Office 2003 System. This includes many, many articles and other topics about add-ins and other enhancements to Office using .NET.
The basic idea is that both Office and Visual Studio utilize a DTE (design-time environment) that is very extensible, but you must read the documentation to know how to do it. There are many articles if you look in the right place, and that link above is the best place to start.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi all,
I am getting the following error when trying to update database table:
"Error: Update unable to find TableMapping['Table'] or DataTable 'Table'.
Here is the code snippet that is throwing the error (specifically, the Update() command )
if (upDateFlag)
{
//update
SqlConnection dataConnection = new SqlConnection("Integrated Security=true;" +
"Initial Catalog=SPIRIT2TEST;" + "DataSource=TECHSERVER") ;
SqlDataAdapter adap = new SqlDataAdapter("SELECT * FROM Dept", dataConnection);
adap.Update(changedDataDs, "Dept");
ds.AcceptChanges();
}
catch (Exception e)
{}
Can you please point out what I might be doing wrong...
Thanks
|
|
|
|
|
According to this snippet, you have no SqlDataAdapter.UpdateCommand, InsertCommand, or DeleteCommand. How do you expect the SqlDataAdapter.Update call to update the database based on the connection and changes in changedDataDs? You need to either assign the appropriate SQL statements with the properties I mentioned above, or use a SqlCommandBuilder when you specify the fields (instead of an asterisk in your SELECT statement).
Also, you don't need to call DataSet.AcceptChanges after calling SqlDataAdapter.Update, since Update calls AcceptChanges for you.
Finally, just because your SELECT statement includes "Dept" for a table doesn't mean that changedDataDs does. This is most likely the source of your exception, though even if it did contain the "Dept" table the lack of UPDATE, INSERT (typically separated by a semi-colon along with a SELECT to make sure auto-assigned fields are filled-in correctly), and DELETE commands would also throw an exception.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
In a winapp i embed a web browser control and a richtextbox control,for one way i use :"richTextBox1.Text=((mshtml.HTMLDocument)axWebBrowser1.Document).documentElement.innerHTML " to get html file to richtextbox, after modify this content ,how can i get it to mshtml?
|
|
|
|
|
Cast AxWebBrowser.Document to UCOMIPersistFile (a COM interface declared in .NET in the System.Runtime.InteropServices namespace; casting a COM-imported interface performs a QueryInterface for it) and use the Load method:
richTextBox1.SaveFile("temp.html",
RichTextBoxStreamType.UnicodePlainText);
UCOMIPersistFile file = (UCOMIPersistFile)axWebBrowser1.Document;
file.Load("temp.html");
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Do the method you give above work like this :richtextbox->file->be loaded in
axWebBrowser?
Every time the browser want get the content of richtextbox,it should first convert
to .html file?
are there some differences with underside?
richtextbox1.SaveFile("temp.html", RichTextBoxStreamType.UnicodePlainText);
object oEmpty =null;
axWebBrowser1.Navigate("temp.html", ref oEmpty, ref oEmpty, ref oEmpty, ref
oEmpty);
|
|
|
|
|
You said you copied the actual HTML into the RichTextBox, so I can only presume that the RichTextBox contains HTML markup. In this case, you can do exactly what I told you that you can do, or you can use Navigate or Navigate2. Either way works. If you understand COM and read Programming and Reusing the Browser[^], you'd see that the coclass for IHTMLDocument also implements IPersistFile, which is declared in .NET as UCOMIPersistFile as I said before.
If you're looking for something to convert RTF to HTML, then you should use google[^] to find such a component (or, for internal applications where you have control over system dependencies, you can interop and use Word). Nothing in the .NET BCL (base class libraries) provides such functionality.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
now i think to save html file to memorystream,then to load it to axWebBrowser,how can get it?thank you again!
|
|
|
|
|
IIRC, WebBrowser.Document also implements the IPersistStream interface, but some work will be required. Not only do you have to declare the IPersistStream interface correctly (don't forget the right IID in the GuidAttribute and use the ComImportAttribute), but also the IStream interface, which you'll need to implement in a class that can read from a MemoryStream - basically used to transfer the buffer as the WebBrowser will request it from the IStream interface.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
i declare the IPersistStream interface as below:
public interface IPersistStream
{
[PreserveSig]
int IsDirty( );
void Load([In] UCOMIStream pStm);
void Save([In] UCOMIStream pStm, [In, MarshalAs(UnmanagedType.Bool)] bool fClearDirty);
void GetSizeMax(out long pcbSize);
};
the i implement it form WebBrowser as below:
IPersistStream file = (IPersistStream)axWebBrowser1.Document;
But VS.net said it's not valid,why?
|
|
|
|
|
Don't forget that you need to attribute imported COM interfaces with the ComImportAttribute, otherwise casting will be type casting instead of QI'ing for the COM interface.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
ye,i declared it :
[ComImport,InterfaceType(ComInterfaceType.InterfaceIsIUnknown),Guid("00000109-0000-0000-C000-000000000046")]
|
|
|
|
|
This time i tried IPersistStreamInit Interface,and get convertion form webbrowser to IPersistStreamInit,i think maybe the axWebBrowser1 implement IPersistStreamInit not IPersistStream.MSDN said:This interface is not derived from IPersistStream; it is mutually exclusive with IPersistStream. An object chooses to support only one of the two interfaces, based on whether it requires the InitNew method.
|
|
|
|
|
Yes, that does seem to be correct. It's been a while since I had to do this in our product, and I do realize that IPersistStream and IPersistStreamInit have no relation to each other.
Good find.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Now,the webborwser implement the IPersistStreamInit(has declared) by:
IPersistStreamInit file = (IPersistStreamInit)axWebBrowser1.Document;
and have get the memorystream by:
Stream myStream=new MemoryStream();
richTextBox1.SaveFile(myStream,RichTextBoxStreamType.UnicodePlainText);
this time,can load file by file.Load(UCOMIStream pr);
But now problem is :Load mothod need UCOMIStream as a parameter,but now we just have myStream,how can i do? thank you very much!
|
|
|
|
|
As I mentioned before, you'll need to implement UCOMIStream in your own Stream derivative (or, really, any class). That class should take a reference to another Stream and basically wrap the methods. It's really not too difficult, even though the way in which data is read and written is a little different and because UCOMIStream has some methods that won't easily map (like Stat), but you could probably just ignore any specific implementation for those particular methods (I did some time back and it worked fine).
Of course, if you encapsulate a Stream derivative like FileStream, you could encapsulate every method of UCOMIStream, but that is pretty limiting. You could always do some type checking on the Stream that your implementation references, but if you're doing this for a specific purpose and don't plan on using it for anything else in your project, I wouldn't bother.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I need to either send a Ctrl + K or Alt key combos to walk through the menu of a Citrix Application. Sendkeys does not work. Keybd_event does not work. I can't get SendInput to work at all.
Using Keybd_event I created a app that sent a alt key with no Keyup. I can open any program and it responds as if I have the alt key deppressed except Citrix apps. I can press the Alt key on the keyboard and it works fine.
Will SendInput solve my problem? If so what am I doing wrong?
namespace SendInputTest
{
public struct INPUT
{
public int type;
public KEYBDINPUT ki;
}
public struct KEYBDINPUT
{
public ushort wVK;
public ushort wScan;
public uint dwFlags;
public uint time;
public IntPtr dwExtraInfo;
}
public class Form1 : System.Windows.Forms.Form
{
[DllImport("User32")]
private static extern int SetForegroundWindow(int hwnd);
[DllImport("User32")]
private static extern int FindWindow(string ipClass, string ipWindowName);
[ DllImport("user32.dll") ]
static extern int GetForegroundWindow();
[ DllImport("user32.dll") ]
static extern int GetWindowText(int hWnd, StringBuilder text, int count);
const int nChars = 256;
[ DllImport("user32.dll", SetLastError=true) ]
public static extern int SendInput(int nInputs, ref INPUT[] pInputs, int cbSize);
[ DllImport("user32.dll") ]
public static extern int GetMessageExtraInfo();
[ DllImport("user32.dll", SetLastError=true) ]
public static extern void keybd_event(byte bVk, byte bScan, uint dwFlags, uint dwExtraInfo );
const int KEYEVENTF_KEYUP = 0x0002;
const int KEYEVENTF_SCANCODE = 0x0008;
const int INPUT_KEYBOARD = 1;
private void button1_Click(object sender, System.EventArgs e)
{
int hWND = 0;
int handle =0;
hWND = FindWindow(null,@"Untitled - Notepad");
do
{
handle = GetForegroundWindow();
SetForegroundWindow(hWND);
}while (hWND != handle);
unsafe
{
int rs = 0;
INPUT[] input = new INPUT[1];
input[0].type = INPUT_KEYBOARD;
input[0].ki.wVK = 0x41;
input[0].ki.wScan = 0;
input[0].ki.dwFlags = 0;
input[0].ki.time = 0;
input[0].ki.dwExtraInfo = IntPtr.Zero;
System.Threading.Thread.Sleep(2000);
rs = SendInput(1, ref input, sizeof(INPUT));
input[0].ki.dwFlags = KEYEVENTF_KEYUP;
rs = SendInput(1, ref input, sizeof(INPUT));
}
}
}
|
|
|
|
|
First off, you don't need to declare an unsafe context (forces unverifiable code, leading to additional code access security constraints) if you just use the Marshal.SizeOf method; or - better yet - just hard-code it in (it's not like it changes often).
Are you actually getting the HWND (as an IntPtr) for Citrix WinFrame? Also, are you actually trying to pass this through WinFrame to a remote application? You should consult the Citrix developer API documentation. Citrix may hook keyboard and mouse operations in order to forward them to the remote host. Simply sending messages or input directly may not work (depending on how they handle keyboard and mouse input). This would seem to be the case even more so since you've mentioned that your example code works for other applications that would be running locally (instead of inside a virtual frame buffer).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thanks for the suggestion. The HWND is the actuall Citrix WinFram. I can send text to it using sendkeys and keybd_event but not Alt and Ctrl. I've been reading "In Search of the Lost Win32 API" (because as my code reflects I know very little about Win32 API) and I think I'm going to try postmessage() API. I found a reference to this on the citrix website also.
|
|
|
|
|
I just noticed that all you're doing is sending 'A' (0x41). Have you tried OR'ing it with Shift (0x10) or Ctrl (0x11)? This is the most common approach. You can also use and cast the Keys enumeration defined in .NET to do this, since - for good reason - it uses the same values as the VK_ constants:
byte b = (byte)(Keys.Control | Keys.A);
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Before I got to the complicated stuff I just wanted to send a simple 'A' to notepad. I can not get SendInput() to work or PostMessage() using WM_KeyDown and WM_Keyup to work. I used Spy++ and nothing is being sent. I did however figure out PostMessage using WM_MenuSelect with WM_Command which allows me to just select the menu item instead of sending keystrokes but, this will not pass through Citrix either. I looked at the Citrix COM and it is just interfaces and no code. I setup the keyboard interface with the Citrix COM but still no luck because with the interface you still have to define keyup and keydown.
This is my solution as ragtag as it may be. I have a small app runing through Citrix used as a relay. On the local side when a barcode is scanned it activates the local app which relays the barcode info to the app running through Citrix this way when the remote app activates it sends all the commands to the (very expensive but disfunctionally hard to use Medical Record program)(After all we are talking about doctors here) on the server side and everything works. I must say there is some good stuff in the Win32 API.
|
|
|
|
|
As I mentioned before, any messages you send or post to the Citrix WinFrame is only sending it to the host application. What that application does with them is a different story (and it obviously doesn't pass them on). That's why I mentioned looking at their developer APIs (if available). It may use a keyboard and mouse hook to intercept and transfer input, but posting and sending messages that do the same thing may not.
Surely there must be a developer forum (web-based, newsgroups, mail lists, etc.) somewhere for Citrix WinFrame (either official or unofficial). That would definitely be a good place to start; otherwise, such a "ragtag" workaround may be your only bet.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I finally got it. PostMessage works with WM_Keydown and WM_Keyup but you must make wParam and lParam type UIntPtr. Thanks for your help. No "ragtag" required!
|
|
|
|
|
Just a quick question,
Is there any way in the Framework that my application can get an event when Windows jumps into and out of full screen mode (EG, a full screen DX or OpenGL application starts/ends)? And if not, is there anything in Win32 to achieve this?
I am aware of the notification in Shell32 for Application Desktop Toolbars, however, that would mean creating a Desktop Toolbar?? Is there any other way?
Thanks!
--
Rob Hutchinson.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
