|
I'm working on an excel application with data validation in it. The boss insists we use form controls such as checkbox or radio button. Is there any way to integrate these into an excel spreadsheet through COM Interop? If so, please provide an example or post a link. Also, we need to read the excel spreadsheet back through COM, so the controls need to be accessible later.
-- Steven Hunt
|
|
|
|
|
Have you ever heard of Microsoft Visual Studio Tools for Office (VSTO)? It allows one to automate Excel documents using .NET (in C# or VB). It supports dragging-and-dropping WinForms controls onto the worksheet. In addition, you can cache arbitrary data (e.g. the state of the controls) within the document and retrieve them outside of the Excel host environment.
For more information: Visual Studio Tools for Office
-Phil
Disclaimer: I work for Microsoft as a developer on the VSTO product team.
|
|
|
|
|
|
Hello friends,
i don't know anything about COM like how to create or use...Can anybody help me to find the right way to do it.
For example in my project i have a class that deals with all db operations i want to make it as com and use this in some other project please anybody help me ..
Regards
Alex.
|
|
|
|
|
|
Hello,
'COM+ Programming: A Practical Guide Using Visual C++ and ATL (With CD-ROM) by Pradeep Tapadiya' is much better. (See amazon.com)
Regards
|
|
|
|
|
I have a problem that I have not been able to resolve. I have a C# exe where I have exposed some interfaces. My problem is that every call to createobject creates a new instance of the application. What I need is one running application from which a client can connect to.
Scenario 1:
Application is launched from command line.
User connects to existing running application using createobject (this does not work...it creates another instance)
Scenario 2:
Application is not running
User run createobject to connect to launch application. App launches (however if another program does a createobject it creates yet another instance).
I have not found anything in my searches that have helped.
Someone please shed some light on this!
Thanks,
Loren
|
|
|
|
|
Hello,
Just check 'DECLARE_CLASSFACTORY_SINGLETON(...)' macro on MSDN.
Regards
|
|
|
|
|
Thanks...is there an equivalent C# implementation? My EXE is a C# program.
Loren
|
|
|
|
|
Hi, folks.
A VC++ project I'm working on was doing fine in VS 2003. However, under VS 2005 IInputObject is behaving erratically. Specifically, UIActivateIO gets called only when fActivate is false (toolbar losing focus), never when it's true (gaining focus).
More importantly, however, is that TranslateAcceleratorIO now never gets called at all. This makes it impossible to get user input from edit or combo controls on the toolbar.
Anyone else experiencing IInputObject adventures in VS 2005?
|
|
|
|
|
Hi All,
I need to write some Composite control in my ATL using com technology project.
My question is how i control the GUI ?
What I mean is - in MFC i define some control variable that i can control the GUI control in easy why - can i do it also in Composite control ?
Until now i use "ListView_SetColumn" or those command to change/add/find something in my list Control - but this way is not the simple way - does there is some simple way to use the control ?
I also could not do casting from the control the list view type.
Thanks for any help.
|
|
|
|
|
I have spent much time to do this but i can NOT complete.
I can Not take the control of Standard Toolbar of Microsoft Outlook ( Not Outlook Express ).
I hope to receive Comments from from other plz
(Sorry for my bad english :P)
|
|
|
|
|
I have an unmanged MFC project, in which we plan to add a MS Visio control.
Now, I can bring Visio out, set its properties. But I cannot find a way to add events?
Can anyone help me?
By investigation of Visio SDK, we found something like:
vaoGetObjectWrap(app)
app.EventList(eList)
eList.AddAdvise(....)
Seems there is a way to do it. But I cannot find any code samples that actually work.
Can anyone help, please.
|
|
|
|
|
hi all,
I have a series of JPEG file coming from a source. I have to create a MPEG file from the series of JPEG file, which can be played in Media Player. How can I do this. What algorith i have to use or else i have to use COM and ActiveX control for the same. Can u give any idea regarding this.
Thanks and Regards
Yudhisthira Attry
|
|
|
|
|
Hello!
How I can create COM+ application in Component Services->Computers->My omputer->COM+ Application->[My COM+ App] from my own program?
How I can run commands 'Shutdown', 'Start' and 'Disable' for my COM + Application?
Is it possible?
Please, help me if somebody know..
Thanks..
-- modified at 5:49 Tuesday 27th March, 2007
|
|
|
|
|
Is there a way to access a COM component without knowing it's ClassID?
----------------------------
286? WOWW!
|
|
|
|
|
This is not the case: a CLSID is just one object discovery/creation mechanism. As another poster pointed out, another mechanism is the ProgID. Another is monikers (see the IMoniker interface). There are more, not counting ones you invent yourself.
-- modified at 1:28 Tuesday 27th March, 2007
It seems the post this was a reply to has been deleted; this was not a response to _8086’s post as looks like is the case. I must say it’s a little weak to delete a post just because someone replies and corrects you, especially when it destroys the flow of the thread.
Steve
|
|
|
|
|
Depends on what you mean with "access a COM component without knowing its ClassID".
You have to know something about it, if you want to create an instance of it...
If you know the ProgID you can get the ClassID with ::CLSIDFromProgID().
It could be a component that is registered as a member of a component category, which means that it expose interfaces that components of that category have to expose. Enumerating the members of a category will get you the ClassID for each component in that category.
But if don't want to create an instance of the component, you would only need to know one of the interfaces it exposes and get an interface pointer from another client of that instance.
Probably a confusing answer to a somewhat confusing question... :->
Post again and describe what you mean more clearly if the above doesn't help.
"It's supposed to be hard, otherwise anybody could do it!" - selfquote
"High speed never compensates for wrong direction!" - unknown
|
|
|
|
|
Hi,
I am using the MS Word 9 object library and I would like to convert a Word document into html format using the code below. However, my .Net application does not recognise the wdFormatHTML file format.
I just don't know what to do about this and would really really appreciate any help on this.
Please help.
Kind regards,
Polly Anna
Dim strFileName As String
Dim objWordApplication As New Word.Application
Dim objDocument As New Word.Document
strFileName = pstrPathName & "\" & pstrDocumentName
objDocument = objWordApplication.Documents.Open(strFileName)
objDocument.Activate()
objDocument.Bookmarks.Add("TestBookmark2")
objDocument.SaveAs (FileName:="DOCUMENTNAMEHERE.htm",FileFormat:=wdFormatHTML, EmbedTrueTypeFonts:=False)
|
|
|
|
|
is word k.document
k.html inverted to html
////////////////////////
string filePath = "D:\\k.doc";
Word.ApplicationClass wordApplication = new Word.ApplicationClass();
// Opening a Word doc requires many parameters, but we leave most of them blank...
object o_nullobject = System.Reflection.Missing.Value;
object o_filePath = filePath;
Word.Document doc = wordApplication.Documents.Open(ref o_filePath,
ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject,
ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject,
ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject);
// Here we save it in html format...
// This assumes it was called "something.doc"
string newfilename = "k.html";
object o_newfilename = newfilename;
object o_format = Word.WdSaveFormat.wdFormatHTML;
object o_encoding = Microsoft.Office.Core.MsoEncoding.msoEncodingUTF8;
object o_endings = Word.WdLineEndingType.wdCRLF;
// Once again, we leave many of the parameters blank.
// See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/womthSaveAs1_HV05213080.asp
// for full list of parameters.
wordApplication.ActiveDocument.SaveAs(ref o_newfilename, ref o_format, ref o_nullobject,
ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject,
ref o_nullobject, ref o_nullobject, ref o_encoding, ref o_nullobject,
ref o_nullobject, ref o_endings, ref o_nullobject);
// Report success...
// Finally, close original...
doc.Close(ref o_nullobject, ref o_nullobject, ref o_nullobject);
tkml
|
|
|
|
|
Hi Tklem,
yes, that worked a treat.
Thank you very much indeed.
Kind regards,
Polly Anna
|
|
|
|
|
I made a program used mingw to play wave by direct sound.
it's compled but can work ( no sound ).
can any one give me an example of direct sound ? thanks in advance !
here is my program :
#include <io.h>
#include <fcntl.h>
#include <stdio.h>
#include <windows.h>
#include <dsound.h>
static const char* getSndErr(HRESULT hr){
char *p;
switch(hr){
case DSERR_ALLOCATED :
p=" DSERR_ALLOCATED";
break;
case DSERR_CONTROLUNAVAIL :
p=" DSERR_CONTROLUNAVAIL";
break;
case DSERR_BADFORMAT :
p=" DSERR_BADFORMAT";
break;
case DSERR_INVALIDPARAM:
p=" DSERR_INVALIDPARAM";
break;
case DSERR_NOAGGREGATION :
p=" DSERR_NOAGGREGATION";
break;
case DSERR_OUTOFMEMORY :
p=" DSERR_OUTOFMEMORY";
break;
case DSERR_UNINITIALIZED :
p=" DSERR_UNINITIALIZED";
break;
case DSERR_UNSUPPORTED :
p=" DSERR_UNSUPPORTED";
break;
default :
p="Unknown";
break;
}
return p;
}
static LPGUID snd_guid=NULL;
static BOOL OnDSoundDev(
LPGUID lpGuid,
LPCSTR lpDesp,
LPCSTR lpModule,
LPVOID lpContext ){
static int i;
//fprintf(stderr, "Get DSound: %s\t%s\n", lpDesp, lpModule);
fprintf(stderr, "Get DSound device\n");
if( i ) snd_guid= lpGuid;
return i++ == 0;
}
int main(int argc ,char** argv){
if( argc!= 2) return 0;
LPVOID lpPtr1=NULL;//指针1;
LPVOID lpPtr2=NULL;//指针2;
HRESULT hResult;
DWORD dwLen1,dwLen2;
char* m_pMemory=NULL;//内存指针;
LPWAVEFORMATEX m_pFormat=NULL;//LPWAVEFORMATEX变量;
LPVOID m_pData;//指向语音数据块的指针;
DWORD m_dwSize;//WAVE文件中语音数据块的长度;
int file;//Cfile对象;
DWORD dwSize;//存放WAV文件长度;
//~ if(FAILED( CoInitialize(NULL) )) return 0;
//打开sound.wav文件;
file= _open (argv[1],_O_RDONLY | _O_BINARY);
if(file<0) return 0 ;
//get size
dwSize= _lseek (file ,0,SEEK_END);
//为m_pMemory分配内存,类型为LPVOID,用来存放WAVE文件中的数据;
m_pMemory =(char*) GlobalAlloc (GMEM_FIXED, dwSize);
dwLen1=0;
_lseek (file, 0,SEEK_SET);//定位到打开的WAVE文件头;
while( !_eof(file)){
dwLen2=_read(file, &m_pMemory[dwLen1] , dwSize- dwLen1) ;
if( dwLen2<0) return 0;
dwLen1+= dwLen2;
} //while
fprintf(stderr, "Read %d bytes, acturally has %d bytes\n", dwLen1, dwSize);
if( dwLen1!=dwSize) perror("");
_close(file);
LPDWORD pdw=NULL,pdwEnd=NULL;
DWORD dwRiff,dwType, dwLength;
//if (m_pFormat) //格式块指针
m_pFormat = NULL;
//if (m_pData) //数据块指针,类型:LPBYTE
m_pData = NULL;
//if (m_dwSize) //数据长度,类型:DWORD
m_dwSize = 0;
pdw = (DWORD *) m_pMemory;
dwRiff = *pdw++;
dwLength = *pdw++;
dwType = *pdw++;
if (dwRiff != mmioFOURCC ('R', 'I', 'F', 'F'))
return 0 ;//判断文件头是否为"RIFF"字符;
if (dwType != mmioFOURCC ('W', 'A', 'V', 'E'))
return 0 ;//判断文件格式是否为"WAVE";
//寻找格式块,数据块位置及数据长度
pdwEnd = (DWORD *)((BYTE *) m_pMemory+dwLength -4);
bool m_bend=false;
//~ DirectSoundEnumerate( (LPDSENUMCALLBACK )OnDSoundDev, NULL);
//~ do Sleep(100); while( snd_guid ==NULL);
while ((pdw < pdwEnd)&&(!m_bend))
//pdw文件没有指到文件末尾并且没有获取到声音数据时继续;
{
dwType = *pdw++;
dwLength = *pdw++;
switch (dwType)
{
case mmioFOURCC('f', 'm', 't', ' ')://如果为"fmt"标志;
if (!m_pFormat)//获取LPWAVEFORMATEX结构数据;
{
if (dwLength < sizeof (WAVEFORMAT)) return 0 ;
m_pFormat = (LPWAVEFORMATEX) pdw;
}
break;
case mmioFOURCC('d', 'a', 't', 'a')://如果为"data"标志;
if (!m_pData || !m_dwSize)
{
m_pData = (LPBYTE) pdw;//得到指向声音数据块的指针;
m_dwSize = dwLength;//获取声音数据块的长度;
if (m_pFormat)m_bend=TRUE;
}
break;
}
pdw = (DWORD *)((BYTE *) pdw + ((dwLength + 1)&~1));//修改pdw指针,继续循环;
}
DSBUFFERDESC BufferDesc;//定义DSUBUFFERDESC结构对象;
memset (&BufferDesc, 0, sizeof (BufferDesc));
BufferDesc.lpwfxFormat = (LPWAVEFORMATEX)m_pFormat;
BufferDesc.dwSize = sizeof (DSBUFFERDESC);
BufferDesc.dwBufferBytes = m_dwSize;
BufferDesc.dwFlags = 0;
HRESULT hRes;
LPDIRECTSOUND m_lpDirectSound;
hRes = ::DirectSoundCreate(0, &m_lpDirectSound, 0);//创建DirectSound对象;
if( hRes != DS_OK ) return 0;
//~ DirectSoundEnumerate((LPDSENUMCALLBACK)OnDSoundDev, 0);
if( DS_OK !=m_lpDirectSound->SetCooperativeLevel(
GetDesktopWindow(),
DSSCL_EXCLUSIVE
//DSSCL_NORMAL
)){
fprintf(stderr," SetCooperativeLevel err: %s\n", getSndErr(hRes));
return 0;
}
//设置声音设备优先级别为"NORMAL";
//创建声音数据缓冲;
LPDIRECTSOUNDBUFFER m_pDSoundBuffer;
if ( (hRes=m_lpDirectSound->CreateSoundBuffer (&BufferDesc, &m_pDSoundBuffer, 0)) != DS_OK) {
fprintf(stderr," CreateSoundBuffer err: %s\n", getSndErr(hRes));
return 0;
}
//载入声音数据,这里使用两个指针lpPtr1,lpPtr2来指向DirectSoundBuffer缓冲区的数据,这是为了处理大型WAVE文件而设计的。dwLen1,dwLen2分别对应这两个指针所指向的缓冲区的长度。
hResult=m_pDSoundBuffer->Lock(0,m_dwSize,&lpPtr1,&dwLen1,&lpPtr2,&dwLen2,0);
if (hResult == DS_OK){
memcpy (lpPtr1, m_pData, dwLen1);
if(dwLen2>0){
BYTE *m_pData1=(BYTE*)m_pData+dwLen1;
m_pData=(void *)m_pData1;
memcpy(lpPtr2,m_pData, dwLen2);
}
if( DS_OK!=m_pDSoundBuffer->Unlock (lpPtr1, dwLen1, lpPtr2, dwLen2))
fprintf(stderr," unlock err: %s\n", getSndErr(hRes));
else if( DS_OK!= m_pDSoundBuffer->Play (0, 0, 0)) //播放WAVE声音数据;
fprintf(stderr," play err: %s\n", getSndErr(hRes));
} else fprintf(stderr," Lock err: %s\n", getSndErr(hRes));
out:
if(m_pMemory) GlobalFree(m_pMemory);
//~ CoUninitialize();
}
|
|
|
|
|
A question:
running IIS in Windows 2004 64 bit, using COM+ 32 bit components instanced by ASP scripts, is the 3/4 GB limit for EVERY single COM+ component or for the full set of COM+ components?
Does those COM+ components share the same 4GB of global memory?
thanks in advance
Stefano
|
|
|
|
|
I use redemption.dll to work with outlook. When I trying to create any object from this library
hr = CoCreateInstance(rclsid, pOuter, dwClsContext, __uuidof(IUnknown), reinterpret_cast(&pIUnknown));
In hr i have 0x80040154 Class not registered. But in register, class with this CLSID exists.
What the problem is?
|
|
|
|
|
What values do 'pOuter' and 'dwClsContext' have?
Bear in mind that if dwClsContext is too restrictive, you can't launch the server.
Steve S
Developer for hire
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
