Search:

thank you Chris

The problem is with using both vs 2010 and excel 2007 together. So i installed office 2013. it worked perfectly.
solved my problem.

the same code worked for vs 2005 and excel 2007.

Now i am getting problem with VS 2010 and excel 2007

i imported the above three cases as you mentioned.

chris

i am getting same error above mentioned while executing the below lines.


textRectangle.TextFrame.Characters.Text = "Hello again"

...

thank you chris for your reply,


i am getting the same thing in the excel as you posted. But when modifying the attributes of the shapes i am getting the problem.
in your example, i want no...

hi every one

i am creating a program which places shapes like lines, rectangle, triangle etc. using vb.net 2010 version.
i am getting error when modifying the attributes like line weight,...

i solved my self using the below

tools-->Add sharepoint connection

it solved my problem

thanks you swinkels for you support

gvg

i am using visual studio 2010 ms office 2007 in windows 10
is it compatability issue or anything else?

please help me how to solve this problem

gvg

thanks for your reply Peter Swinkels ,

this is my code with a windows form and 3 buttons on the form


Imports Microsoft.Office.Interop
Imports Excel = Microsoft.Office.Interop.Excel

Public...

hi every one

i am getting error while opening an excel file from a vb.net application

Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type...

thanks westconn1

it's worked.

thanks vbfbryce,

yes that can possible. i am inserting a triangle. so, instead of inserting three lines i am going for triangle. is there any option to insert lefttriangle or modify with any...

my requirement is lefttriangle but there is only Righttriangle and there is no options for left triangle
so, is it possible to insert triangle slope from right to left using vb.net

thanks westconn1

its worked.

thanks,
it worked for me.

one more thing that i inserted right angle triangle, it inserted filled righttriangle. i would like to know how to use no fill property of that triangle.

thank you vbfbryce for your reply

your code inserting the line or arrow at the starting point of the excel cell.

But i would like to ask you that is there any way to insert the line starting...

as per your advice i started to record macro

when i place lines and arrows from insert->shapes as per my example attached above. It did not record any thing
except sub and end sub.
Sub Macro4()...

as per your advice i started to record macro

when i place lines and arrows from insert->shapes as per my example attached above it did not record any thing
except sub and end sub.
Sub Macro4()...

hi

what is the problem above and how to solve it?

plz give a solution

hi all

i am executing a vb.net program to write an excel for inserting an arrow in it.

Dim shp As Microsoft.Office.Core.Shape
shp = ows.Shapes.AddLine(114, 504, 114, 462)

...

thank you very much jmcilhinney for your quick reply.
yes, my real scenario involves a large number.
in the for loop iteration 4 is not constant. ie it may be p1, p2, p3, p4, p5, p6........... so...

hi all,

is it possible to create array variable in a for loop like
p1 = 2, 3, 17, 5, 6
p2 = 8, 9, 1, 13
p3 = 7, 10, 12, 15
p4 = 11, 14, 16, 4

for i as integer = 1 to 4

thank you paul
I am writing an excel through vb.net program. I want to draw a diagram in excel with writing. i think it is not a VBA question.
any example how to do it with excel drawing tools ...

hi all

i would like to know how to draw figures in excel programically with lines from drawing tools of excel using vb.net (as in attached pdf file).
So can any one guide me how to do it with...

thank you jmcilhinney for your reply

dim array as object (,)= new object (25,8){}
the array is storing strings, doubles and integers

hi all
i am doing a some program using vb.net. when am adding two array elements with "+" sign, its not adding two elements. its giving the result like the below:

Mv= array(1,4)+array(1,5)

if...

hi
i have text with numbers i want to split and copy into an array

1 TO 8 10 12 15 16 18 TO 24

how to split this type of text into array like 1 2 3 4 5 6 7 8 10 12 15 16 18 19 20 21 22 23 24...

hi

i want exactly shown in the attached model jpg file.

hi everyone

i would like to know that how to draw lines and arrows with single line not shapes in excel using vb.net.

thanks
gvg

i am not editing compiled dll. i want to edit it in dll source project only. i cound not see the edit designer when i right click on form in solution explorer.
i can see view class diagram only i...

further i can see form1.designer.vb and form1.resx

thanks for your replies.
@kebo
i want to edit from the original file that i compiled.
@dday9
i cound not see the edit designer when i right click on form in solution explorer.
i can see view...

Thank you dday9 for your quick reply. Yes exactly I want to edit the form..

Hi everyone,
I have created a DLL application. In the application i have created one form for getting information from the user. Now i want to modify the form but I couldn't see form. So please...

Thanks for your suggestions Paul and passel

Hi every body
Please help me how to do.
I have a string like, "1, 3, 5 TO 9, 11 etc
I want put in an array like 1 3 5 6 7 8 9 11
I am able to split the string using ", "
how to do 5 TO 9 as 5...

hi
is it possible to round down integer value to nearest 25 in vb.net
like floor function in excel.
ex: floor(123,25)=100, floor(158,25)= 150 etc.
i searched different places but i could not...

i am successful in splitting the string part and integer part and also sorted the integer part. Now the problem is joining the string part C to the sorted integer part. this is my code

Dim colgr...

i am a newbie. so i started with the old framework. later on i will shift to new framework.

vb 2005 that is .netframework 2.0