Visual Basic

Sub CheckList()

    Sheet1.Cells(1, 1) = "Text1"    'Set text in Sheet1
    Sheet2.Cells(1, 1) = "Text1"    'Set Text in Sheet2
    
    
    Dim sValueFromSheet1 As String
    Dim sValueFromSheet2 As String
    
    sValueFromSheet1 = Sheet1.Cells(1, 1)   'Get Value of Cell A1 on sheet1
    sValueFromSheet2 = Sheet2.Cells(1, 1)   'Get value from list on sheet2
    
    If sValueFromSheet1 = sValueFromSheet2 Then
        Sheet1.Activate
        
        'This will delete 1st Row
        Rows("1:1").Select
        Selection.Delete Shift
        
        Range("A1").Select
        
    End If
    
    ' Now for your question you will have to write your own code
    ' to do what you want to. I can't do everything for you.
    '
    ' Hope this example helps you.
End Sub

cstrader232 wrote:

Is there a way to read a datatable from an .xml file on disk such that the created datatable contains only a subset of the records in the .xml table? Something simlar to the select statement in SQL? Certainly seems like there should be, but I can't seem to find it.

cstrader232 wrote:

Would you be willing to look at my question on reflection that i posted on May 7th?

Public Class UserInfo
   Public ID As Integer
   Public Name As String
End Structure

Dim Users As New List(Of UserInfo)

Users.Add(New UserInfo With {.ID = 1, .Name="Jim"})
Users.Add(New UserInfo With {.ID = 2, .Name="Bob"})
Users.Add(New UserInfo With {.ID = 3, .Name="Sue"})

(From UserInfo In Users Where UserInfo.ID = 3 Select UserInfo).First.Name = "Susan"

(From UserInfo In Users Where UserInfo.ID = 3 Select UserInfo).First.Name = "Susan"

dim b as boolean = (From UserInfo In Users Where UserInfo.ID = 3 Select UserInfo).First.Name = "Susan"

Dim user As UserInfo = (From u In Users Where u.ID = 3 Select u).First
user.Name = "Susan"

Users.Find(Function(u) u.ID = 3).Name = "Susan"

asha_s wrote:

in may project i exploit my data to exl sheet but the styel not very will because the size of the sill is smailer than data size

asha_s wrote:

but the styel not very will

asha_s wrote:

the size of the sill is smailer than data size

asha_s wrote:

is their is way to make the sill size larger in my code not from the excel

Ariel Kazeed wrote:

without having to use a timer to check system time every x seconds?