|
XL.Quit() would do close Excel. Everything seems OK in this code. The problem lies somewhere else. Maybe some feature the workbook introduces (running macro or something). You should also consider upgrading to Excel2003 if you haven't done so.
|
|
|
|
|
You need to use "Marshal.ReleaseComObject()".
|
|
|
|
|
OK I've tried it in VB.NET and it worked fine without Marshal.ReleaseComObject()
I mean, Excel2003 has quit without it.
But the optimal solution would include your line.
|
|
|
|
|
I think you'll want to use the "Marshalling" especially if your users can create multiple Excel objects from within your application. You'll see them hanging around in the "Task Manager" if you don't handle them. At least that was my experience.
|
|
|
|
|
is there a way to use ms access as the backend for an application developed
in ppc 03? If so, are there some resources for sample code for connecting to
the database, opening the database, retrieving records, modifying records
etc.?
Thanks in advance for any help
|
|
|
|
|
What's "PPC 03"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sorry, that was a poorly worded question. The app was developed in vb.Net for a Pocket PC 2003 (ppc 03) device.
|
|
|
|
|
In that case, your question would be better handled in the Embedded/Mobile Forum[^]. It really has nothing to do with VB.NET. It's a matter of whether the Pocket PC and the .NET Compact Framework has support for OLE Databases, a question I am hardly qualified to answer.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi All,
I have a VB Form which has a Browser Control within. Now I would like that when a VB button is pressed (on the window form) a cookie is set and when i load a particular asp page within the browser control it reads the cookie.
The problem i'm having is setting the cookie from the VB.Net part. Is there a way to do it or at least is there another way to transfer data from VB.NET application to the ASP page.
Can anyone help pls!?
Thanks in advance
Nick
|
|
|
|
|
That's a really poor method of transferring information to a website, and will more than likely fail. Parameters are usually passed in the URL string. The format of which depends entirely on the site. What are you trying to do?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Dave
thanks for your reply..
well i said in my previous post i am creating a VB.Net application which has a WebBrowser within. The story behind it is quite simple as my client wants this particular system and i've suggested to write an application which would be accessed via the Browser (ASP.NET) but he refused! Since i know this guy quite well, i'm pretty sure that after a couple of months he would want it acessed via the Browser...so to facilitate this i've written the main system using ASP.NET and created a client using VB.NET and will eventually load all the ASP pages within. Now the VB client app on loading will ask for the user name and password and in some way i need to transfer the user information to the browser.... i thought i could have done it through a cookie...though through your reply it seems that it is not a suitable method!
Any suggestions would be greatly appreciated!
Thanks once again
Nick
|
|
|
|
|
Uhhhh... You're adding a HUGE level of complexity to the client portion that you don't need to. If your just going to wrap the browser in a Windows app, don't. Your wasting your time and your clients.
In a situation like this, the core of your application should be written as a WebService. This WebService can be accessed by your ASP.NET application or from a Windows application. The data processing portion of this system will be entirely inside the WebService.
Now, the visual side of this app can be done by 2 independent applications. One, by an ASP.NET app that generates the HTML interface for your app in a browser, and the other, by using a normal Windows application. You must keep in mind the the ASP.NET and Windows applications are just the user interface! Visual's only! They will rely entirely on the WebService to handle all of the data processing your app does.
With all the data processing in a WebService, you can stick to writing the Windows app without worrying about how your going to get data into and out of a WebBrowser control.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Wow... thanks once again
I was planning my app as follows:
GUI: VB.NET and ASP.NET
Business TIER: Class based
Data Tier: Class Based
Haven't considered much about webservices! Though i think that WebServices are not much different from Class (viewed from my own unknowledged perspective).Am I correct or? So i could work with webservices!
What i know is that when WebServices are consumed they are received as XML, right? Since my app will contain some sensitive data..will it still make sense or? and if so will webservices return DataSets (i assume so)?
any help would be greaTLY APPRECIATED...and sorry for the stupid questions..though i quite new to this technology...
Kind Regards
Nck
|
|
|
|
|
Well, I barely have time to look at my own code, let alone someone elses. But, I can point you at a starting point for Web Services, here[^]. On the far right of the page, you'll find Web Services Basics[^]. Start there.
Everything in Web Services is passed back and forth using SOAP, which is a lightweight, XML-based messaging framework.
Does it support encryption and security? Yes! Make sure you download and install the Web Services Enhancements (WSE) 2.0 SP2 for Microsoft .NET[^] to get the latest encryption and security support.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi to all,
i have one problem with a scanner:
I have found here the sample Twain Scanner that work with Epson scanner.(1640Su)
When I ask to Aquire from Twain
nothing seems to happen
My scanner is visible and work with other programs.
please answer soon
Thanks
MAssimo
|
|
|
|
|
This may seem like a stupid question, but do you have a TWAIN driver installer for your scanner?
Next, without seeing any code and error messages, there's nothing we can do to help you. You haven't given us any information at all, other than "It won't work." What code do you have that won't work?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
No code error return!!!!!
I click on button "scan" but nothing happen.
I think that the problem is in function
PreFilterMessage because always loop
PS
in my notebook with 2000 server the program work very well
but on customer's computer with 2000 or XP doesn't work
|
|
|
|
|
Again - stupid question - does the machine have a TWAIN driver installed for the scanner?
And, you still haven't provided any code or link to the code your using...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
OK. I have to ask - ARE YOU NUTS? You're using this in production code your selling?
The library your using has some big problems if your going to use it in a production application that your selling:
1 - It's a third party work, hardly tested, and not guaranteed to work at all!
2 - It's not supported, so you're using "at-your-own-risk".
3 - It's not a comprehensive library. It has minimal functionality.
4 - It's a roll-your-own wrapper for a subset of the TWAIN API found in the file TWAIN_32.DLL. If you have a different version of the .DLL file from what the wrapper was written against, it's not guaranteed to work!
It may work for you, but if that .DLL is different on your clients machine, then your on your own. You'd be MUCH better off using WIA (Windows Image Acquisition). At least that's supported by Microsoft and has better support for more hardware.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
How can I find the maximum margings for a selected printer and a selected papersize ?
|
|
|
|
|
I would like to add Alt+F4 to a PopupMenu. The Menu Editor doesn't list any ALT's except for Alt+Bksp. If this is not possible, can I trap the Alt+F4 combination somehow. I tried Form_KeyPress but it doesn't fire for a form with no ControlBox.
Thanks,
Tim
|
|
|
|
|
Alt-F4 is already used by the forms context menu and is normally used to close an application, even closing Explorer and logging you off. Click on the little icon in the top left corner of the form and look at the keyboard shortcut for Close.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
As I mentioned, my form does not have a ControlBox. I found the answer I needed as follows:
Set form.KeyPreview = True
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If Shift = vbAltMask And KeyCode = vbKeyF4 Then
Unload Me
End If
End Sub
|
|
|
|
|
In my table, I have three columns: first_name, last_name, middle_name . I tried to merge them into one column, and this is what I did:
select first_name + ' ' + last_name + ' ' + middle_name as Full_Name from contacts
However, when I do a query on that one, only the ones that have data in all three columns show and if one of the column is missing data wouldn't show.
for example,
orginal table
--------------------------------------
|first_name | last_name | Middle_name|
--------------------------------------
test | test | null |
--------------------------------------
when merges:
-------------------------
| Full_Name |
-------------------------
| null |
-------------------------
if column middle_name is empty, then Full_name would return null, eventhough first_name and last_name have data, why is that happening?
Could someone help me how to make that work?
Thanks a bunch.
John
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
