|
You can avoid the runtime error by using this.
Dim myApp As Excel.Application<br />
Private Sub Button1_Click()<br />
myApp.Workbooks.Add()<br />
myApp.Visible = True<br />
myApp.Cells(1, 1).Value = "Hello"<br />
End Sub
I have no idea, how to check whether the user has close the Excel app.
I’ll be back n 12 hours
Regards,
Chatura Dilan
|
|
|
|
|
Thanks... I have found the solution, just check for Visible property of myApp object solve the error...
Regards,
Pedestrian
|
|
|
|
|
Just wanna know if vb ver 5.0 is compatible with windows xp and wher can i get the relevant information?
I would like to know whether VB 5.0 is compatible with Windows XP and wher can i get the relevant information?
|
|
|
|
|
Yes, VB6 apps will work on XP, so long as the VB6 Runtime is installed. THe problem you have with getting information is VB5 hasn't been around for about, oh..., 10 years or so.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
So wad are the codin for the vb 5 in wins xp,as currently the codin i have for copyin of files sometimes does not work in wins xp. So is there any specified code for the transfer files in vb 5 if we use wins xp?
I would like to know whether VB 5.0 is compatible with Windows XP and wher can i get the relevant information?
-- modified at 23:11 Sunday 16th April, 2006
|
|
|
|
|
claiborne wrote: So wad are the codin for the vb 5 in wins xp
What???? There is no "code for XP". You code for your application!
claiborne wrote: currently the codin i have for copyin of files sometimes does not work in wins xp
This would be a problem in your code or the understanding of filesystems, whether networked or not.
claiborne wrote: So is there any specified code for the transfer files in vb 5 if we use wins xp
No.
claiborne wrote: I would like to know whether VB 5.0 is compatible with Windows XP and wher can i get the relevant information?
I already told you... And in case you haven't figured it out yet, there is no site or information specific to running VB5 apps on Windows XP. VB5 died about 10 years ago!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
So wad are the codin for the vb 5 in wins xp,as currently the codin i have for copyin of files sometimes does not work in wins xp. So is there any specified code for the transfer files in vb 5 if we use wins xp?
I would like to know whether VB 5.0 is compatible with Windows XP and wher can i get the relevant information?
|
|
|
|
|
Dave has given you the answer. Now it is your turn to get off your a** and do some research. Maybe you could visit www.microsoft.com as a start. Also msdn.microsoft.com has a FREE download of Visual Studio Express so that you can code in a more modern environment. VB5 is dead. Live with it.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
|
|
|
|
|
how i can get value of callerid by using SerialPort
vb.net 2005
please i need to a sample code
123
|
|
|
|
|
First, you need a modem, or some other device, that will actually return the CallerID information. Then it's a simple matter of using the SerialPort class to talk to your device. You might have to issue commands to the device to configure it to give you the information you want, but this would be covered in the devices documentation. You'll have to set the proper speed, bits, and parity to talk to the device first though.
Documentation on the SerialPost class[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i'm using vb.net 2005
how i can add a button to datagridviewcolumnTextbox
123
|
|
|
|
|
Hey, I'm new in VB.NET and in my application I'm writing, I would like to save a timestamp (current date and time) in my Access-db. But I can't really figure out how to do it. Can someone help me with this? 
Your help is much appreciated!!
Thanks,
G72360
|
|
|
|
|
Timestamps?? Are you looking to timestamp each record in a table during an update or insert? Easy enough. Just add a DateTtime field to the table. When you do your SQL UPDATE or INSERT commands, supply the current Date and Time as a parameter to the SQL statement in that field you added.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am deploying my window application but after the successful installation of the application the exe is not comming into the start menu ---- programs
Please help me
|
|
|
|
|
Will you please stop spamming the forum?
If you don't get an answer within a reasonable time then no one can/will help you. Posting the same question over and over in all forums does not guarantee you an answer. It only pisses off the forum members.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
-- modified at 19:50 Sunday 16th April, 2006
|
|
|
|
|
....besides, you were given the answer here to your ORIGINAL question[^]
Learn to read and use the forums wisely.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
How to get the user screen resolution?
What I mean is 800*600, 1024*768 ...
Thank you!!!
|
|
|
|
|
Please write a descriptive subject.
Are you using VB or VB.NET?
Do you want the physical screen resoultion or the screen area available for programs (e.g. excluding the taskbar)?
Do you want the current screen for an application, the resolution of all screens, or the size of the desktop? There can theoretically be any number of screens connected to the computer. For an example; I have currently two screens, one 1900x1200 and one 1600x1200, forming a rectangular desktop area of 3500x1200.
---
b { font-weight: normal; }
|
|
|
|
|
I am writing in VB.NET,
I would like to get the Windows resolution setting.
Thank you~
|
|
|
|
|
This should do what you're after:
Dim r As Rectangle = Screen.PrimaryScreen.Bounds<br />
'width = r.width<br />
'height = r.height
|
|
|
|
|
|
 hi all,
i created a program with buttons..they are train seats images.
if we click one of them the "order sheet" form will appear with seat number[ex:CCA1] according to the button we click
how to relate the button to the database?
actually,how to connect the program with the database?im not used to do database a lot
thanks
|
|
|
|
|
Help me..Help me..Help me..
Is that a quote from The Fly or a question?
Please provide a suitable subject for your questions. Ones like this are likely to be ignored.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
|
|
|
|
|
Khomeini wrote: how to relate the button to the database?
actually,how to connect the program with the database?im not used to do database a lot
You really need to start with the basicis. There are many examples on MSDN, The Code Project and Google. You just need to look for them.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
Hi to all,
How can I use Cab deployment.Can anybody please send me the steps in VB.net
Thank You
Pankaj Garg
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
