Excel late binding - COM Discussion Boards

How to specify a sound card in windows media player

31-Aug-05 21:42

I want to write a service which will notify if any new file is generated in particular directory. How can i trap this event in Atl service

Re: ATL Service

logicaldna31-Aug-05 22:47

logicaldna

31-Aug-05 22:47

plz check

http://www.codeproject.com/file/filemonitor.asp[^]

You will get source and test project for ATL

Excel late binding

Anonymous31-Aug-05 21:21

Anonymous

31-Aug-05 21:21

Hey,
I'm using late binding for Excel and I have problem with calling Open (Workbooks) method.
Some other method (properties) work just fine (I'm using Office XP).

Code:

<br />
objWorkbooks = excel.GetType().InvokeMember("Workbooks",BindingFlags.GetProperty, null, excel, null);<br />
<br />
object[] oParam= new object[13]; //i also try 1(optional) and 11(office 2003) params<br />
oParam[0] = FileName;<br />
for(int t=1; t < parameters.Length; t++)<br />
  oParam[t] = Type.Missing; //a also try to put some valid params (like in early binding)<br />
<br />
//here I get error<br />
objWorkbooks.GetType().InvokeMember("Open",BindingFlags.InvokeMethod, null, objWorkbooks, oParam);<br />
<br />

And exception is: "Additional information: Exception has been thrown by the target of an invocation."

Tnx for helping me.

Nice day,
David

SOAP quetsion

logicaldna31-Aug-05 19:03

logicaldna

31-Aug-05 19:03

plz tell me how to access a dll on a server from a client side VB application

I am able to access ASP service from vb app. through SOAP
but how to do this with .dll

plz help

Thanks in advance

JaniceA29-Aug-05 23:08

JaniceA

29-Aug-05 23:08

I want to specify a sound card for windows media player but keep the windows default sound card unchanged (i.e., windows use another sound card). By the use of DirectSound, I can enumerate all sound cards in my system.

So, after I obtained the GUID of the sound cards, how can I specify a GUID for the windows media player? Also, how can i specify another GUID for the system as its default sound card?

Thanks for your kindness help!!!

-- modified at 5:09 Tuesday 30th August, 2005

Really struggling with GetTypeFromProgID

DaveC42691329-Aug-05 8:11

DaveC426913

29-Aug-05 8:11

Trying to get a VB app to run Windows Media Services on a remote machine.

This code
tServerType = Type.GetTypeFromProgID("WMSServer.Server", <myserver>, True)

generates this error
System.Runtime.InteropServices.COMException (0x800401F3): Invalid class string
at System.RuntimeType.GetTypeFromProgIDImpl(String progID, String server, Boolean throwOnError)
at System.Type.GetTypeFromProgID(String progID, String server, Boolean throwOnError)

I really need help with how to configure my local and my remote machine to talk to each other.

HELP!!

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Jörgen Sigvardsson29-Aug-05 9:00

29-Aug-05 9:00

"WMSServer.Server" is an invalid ProgID. Have you registered the component/proxy locally? (I have no idea how Windows Media Services work, but you mention "remote machine", so I assume you're using DCOM. Then you need to either have the components or the proxy registered on your client machine)

Good music: In my rosary[^]

DaveC42691329-Aug-05 10:03

DaveC426913

29-Aug-05 10:03

I'm pretty green with this stuff.

I am using DCOM, yes.

I am developing on the client machine right now, so I would expect that, yes, they are registered.

"WMSServer.Server" is an invalid ProgID. Should it be the GUID?

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Jörgen Sigvardsson29-Aug-05 19:53

29-Aug-05 19:53

DaveC426913 wrote:
"WMSServer.Server" is an invalid ProgID. Should it be the GUID?

Nah. ProgIDs and CLSIDs (Class ID which is a GUID), are mostly interchangeable. GUIDs are unique, but ProgIDs aren't [edit]necessarily, but are most of the time. (I have yet to encounter two identical ProgIDs for different components!)[/edit]

What the error says is that the component isn't registered on your computer. Not as implementation nor as proxy. You need to investigate further on that.

-- modified at 1:53 Tuesday 30th August, 2005

ActiveX Control's Bitmaps in ToolBox

DaveC42691330-Aug-05 2:59

DaveC426913

30-Aug-05 2:59

"What the error says is that the component isn't registered on your computer. Not as implementation nor as proxy. You need to investigate further on that."

Would that be on the server wherer the service is, or on the client where the app is running?

It's got to be registered somehow - it is already in use when I started developing on these boxes.

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Ashwin kumar Gurujala27-Aug-05 1:53

27-Aug-05 1:53

Hi,
I want to know whether there is any API to show Bitmaps of Registered ActiveX Controls in a ToolBox. If not , any idea on how to go about...

Jörgen Sigvardsson27-Aug-05 13:22

27-Aug-05 13:22

Last time I checked, I could not find one. I used the registry to extract that information.

Good music: In my rosary[^]

Ashwin kumar Gurujala28-Aug-05 19:55

28-Aug-05 19:55

can you just code it in brief on how to show bitmaps from registry.
This is useful to me since i have no idea on how to do it.

Jörgen Sigvardsson29-Aug-05 9:16

29-Aug-05 9:16

The components registry "folder" is located in HKEY_CLASSES_ROOT\CLSID\{<clsid here>}.
Under that key is the ToolboxBitmap32 key. The default value of that key is the toolbox bitmap. The string value is on the form module,id. Parse the module and id into their own variables.

Then open the module using LoadLibraryEx(), using the LOAD_LIBRARY_AS_DATAFILE option. Then use the function LoadBitmap with the handle returned from LoadLibraryEx(), and the id "transformed" with MAKEINTRESOURCE().

Pseudo-code:

LPCTSTR lpszToolboxBitmap32 = GetToolboxBitmap32ForCLSID(clsidOfComponent);
LPCTSTR lpszModule;
int     nId;
ParseBitmapString(lpszToolboxBitmap32, &lpszModule, &nId);
 
HMODULE hLibrary = ::LoadLibraryEx(lpszModule, NULL, LOAD_LIBRARY_AS_DATAFILE);
HBITMAP hBmp = ::LoadBitmap(hLibrary, MAKEINTRESOURCE(nId));
::FreeLibrary(hLibrary);
 
// the handle to your bitmap is now in hBmp

I hope this helps.

Good music: In my rosary[^]

Ashwin kumar Gurujala1-Sep-05 1:37

1-Sep-05 1:37

Thanks for the Solution,

One problem how can i pass handle of bitmap to object of CBitmap.... or is there any other way of using it....

HBITMAP hBmp;
hBmp = ::LoadBitmap( hLibrary, MAKEINTRESOURCE(nID) );

//! Here LoadBitmap Accepts HICON & CBitmap*...but not HBITMAP..So how can I pass HBITMAP to CImageList so that it can be attached to CToolBar

CBitmap obBitmap;
obBitmap.LoadBitmap( hBmp ); //error...how to pass hBmp

CImageList obImageList;
obImageList.Create(18,18,ILC_COLOR8,2,1);
obImageList.Add( &obBitmap , RGB(0,0,0));

CToolBar obToolBar;
obToolBar.GetToolBarCtrl().SetImageList(&obImageList);

-- modified at 7:43 Thursday 1st September, 2005

Jörgen Sigvardsson1-Sep-05 9:48

1-Sep-05 9:48

CBitmap is just a C++ wrapper for HBITMAP. Use CBitmap::FromHandle() to acquire a CBitmap object. It returns a CBitmap*, but you don't have to free it. The returned pointer is a pointer to a temporary object, which is removed next time the window pump is idling. So in short, use the pointer on the same call stack as you acquired it. Please see the MSDN docs for a more comprehensive explanation. Smile | :)

Good music: In my rosary[^]

Ashwin kumar Gurujala9-Sep-05 0:02