|
Yes,but the problem is I must get it work with A4 as the row header. Because I need to grab the data from the OrderingFormat.xls file I have send to you. If I start with A1 as the row header,it won't works in my project. Do you have any other ideas?
Thank you.
Regards
Drex
|
|
|
|
|
Sorry, I saw the second file you sent me only after sending you this reply. I have checked in google and the solution is as following:
select Qty from [Sheet1$A3:C6]...
A3:first column,first row
C6:last column,last row
Good luck
Shay Noy
|
|
|
|
|
Yes,I got the solution now. Thank you so much for your help on this issue Mr. Eric Hilel. I will solve the problem here. Thanks alot for your kind effort.
Regards
Drex
|
|
|
|
|
|
I would like to learn sending the messages inside our LAN like a chat...or Just sending the messages enough.
I came to know Tcpclient & Tcplistener can do that... vb.net 2008
Any helps will be really appreciated...
Thanks
|
|
|
|
|
Google for "VB.NET Chat" and you'll find a ton of projects demonstrating the various techniques you can use.
|
|
|
|
|
Hi, hope I'm posting in the right forum.
Got a question on making a general functions class library that will be used in several applications and asp pages, sometimes running at the same time.
I've looked at a lot of samples on the web and they all show you to create an instance of the classlibrary namespace or the classlibrary class.
IE.
dim obj2 as new mycompany.mynamespace.myclass
dim n2 as integer
n2 = obj2.somefunction(...)
What I did was create my class library and put a class in it and declared a function as sharred, then created my dll.
I don't have to create an instance of it and I can use it like the net framework by just coding
n2 = mycompany.mynamespace.myclass.somefunction(...).
Am I going to run into problems doing it this way?
If so how can it be done?
The net framework does this, I mean once I imports it I don't have to make an instance of it in every function.
All the samples I've seen about class libraries do not use the shared keyword.
Could some explain this to me?
Thanks for allowing me to post. Mark.
|
|
|
|
|
kmas3752 wrote: Am I going to run into problems doing it this way?
No, if the method is static ( shared ), then that is the ONLY way to call it. And if your methods do not have state, then it makes perfect sense to do it this way.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Could you explain 'if your methods do not have state' ?
|
|
|
|
|
Hello Experts!!
I am displaying crystal report by coding,passing parameters in that.
i am displaying report from grid contents when i click on gridview cell then respective record report must display....in this i have problem is when i click first time on grid cell then it display wright record but for second click it shows same previous record........
|
|
|
|
|
you need to add the following line
this is how I do it in C#
cryRpt.Refresh(); //to load the most recent updated report from dataset
|
|
|
|
|
hello...
i m working on vbscrpt code to get the names of Domain ID's which are not logged from 3 months..
Can anybody guide me??
or give me some hints..
because i m seriously blank
i have generated a vbscrpt to check the domain names but cant get through
Domain ID's
pls help!!
purvas
|
|
|
|
|
How about this[^] article? Does it helps?
|
|
|
|
|
THANK YOU VERY MUCH
purvas
|
|
|
|
|
Hello,
I need to detect if is there any audio comming out on the speakers.
I searched all the web and all I couldn't find what I need (or perhaps I didn't know how to look or what to look for )
Anyway, I need to check if there is any audio playing(media player, web..) anything that comes out from the sound card.
If anyone can help me, it will realy save me.
(I am looking for a solution for 3 days now )
Thank you in advance,
Anomis
|
|
|
|
|
anomis wrote: I need to detect if is there any audio comming out on the speakers.
Well, if you can hear anything, there probably is. If you can't, then there probably isn't. Although one can never be sure. You might have a partially eaten banana in your ear, in which case you almost certainly won't be able to hear anything.
On the other hand, if you put a shell suit to your ear, you should at least be able to hear Romford.
Hope this helps.
[Edit]
Sorry, sorry. Please ignore this post.
[/Edit]
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
modified on Saturday, July 11, 2009 5:19 PM
|
|
|
|
|
I hope you felt good after you wrote this reply
That's how others reply to you, when you are asking for help ?
|
|
|
|
|
How do i change the row heigth of a listviewitem(/treeviewnode) without changing the font heigth?
Thank you!!
|
|
|
|
|
I believe, although I am not able to access VS at the moment, so cannot be sure, there is a OnMeasureItem event that you can override to return a size that you prefer. If you look it up on MSDN I think there is a pretty good example.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I'm currently into similar issues regarding a listbox control. I guess this article[^] might help you further.
Regards
Michael
|
|
|
|
|
Thank you for your help, Michael Schäuble and Henry Minute
I will test it as fast as i can...
Edit: I tested it and it didn't work the listview has no om measureitem-Event only the listbox...
modified on Wednesday, July 15, 2009 2:33 AM
|
|
|
|
|
Hi!
I'm working on a project that involves translating C++ to VB.NET (me not really being a C++ person) and am really stuck on how to translate the following C++ to VB:
sum ^= (((UInteger)(name[i]))<<(off&0x1F));
Where "sum" in an unsigned integer, name is something that I'm not familiar with, but is declared like this:
char *name
And "off" is also an unsigned integer. Do any C++ people out there have any ideas?
Thanks!
MrWolfy
modified on Saturday, July 11, 2009 12:56 PM
|
|
|
|
|
Here's some notes that I hope might help (it's a long time since I did C++ but I think I remember it.)
char *name - declares a pointer to a char, this is a common way to access a string/array of chars. VB.Net equivalent would be a string. So name[i] is the ith char in the string.
(I'm assuming that name is a parameter or that somewhere it has been set to a valid string)
off & 0x1F - is a bitwise and of the variable off and the hex value 0x1F (31 in decimal). Effectively this gives off mod 31 (i.e. remainder after division by 31)
<< - does a left shift by whatever that mod gives. Effectively this multiplies the value in name[i] by 2 to the power of off mod 31 .
sum ^= - means that the value in sum is Xor'd with the the result of the modding and shifting.
Now how you translate that into VB is another matter.
One thing to be wary of is that the C++ is probably dealing with 8-bit chars in VB they are probably 16 bit. You need to know where the data that fills the name string is coming from and so how many bits per char.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
Hi!
Thanks! I was going wrong with the "off & 0X1F" part, I had them all joined together and it gave me an error. It didn't occur to me to separate them out.
All the other information was very useful too, and has helped me in my project.
Thanks Again!
MrWolfy
|
|
|
|
|
Just a caveat to riced's excellent answer:
Do make sure off is not 0FF (zero F F) written in lower case.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|