|
OK, VC is far from what I can tell you about, but a first (language-independent) idea for getting the MSOffice-File might be to query the running processes and check for the respective process' ProcessName and MainWindowTitle properties.
In VB.NET and for Excel it could be like
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ProcessList As System.Diagnostics.Process()
Dim Proc As System.Diagnostics.Process
ProcessList = System.Diagnostics.Process.GetProcesses()
For Each Proc In ProcessList
If Proc.ProcessName = "EXCEL" Then
Debug.WriteLine(String.Format("Name {0} ID {1}", Proc.ProcessName, Proc.Id))
Debug.WriteLine(String.Format("Main Excel worksheet is {0}.", Proc.MainWindowTitle))
End If
Next
End Sub
For listening to Offices events (e.g. when 'SaveAs' dialog is opened) I'm afraid you might have to write a 'COM-AddIn'. Just Google for that keyword, there are good C++ samples available which you can easily adapt to your needs (with or without VSTO). Be aware that the COM-AddIn has to be registered on the target machine, so you would need administrator access rights to install it.
If you write a COM-AddIn, then of course the first part of this is obsolete. Within an AddIn you can reference the Microsoft.Office.Interop libraries and access the Office-Applications as objects, exposing their vast number of members.
Hope that helps you a bit.
Regards to Beautiful India from Germany 
|
|
|
|
|
Thanks Michael Schäuble.
Your suggestions seems to be interesting and useful.
Will try it...
Regards from India
Dinakara K
CAIR, Bangalore
|
|
|
|
|
I added some resourses in VS2008 (vb project). I have reinstall OS(XP).
The resources that already added that can be accessed and return valid string but
newly added resources return Nothing. All of the resource are String type.
For example:
Dim xx = My.Resources.NoRisk
'It returns string "No Risk to access this drive:" <br>'But after Reinstalling XP i added 'StartupReg' in resource with this string <br>''SOFTWARE\Microsoft\Windows\CurrentVersion\Run'
xx = My.Resources.StartupReg
'Return Nothing where it should Return 'SOFTWARE\Microsoft\Windows\CurrentVersion\Run'
Anyone have any solution?
|
|
|
|
|
Try Cleaning the project then recompiling. You may want to repair Visual Studio and the .NET Framework if that doesn't work.
|
|
|
|
|
I've install vs2008 5th july. Clean solution and Rebuild solution i did all.
I do manualy clean obj folder. but that problem is not solved.
There are 2 project in that solution. 2nd have no problem to retrive value from resource even a new one.
Anyother options left what should i do?
Thanks 
|
|
|
|
|
I have no idea. I've never heard of the problem before. I can't even replicate it...
|
|
|
|
|
This is twice in my life. anyway thanks.
I solved that creating a new project and add old forms and classes and all other components.
I have no other choice.
|
|
|
|
|
I want to communicate with a Finger Print Machine but no SDK /APIS is provided by the client bcz vendor wants to sell SDK separately , its Pinging but how i can send and receive data without having any SDK or manual.
Is there any way that i can communicate with any machine and can send and receive thumb impressions without having any SDK or manual.
If so then is not it like developing a VIRUS/Trojan or something. 
SOFTDEV
Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.
modified on Wednesday, July 7, 2010 7:45 AM
|
|
|
|
|
You need to speak to the manufacturer or distributor of the device.
Steve Jowett
-------------------------
Real programmers don't use PL/1. PL/1 is for insecure momma's boys who can't choose between COBOL and Fortran.
|
|
|
|
|
You'll have to contact the manufacturer of the device for the SDK. There is no getting around this.
Also, where did you get this thing from? Every fingerprint scanner I've seen always came with a copy of it's SDK.
|
|
|
|
|
Actually the Manufacturer is selling SDK separately three times more then the Price of the Machine and client does not want to pay
SOFTDEV
Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.
|
|
|
|
|
Then client doesn't get their solution, now do they?
The manufacturer has you over a barrel. You can try a third party library, but you're not going to get the full functionality of the scanner. You can find some by Googling for "fingerprint sdk free[^]".
|
|
|
|
|
Hi everybody,
I'd like to make a little application to handle 3rd party gauges. These are basically C/C++ dlls, so it seems that I have to find out their entry points and members first. One major thing would be to simply show the bitmaps, which they provide for the GUI in the game (MSFS), inside my application.
Does anyone know a way how to do something like retrieving member and resource information from an unknown dll in VB.NET (or C#)?
Thank you
Michael
|
|
|
|
|
|
Thank you, I'll go google for these tools.
|
|
|
|
|
|
This seems to be a really cool tool for the initiated ... giving me what I asked for and showing me how far I am from "making a little application" with display support.
At least the dlls in question obviously don't expose any bitmaps, but only "ImportTable" and "Linkage" functions which both belong to a world of C-language and the 7 seals...
Thank you still!
|
|
|
|
|
Hi Friends,
I wanted to convert excel sheet data to xml using VBA.
Kindly help me.
Thanks in advance.
Regards,
Priya.
|
|
|
|
|
A quick search found this article clickety[^]
|
|
|
|
|
Hi,
I have this table
Accessories table
(ID, description, date, ArmoryID, ProfileID)
with these records:
1 belt 05/01/2010 1 1
2 hoslter 05/02/2010 2 1
3 charger 05/03/2010 3 1
I need to take the most recent record for profile 1
to have as result: (3 charger 05/03/2010 2 1)
I tried a number of querries, can't seem to get the right answer.
Please guide me through it..
Thanks a lot..
|
|
|
|
|
Select count(*) from Accessories, the result is 3, then select * from Accessories where ID = result
|
|
|
|
|
Hi
thanks, but we will not know what the result is..
One profiler can have more than one accessories as of in history archive.
but to check to see if a profiler has an accessorie, it should load based on the most recent date since we can have more than one accessories entries for one profiler.
Hope a bit clearer now.
thanks a lot
|
|
|
|
|
SELECT * FROM Accessories ORDER BY date DESC;, then use the first returned record.
By the way, using "date" for a column name is a very bad idea, since it is a reserved word for a data type in most SQL dialects. I always use "order_date" or some other variation to make sure the SQL engine doesn't think you are using a reserved word. Sooner or later that problem will bite you.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
modified on Monday, July 5, 2010 5:24 PM
|
|
|
|
|
Hi,
Thanks.
I have used a variation for date..again thaks for the info..
I thought of doing it this way..wasn't sure if it was the right approaoch..
thanks..
|
|
|
|
|
Instead of returning the entire ordered set, how about returning SELECT TOP 1 ... ORDER BY date DESC instead?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
