I wrote following code to copy a range from a workbook to another one:
xlSheet.Range(cell1, cell2).Copy()
xlThisSheet.Range("A1").Select()
xlThisSheet.Range("A1").PasteSpecial(Excel.XlPasteType.xlPasteValues, Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone)
xlThisSheet.Application.CutCopyMode = False
but in new sheet I find exactly same formatting reported in the first one.How can I do to report only values?
I've used this function to send email successfully
Private Function SendEMail(ByVal wholist As String, ByVal emailcontent As String) As Boolean
Dim emailSuccess As Boolean = False
Try
[Code]....
But with a new server my customer has that uses EXCHANGE 2010 it does not work.
I used TELNET to get into port 25 of the exchange server and it seems that it gets a CLIENT WAS NOT AUTHENTICATED error.
Anyone use SMTP with EXCHANGE 2010 yet???
In this case GDI no longer stands for Graphic Device Interface! I have an MDI form, and the child form loads up with a single panel positioned at a specific spot so that i can have a visual studio styled menu on the left side. The square white area is the panel with the fields in it for the user to enter. The left side is a TreeView with GDI lines drawn around it that dont appear until the menu has been changed. Here's what the menu looks like when its rendered properly:
When the form first loads, you can quickly see the GDI drawings come up (sometimes) then disappear. It flashes pretty quick when you can actually see it, but until you change the menu item to another causing it to redraw, its just... gone.. Looks like this:Here's the setup:I have two labels docked at the top for the large white text with a black background
There's the treeview on the left in a picturebox where the GDI components are drawn, and a panel touching it on the right side, which is sized and anchored on all sides basically keeping it stretched to the size of the window while keeping the top and left side pinned in position so it doesnt move, keep it touching the menu on the left.
Inside the panel is 10 more panels, one panel for each menu item. Each panel is programmatically set to resize to 1024x768 and becomes visible once the menu item for that panel is clicked. The panels are all programmatically top positioned at 0 and left positioned at -1 to hide the left border stroke from having the BorderStyle set to FixedSingle. Moving it to -1 hides only that border within the panel its in.
I have dual monitors, so i began stepping through the code on one monitor with the program running on the other so i could see what its doing with each step. While going through, at one point i see the contents of the TreeView completely vanish, but all the drawn GDI stuff is there. Once i get through everything and finally hit F8 on the very last line when control of the program is given back to me because its now waiting for me to do something, all of a sudden the treeview contents re-appear and the GDI drawings vanish.
I just upgraded a project from VB 2008 to VB 2010. Before, the project did not use LINQ. I have started implementing it. So, I have updated the target framework from 2.0 to 3.5, and added a reference to System.Core, and imported the namespace System.LINQ to the entire project and also imported System.Data.LINQ into the form I'm working with (because it was not available in the list for Imported Namespaces in the references tab).
It's not throwing any errors now, but my IntelliSense is not working for LINQ stuff.
For example... I write this:
[CODE]....................
Then, if I type S. on the next line, the IntelliSense doesn't grab what it should for S (Only get Equals, GetHashCode, GetType, ReferenceEquals, and ToString, instead of the options I should get like Count, First, FirstOrDefault, etc...). If I Type S.First. then its the same thing, no IntelliSense that lists the available fields for S, just the standard options (Equals, GetHashCode, GetType, ReferenceEquals, and ToString). I should be seeing my column names in my table when I type S.FirstOrDefault.
So any ideas what is going on? When I type the code, for example, MessageBox.Show(S.FirstOrDefault.FirstName), it works perfectly. But it doesn't change the casing of the text (so it would read s.firstordefault.firstname) and no intellisense while doing it. But no errors. BTW - Everything works perfectly when creating a NEW VS 2010 application, it's just my projects upgraded from Visual Basic 2008 that have this issue.
I recently got microsoft expression studio and VS 2010..To test out expression, i created a sweet looking UI, and transferred an old program from VS 2008, but the CSV writing function I have written in the '08 doesn't work with my WPF form in '10.
CODE
Private Sub ReadTimer_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ReadTimer.Tick
CurrentPosition.Read()
CurrentPositionValue.Text = CurrentPosition.Values(0).ToString()
[code]....
specifically, the error is, "Computer is not a member of My" ....
I'm setting the Image & BackgroundImageLayout properties of a PictureBox programatically, but it's not working. I set the layout to Stretch to fill the picturebox, but the image just displays in it's original size. Here's the code I am using:
[Code]...
but i used this to check if its true
Dim returnValue As String = html
Label4.Text = html
If Label4.Text = "true" Then
[code].....
The code im using:
MsgBox(ListBox3.Items(i).ToString.ToLower)
MsgBox(clientdata.Split(":")(1).Split("|")(1).ToString.ToLower)
If ListBox3.Items(i).ToString.ToLower = clientdata.Split(":")(1).Split("|")(1).ToString.ToLower Then
else
[code].....
Now the weird part is that it goes to the Else case, while the 2 variables in the If are the same.
I found someone's code that they posted on YouTube for a file exists. Now, with their setup it worked fine, but I am trying to search the ENTIRE computer. Not just the application folder, and I can't seem to get it to work.
[Code]...
Using that code I can search for the specified folder and if the file exists it changes the text. Now this works, but I would like to search everything in My Computer at once.
[code]Well, the first GetPixel works fine, it sets textbox2 to yellow if the pixel is ofund and textbox1 says green. But, the second GetPixel doesn't work. The coordinate are correct and the color is also, but I never receive the msgbox.
View 28 Repliesmy program connect to Access DataBase 2003 ! in my computer every thing be ok !but in other pc my program can not open on show this message :
my OS is 7!my VS version is 2010 and it is my connection string : "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + My.Application.Info.DirectoryPath + "my_db.mdb" where is my problem ?
I have form1 and form2. On form 2 i have 2 combo boxes where the user is asked to make selections. once back on form1 i try to use those selections as part of an if statement but although i should be triggring them it does not. I cannot figure this out. I have set up test variables and msgboxes along the way to test this.
The code excecutes. I have double checked the variables on form 2. They just do not trigger a response that will enter the if statements even though it looks like they should. I have double checked that test1 and test 2 are grabbing the variables from form 2
test1 is "Male"
test2 is "10 - 19"
When the code excecutes i never get to the msgbox("Age") line of code. I have also tried taking the spaces out of the strings with no luck as well.
[Code]...
[code]why this code dosnt work? the if statment dont excute it work only if it's like this [code]
View 1 RepliesI've got a button in my app's window that I'm trying to click with code but it isn't working. I googled and found out to do this (in an MSDN document I think):
[Code]...
So I created a store procedure on my Sql Server 2008.
View 10 RepliesI am trying to check if the string starts with certain words before I even add it to my item list, but it doesn't seem to return true even when it should return true.. File I am reading through with my application:
[Constructor.ReplicationHandler]
MeshNames=(ConvexMeshName="",StaticMeshName="52325332",EmitterClassName"")
MeshNames=(ConvexMeshName="",StaticMeshName="3255232",EmitterClassName"")
MeshNames=(ConvexMeshName="",StaticMeshName="644363",EmitterClassName"")
MeshNames=(ConvexMeshName="",StaticMeshName="4636434621646",EmitterClassName"")
MeshNames=(ConvexMeshName="",StaticMeshName="2626352",EmitterClassName"")
[Code]...
I am serializing and deserializing a class - and sending it around with httplisteners - code looks like this Dim inputstream As Stream = request.InputStream()Deserialize(FSOb, inputstream)With the Deserialize function looking like this (and the Serialize as well - it deals with a memorystream)
Public Sub Deserialize(ByRef FSOb As FSObject, ByRef st As Stream)
Dim bf As New BinaryFormatter()
FSOb = CType(bf.Deserialize(st), FSObject)
End Sub
[Code]...
OK, so my accumulator is now adding and showing properly in the form as a total. However, something is wrong in my if... then statement and it's not throwing it to the 2nd level after reaching the 125.*Edit to show updated with the Do While Loop. Now causing issues with my input error msgbox... *
do while decTotalCredits < 125
If IsNumeric(txtCredit.Text) Then
' This statement will convert the string entered to decimal and establish the
[code].....
We had our Crystal Reports report sheets in 2008 working and when we moved to 2010, some of them which their datasources were binded to dataset and datatables are not working.
View 2 RepliesThe following code worked fine in MS Office 2007 PowerPoint Macro.However, in 2010 it crashes at the line "For each cht in..Function CopySheetChart(Sheet As Excel.Worksheet, Row As Integer, Col As Integer, _
Workbookname As String) As Boolean
' Copy the Excel sheet that has top left copy to RowOffset from the page header, and column Col
Dim Cht As Excel.ChartObject
[Code]...
I have a working vb program that works very well - is it possible to convert to an iphone app?
View 3 RepliesI generated SQL Server 2008 Database scripts. There are total 80 objects. The script executes successfully from sql server query. But not from .NET. That is I want to create the objects (tables and stored procedures) from there.If the database don't exist already in sql server, it fails. I have included the line
IF NOT EXIST (DATABASE)...
CREATE DATABASE DBNAME
But it simply don't work and the process fails while the code perfectly works directly in SQL Server.
Any work around this? Can I run CREATE DATABASE somehow?
I have the following function in my program:
Format(Now(), "yMMdd" & "hhmm")
in 2009 it produces 912311200 for 12/31/2009 12:00
in 2010 it produces 1001011200 for 01/01/2010 12:00
It is giving me a 2 digit year. How do I get a 1 digit year?
All the tooltips in one of my apps stopped working. I checked the component; the settings are all the same as on another app that still works. what would cause tooltips to suddenly turn off?
View 9 RepliesHow can i click this button?
<fieldset class="submit">
<input type="submit" accesskey="s" tabindex="0" value="Send Message" name="dosubmit" class="input_submit">
</fieldset>
tried:
For Each element As HtmlElement In WebBrowser1.Document.GetElementsByTagName("submit")
If element.GetAttribute("className") = "input_submit" Then
element.InvokeMember("click")
End If
Next
And
d.All.Item("submit").InvokeMember("click")
Both do not work.
I have a program that u record your clicks then you press a button (Ctrl + E) then it plays them back. What I want is for Ctrl+E to stop them, It would work but it seems like its being overpowered by the mousemoving and clicking. The keyhook did already work before I started on the playback part.
Protected Overrides Sub WndProc(ByRef m As System.Windows.Forms.Message)
If m.Msg = WM_HOTKEY Then
If m.WParam = 2 Then
If started2 = True Then
started2 = False
ElseIf started2 = False Then
[Code] .....
I have no clue how to get ScreenToClient working. I declared the function using:
Private Declare Function ScreenToClient Lib "user32" (ByVal hwnd As Integer, ByVal lpPoint As POINTAPI) As Integer
Then:
Private Structure POINTAPI
Dim x As Integer
Dim y As Integer
End Structure
[Code] .....
What I want to do is move the cursor to 29,109 of the hwnd, not my screen (hence why I'm trying to use screentoclient).
I have installed on my computer Visual Studio 2010 Premium. I am working in a project, in VBasic.Net where I have to include some reports. Where can I find a good .pdf file training?
View 6 Replies[Code].....
and yeah, its opening 7zip properly, its the command is giving an error in 7zip via vs2010, but not via cmd.exe directly.
I've run in to a very annoying situation. At the moment I have a program with 4 forms. 3 of these forms work fine, but the fourth seems to be a dud. After clicking any one of the buttons or controls on this form it works. But if I try to click anything again, it doesn't work. I can't use my back buttons, I can't even use the minimize, maximize and exit buttons in the top right corner which are automatically built in to the program. I fear I have accidentally changed a setting, or accidentally deleted some very crucial code for this
View 8 Replies