No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Good Morning Everyone, May i know how to extract all data from a excel file and copy the data all over to another excel file? Example from Excel A, we have data EmployeeID Name Department 1111 John MIS I want to copy the data over to Excel B... may i … 
|
|
|
Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check …
|
|
|
good evening everyone... could anyone help me on this? With a "time value", eg. 08:00:00... i want to find the range that this value falls in using case statement... i am not good in using the time format... anyone can help? This is just an example: (the code is not …
|
|
|
Good Morning Everyone, i have a question.... i have 2 text boxes... for text box 1, i want user to enter integer in "hour hour" (24 hours format) for text box 2, i want user to enter integer in "mm" (24 hours format) there is also a label in between …
|
|
|
Hi all, i encounter an syntax error "Syntax Error in Insert Into" when i try to run this code... anyone can assist? Thanks! Dim sConnectionString As String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=H:\Users\Desktop\EmployeeAway2.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""" Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objConn.Open() Dim objCmd As New System.Data.OleDb.OleDbCommand() objCmd.Connection = objConn …
|
|
|
Hi everyone, can i check with you, if i want to compare time... how can i do that... i have the following code time_One = Now el_Time = time_One - time_Two Label1.Text = Now.ToShortTimeString If Label1.Text < "06:30:00 PM" Then Label1.Text = "-----" Else Label1.Text = el_Time.ToString End If I …
|