|
Would it not be better to use the Office Object Model and open the workbooks from Excel? You would have more control over the process that way.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Only problem is, even if you make sure and call System.InteropServics.Runtime.Marshal.ReleaseComObject() on each and every little object you access with the object model, and call all the cleanup functions of the object correctly, one still finds little EXCEL.EXE's hiding around when you open up Task Manager.
I think it's maybe a COM Subsystem thing, where the system likes to leave the server EXE hanging around when you use COM objects from it -- even if they're properly released -- so that there's less latency the next time you make COM method calls from that same EXE. However, if you're cleaning up Excel every time your application is run and you don't want to have these little orphan instances of EXCEL.EXE hanging around, well, then you want to add this little piece of code back in to your cleanup method:
foreach(System.Diagnostics.Process proc in System.Diagnostics.Process.GetProcessesByName("excel.exe"))
proc.Kill();
It's not immediately obvious what order the processes come out in. I guess you'll just have to think of a way you can inspect each entry. In the meantime, though, foreach does in a pinch.
Sincerely Yours,
Brian Hart
|
|
|
|
|
I suspect that Mark isn't going to have to think too hard on this, but the OP might instead.
|
|
|
|
|
Push your processes into a Stack and kill them when you're done in the same order you pop them from the Stack.
|
|
|
|
|
Actually a better method is to use the COM Excel application Quit method. You can also set the DisplayAlerts property to true or false depending if you want to get prompted for unsaved files.
Thank you for your input.
Glenn
|
|
|
|
|
Hi guys, i try to send data directly to host MAC address(without using IPAdress). I am not a expert in network programming am just a beginner.
In my search i found some ideas, that is we can use
"SocketType.Raw" in socket to achieve this. But i cant understand it.
Another thing is i need to acheive this without NDIS Protocol Driver.
somebody pls explain me how to do it...is there any class or utility is avilable in .NET.
Thanks in advance
ganesh_IT
modified on Monday, December 13, 2010 4:53 AM
|
|
|
|
|
I think you should Google send raw Ethernet packet
|
|
|
|
|
Why are you trying to do this? Perhaps if you explained the problem you are trying to solve, we could offer alternatives.
|
|
|
|
|
You can't use the MAC address for application level comm. There are no application-level protocols that work with the data link layer.
So you're trying to do this with a protocol driver? Forget it - not possible.
What are you attempting to do with this?
|
|
|
|
|
I am trying to do this for a academic project.
Why we cant access the link layer.
What i need to do for done this project explain me i can achieve this....
Thanks in advance
ganesh_IT
|
|
|
|
|
I didn't say you couldn't get at it. I said there are no application level protocols that can.
You'd have to talk directly to the device driver through any interface it supports, but probably using DeviceIo calls. Without documentation on the driver itself, you'll get absolutely nowhere very fast.
ganesh_IT wrote: What i need to do for done this project explain me i can achieve this....
Achieve what? You haven't said anything about your project is about at all or why you think you need Link layer access to the NIC.
|
|
|
|
|
Hi,
I am using the App.Config in my windows form application.. I want to to ask if it will be complied within the EXE or I have to copy it in my my setup project?
|
|
|
|
|
It's a separate file.
In your Debug/Release folder it's named "<yourapp>.exe.config".
Cheers
I don't like my signature at all
|
|
|
|
|
This is a absolute basic question on the foundations of .NET applications. As has been noted before you have asked a considerable amount of basic questions and you have been given the advice to read some books or take a class and learn the basics properly, not stumbling around. Please take this advice.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi
I have a VS 2008 solution with two projects inside and I am want to deploy it... both will be deployed in a folder called C:\Program Files\My Projecr in Project-1 and Project-2 folders..
Both projects use shared assemblies like the MySQL DLLs.
Do I have to copy the same assemblies twice? once in Project-1 and again in Project-2?
|
|
|
|
|
Typically, shared assemblies are placed in the GAC, only a single copy. You can also create a common folder to place the shared assemblies for your applications but you will need to direct the .NET framework as to where to find them.
You may want to read through this
How the Runtime Locates Assemblies[^]
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
so how can I place all in Common folder in my application folder and redirect the .NEt framework? can you please guide..
hanksT
|
|
|
|
|
Did you even read my response? Did you follow the link?
Stop asking questions here and go learn
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Put these dll's in the GAC.
You can share them across both projects.
You dont need to copy these DLL's if they are already available in the GAC.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
Visit the Hindi forum here.
|
|
|
|
|
Hello Experts,
I would like to ask a few guidelines in making an internet cafe software, I am kinda confuse if where should I start first.
Do I need to start from the client part or the server part. I am planning to use vb.net and sql server/ms access for the database
since I have use it in my previous project. I have created a project using vb.net and sql server in my past project and I wanted to try higher steps by doing network software. Any suggestions to help are kindly appreciated.
Thanks in advance,
DAN
|
|
|
|
|
I would suggest you start by writing down your specifications and how he timer will be used. Then what should be client and server will likely be obvious.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
In additional to Walt's advice, for technology I would certainly be using SQL Server. You could start with SQL Express (its free) and upgrade when necessary much easier than starting with Access. As for language, and without starting a religious debate, IMO C# would be more appropriate. I believe there are more and better code samples available for you to learn from. Also since most network applications were, or still are, written in C++, the code is of better quality and it would be easier to translate to C# rather than VB given the similarities in syntax and structure between C++ and C#.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hello experts,
Thanks for all the suggestion and helpfull reply. Although I am not that good in c++ since vb is the 1st language
were I can use database on it I will give a shot on c++/c#.
Thanks,
DAN
|
|
|
|
|
I'll agree with Mark and Walt, but add my two cents worth. If I understand your question, you want a timer on the connections to an Internet Cafe application. I assume you want to charge for access by the minute, or some finite time chunk. You'll need to create a connection pool from which users "check out" connections for a period of time. To my thinking, the proper place to implement the timer is on the server side, as each connection is established. When a user pays the fee, a connection is enabled and the timer started. When the timer completes, the server is notified of the connection associated with it, and the server should suspend the connection and ask for more money. If the user declines, or fails to respond (having packed up and walked away), the server then closes the connection and returns it to the pool.
As has been mentioned, with a project this (potentially) complex, you really need to develop a detailed specification first, even if just for your own use. You're going to get quickly overwhelmed by the details if you don't have a clear roadmap to follow.
Will Rogers never met me.
|
|
|
|
|
Hi,
How to hide print option for pdf files in document library in sharepoint 2007.
|
|
|
|