|
Hi,
I create a simple program that can open a image in excel. But there is a problem, I want it to position a little bit lower because I have some data that i want to write above that image. And also how do I re size the image that i put in the excel?
Here is my code:
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
Dim xlsWSheet As New Microsoft.Office.Interop.Excel.Worksheet
Dim excelFiles As String = "c:\Test.xlsx"
Dim pic As String = "c:\MsC.bmp"
xlsApp.Visible = True
xlsApp.Workbooks.Open(excelFiles)
xlsApp.ActiveSheet.Pictures.Insert(pic)
xlsApp = Nothing
GC.Collect()
GC.WaitForPendingFinalizers()
Anyone change help me how to do the position of image.
Thanks
Regards,
Jessie
if(you type your code here) {
Messagebox.Show("You help me a lot!");
}
else {
You help me = null;
}
modified on Monday, July 28, 2008 4:55 AM
|
|
|
|
|
hi all
when i open at a time more then 5 report in crystal report by vb 6.0 then it give's error which error discreption below read it.
Run-time error '-2147189547'(80047cd5)
there are not enough concurrent access licenses to log you on. This system has 5 concurrent access license. Please try again later, or contact your system administrator to obtain more licenses. Licenses can be purchased direct from Seagate Software or through the Segate Software Online Store.
but i don't want to purchase, I want trap this error in vb 6.0 & give it only our msg for the same.
If any one know this solution then replay me if possible the replay with source code.
Thanx
|
|
|
|
|
does vb6 not have try/catch ?
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Nope - but On Error Goto should suit the requirement.
|
|
|
|
|
On error Goto it is not working it can not traped.
give me other solution.
|
|
|
|
|
I have ran into this many times in .net, not sure if its the same with vb6.
make sure that once you load the report into whatever it is your doing, that you use the ".close" to unload the report and release the licenses. You should be able to load it into a viewer and close it with no problems.
Hope this helps.
PS.
First post =)
|
|
|
|
|
Can i trap crystal report pop up msg in vb 6.0
|
|
|
|
|
Currently i am using Cstr(hddrive.totalFreeSpace) to list my current disk space. But the result which came out is in bytes, is there a way to covert the result to in terms of gigabytes??
|
|
|
|
|
Divide it by 1024*1024*1024, and you will have disk space in GB.
-Dave.
------------------------------------
http://www.componentone.com
------------------------------------
|
|
|
|
|
Yes.. i know that is a way but is there a way which allow the display of disk space with any calculation. If i were to right click c:\ and click properties i can see the disk space both in bytes and GB. Can i display the GB potion instead of the bytes??
|
|
|
|
|
Subjugate wrote: Can i display the GB potion instead of the bytes??
No! That's absolutely impossible. No way! IM-POSS-IBLE! 
...off to buy himself a magic GB potion.
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
What makes you think the Windows "Properties" box isn't dividing by 1,024, too?
|
|
|
|
|
Subjugate wrote: Can i display the GB potion instead of the bytes?
No. You have to divide by 1024*1024*1024, as already mentioned. Has the thought occurred to you that maybe, just maybe, Windows Explorer does the same thing? 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi all
How can I validate a VB.Net DataGridView Cell to accept only Alphabet characters upper and lower. No numbers or special characters are allowed.
Your help please....
|
|
|
|
|
|
Hi All !
I want create new property ( Rows , Cols) to DataGridView
(->So I can choice and set Rows munber and cols munber from form design)
Please tell me what I have todo ?
Thanks All support.
Hai
This will appear at the end of articles you submit to the Code Project
modified on Monday, July 28, 2008 1:19 AM
|
|
|
|
|
Hello Hai,
You will have to create a new UserControl inheriting your application from the DataGridView.
Then you can define new Properties for the control. Inherited NameSpace will be
System.Windows.Forms.DataGridView.
Hope this helps.
Regards,
Allen
Allen Smith
ComponentOne LLC
www.componentone.com
|
|
|
|
|
Hi Allen
Thanks you support
I have create a new UserControl as you said
----------
Public Property Cols() As Integer
Get
Return Me._Cols
End Get
Set(ByVal value As Integer)
Me._Cols = value
Me.Invalidate()
End Set
End Property
------------------
on form design display property Cols, I don't know after that what I must todo
Please help me ! 
This will appear at the end of articles you submit to the Code Project
modified on Monday, July 28, 2008 3:42 AM
|
|
|
|
|
i have created an application which is ping multiple IP address at 1 time. In my application, user can set the routine time by selecting from combobox which is every 10minutes, every 15minutes or every 30minutes. the application will loop pinging IPs until the user ends the program. my question is, how am i going to write the routine?
|
|
|
|
|
if you are using .NET framework 2.0, there's a ping method under My.Computer.Network.Ping.
Hope this can help.
|
|
|
|
|
|
I have a problem taking out the name of the file to compare. For wat i know i if i have a file call 12345.ppt i can use split or remove function to separate the 1st part and the extension part.. But now my question is my file name is abc12345.ppt and i just wan the number which is 12345, how can i go about doing it??
|
|
|
|
|
If you just want the number, you need to use a regex for that.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
hi chaps,
it has been a while since I have been here ...
I started programming back again but I'm having a problem ...
I would like to use the mid() function in multiple lines ... (textarea)
is there any way I can jump from line to line ?
and another question ... can somebody give me the code to write a textarea content to a file ?
thx in advance ... I hope you guys can help me out ... specially with the mid function or some alternative of it
|
|
|
|
|
is this VB6 or VB.NET ? you can use the Split method to turn a string into an array, one per line. You can use the substring method on each line to get a substring if you want.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
