Positioning the image in Excel 2007 [modified] - Visual Basic Discussion Boards

Luc Pattyn28-Jul-08 1:14

28-Jul-08 1:14

Hi,

This article[^] demonstrates the nice things a ListBox can do. It is C# code, but the same applies to VB.NET
In essence, the listed items don't have to be strings, they could be any kind of object;
and a ListBox supports user-drawing, so you decide how things look.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Menustrip & Selection

Member 425919228-Jul-08 0:19

Member 4259192

28-Jul-08 0:19

HowI can hide the selction of a button disabled after then mouse is outside it? (VB.net)
thanks

Re: Menustrip & Selection

Thomas Stockwell29-Jul-08 9:06

Thomas Stockwell

29-Jul-08 9:06

I am not quite sure what you are asking.

Are you referring to: changing focus, hiding the button?

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios

Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com

Create an excel 2003 add in with vb2008

JR21227-Jul-08 22:32

JR212

27-Jul-08 22:32

Hi,

Is there a good instruction how to create on add in and install it on someone else his/here pc. About 20 persons will use the same add in. So where must i copy it? How do I activate it? and so on.

some examples are apriciated

Jan

Re: Create an excel 2003 add in with vb2008

John_Adams28-Jul-08 8:56

John_Adams

28-Jul-08 8:56

Hi Jan,

Tye to use VSTO (Visual Studio Tools for Office) for VS 2008. This provides many features to developers to deal with Office application development.

Hope this helps Smile | :)

Regards,
John Adams
ComponentOne LLC

Re: Create an excel 2003 add in with vb2008

rprateek6-Aug-08 19:11

rprateek

6-Aug-08 19:11

check the following link which explains step by step way to create an excel from vb code

http://rprateek.blogspot.com/2008/03/read-from-excel-file-from-vb-60.html[^]

Also check in the code where the excel is declared as an object, which will solve your problem.

Blog for Programmers http://www.rprateek.blogspot.com

Select the sender in outlook mail

~Khatri Mitesh~27-Jul-08 21:29

~Khatri Mitesh~

27-Jul-08 21:29

Hiii
I m working on outlook Addins using vb.net 2005 and i want to select the profile (Sender User from ) My outlook.
Like
I Have 4 Profiles in outlook and when i send the mail i want to select the sender user in outlook.
I am using a custom windows form for sending mail. not a default outlook mail editor.
Please suggest how i select the profile.
Thanx
~Khatri Mitesh

Positioning the image in Excel 2007 [modified]

klaydze27-Jul-08 21:06

klaydze

27-Jul-08 21:06

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

There are not enough concurrent access licenses to log you on. [Crystal report]

AJAYWVK8727-Jul-08 20:44

AJAYWVK87

27-Jul-08 20:44

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

Re: There are not enough concurrent access licenses to log you on. [Crystal report]

Christian Graus27-Jul-08 21:17

Christian Graus

27-Jul-08 21:17

does vb6 not have try/catch ?

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

Re: There are not enough concurrent access licenses to log you on. [Crystal report]

Duncan Edwards Jones27-Jul-08 23:59

Duncan Edwards Jones

27-Jul-08 23:59

Nope - but On Error Goto should suit the requirement.

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

Re: There are not enough concurrent access licenses to log you on. [Crystal report]

AJAYWVK8728-Jul-08 22:55

AJAYWVK87

28-Jul-08 22:55

On error Goto it is not working it can not traped.
give me other solution.

Re: There are not enough concurrent access licenses to log you on. [Crystal report]

DJ Matthews28-Jul-08 9:11

DJ Matthews

28-Jul-08 9:11

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 =)

Re: There are not enough concurrent access licenses to log you on. [Crystal report]

AJAYWVK8729-Jul-08 0:24

AJAYWVK87

29-Jul-08 0:24

Can i trap crystal report pop up msg in vb 6.0

harddisk space..

Subjugate27-Jul-08 20:39

Subjugate

27-Jul-08 20:39

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??

Re: harddisk space..

Ajay.k_Singh27-Jul-08 21:05

Ajay.k_Singh

27-Jul-08 21:05

Divide it by 1024*1024*1024, and you will have disk space in GB.

-Dave.

------------------------------------
http://www.componentone.com
------------------------------------

Re: harddisk space..

Subjugate27-Jul-08 21:35

Subjugate

27-Jul-08 21:35

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??

Re: harddisk space..

Smithers-Jones27-Jul-08 23:24

Smithers-Jones

27-Jul-08 23:24

Subjugate wrote:
Can i display the GB potion instead of the bytes??

No! That's absolutely impossible. No way! IM-POSS-IBLE! Dead | X|

...off to buy himself a magic GB potion.

"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)

Re: harddisk space..

jzonthemtn28-Jul-08 4:51

jzonthemtn

28-Jul-08 4:51

What makes you think the Windows "Properties" box isn't dividing by 1,024, too?

Re: harddisk space..

Paul Conrad28-Jul-08 10:46

Paul Conrad

28-Jul-08 10:46

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? Hmmm | :|

"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

DataGridview cell validation

Fahim A27-Jul-08 20:01

Fahim A

27-Jul-08 20:01

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....

Re: DataGridview cell validation

Fahim A2-Dec-08 12:33

Fahim A

2-Dec-08 12:33

This has been completed

How to create new property (cols,Rows) to DataGridView [modified]

Member 303106927-Jul-08 18:33

Member 3031069

27-Jul-08 18:33

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

Re: How to create new property (cols,Rows) to DataGridView

C1AllenS27-Jul-08 19:35

C1AllenS

27-Jul-08 19:35

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

Re: How to create new property (cols,Rows) to DataGridView [modified]

Member 303106927-Jul-08 21:36

Member 3031069

27-Jul-08 21:36

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 ! D'Oh! | :doh:

This will appear at the end of articles you submit to the Code Project

modified on Monday, July 28, 2008 3:42 AM

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.