Free Microsoft Excel 2013 Quick Reference

biometric finger scanner to work with excel database

hi,

how's everyone? i hope all is doing well. I have an excel database program and i was wondering if it is possible to sync my excel database with the biometric finger scanner? Can I possibly use the finger scanner to pull out information from the excel database? Like if user enter his id number, then place the thumb on the finger scanner, once the finger scanner match the id number with the thumb mark, the data of the user will be displayed on screen. Is this possible?

Thanks,

Stoey


Post your answer or comment

comments powered by Disqus
Is there a way to have excel not graph a space in between dates that are not
right in a row... for example. if I have 12-1, 12-2, 12-3, and then jump to
12-6.... how can I avoid that space in my graph.

also... I find excel graph's to be difficult to work with... are there any
recomended charting programs that work with excel that have more
functionality and just work better?

My question is only loosely tied to excel, but I thought maybe someone here may know the answer.

I am using an html file with vbscript to work with some excel and access documents to put quite a bit of data into a seperate excel file. This is proving to be difficult, but I am making progress.

My problem arises when I went to test the first section of my coding and placed the html file on a network drive.(where it will HAVE to reside for all interested parties to have access to it) Now that the file is on the netwok drive, explorer doesn't even recognize the vbscript code contained within the file when it is opened. It does not give me the yellow drop down security bar at the top asking for my authorization. Does anyone have any clue what may be causing such a problem?

I'm sorry that this isn't necessarily an excel problem, but since it is an excel project, I was hoping someone could help.

Vista Small business (up to date)
Excel 2007

Windows Speech Recognition is excellent!! That said, I can not get it to work with Excel 2007 when
in Vista . In contrast, I have Excel 2007 on an XP machine and the Dragon Naturally Speaking works
as expected.

When in Excel, in a cell, if I say i.e. 1000 I get the question "What did you say?"
If I say "Account number" it asks "What did you say?"

If I use Notepad, Word, what ever; Windows Speech Recognition gets it correct!!

What am I obviously missing when using Excel?

I realize that answer is probably stupidly easy.

Any help appreciated!!

BTW, I have rebooted etc.

Hi,

I am just trying to learn how to work with excel and word using VB.

I have created an excel document that
1. Creates a word document
2. Performs a calculation. If that calculation meets certain criteria it calls another module.
3. The second module reopens the word document and writes out an order.

I have been able to make everything happen up to writing the order. My code calls a module to reopen the word document that was initially created and write the order. The code is running, however it is not writing anything to the word document. I would be grateful if anyone is able to look at the code and give me any advice.

Many thanks

Hi

I want the macro shown below to work with all excel files that I produce, rather than just the one called "filetoday", What do I have to change to make this work.

Many thanks

-------------------------------------------

Sub Insert()
Dim rng As Range

With Worksheets("filetoday")
.Cells(1, 1).EntireRow.Insert
.Cells(1, 1).Value = "text1"
Set rng = .Cells(Rows.Count, "A").End(xlUp)
With rng
.Offset(1, 0).Value = "text2"
.Offset(1, 1).FormulaR1C1 = "=COUNTA(R3C1:R[-1]C1)"
.Offset(1, 2).FormulaR1C1 = "=SUM(R3C7:R[-1]C7)"
End With
End With

End Sub

Hi Exp

i would like to Load Excel VBA Macros, in ordre for them to work with IBM Host on Demand. I work white Excel 2007; and need to transfer data in to Host on Demand. Is the a, standard way to do so ?

Ore do some of you know of Macros that all read exist ?

Hi!
I work with Excel structured file and often use group/ungroup to make the work more convenient. Do you know, how to work with file structure using VBA? Maybe it's easy to load a structure of a file and to manipulate it?

I'm using Jakarta POI to access to a excel
Poi works and updates correctly the values in the cells but if I open the
resulting document with Excel 97, does not update the values of the
formulas

With Excel 2000 it doesn't happen and I must to do that it works with Excel
97. Do you know how I can to fix it?

Anything I read many times he "Excel evaluates the formula when you open
it".
With Excel 97 too?

Thank you and sorry for my english :-)

In your module it should look like this:

ActiveSheet.SaveAs Filename:=Filesavename, _
FileFormat:=xlWorkbookNormal, _
Password:="", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False

I moved the underscores, which are line continuation characters, so they are
on the end and won't wordwrap in the email.

I made the constant xlWorkbookNormal, but I wouldn't expect that to make a
difference:

? xlNormal
-4143
? xlWorkbookNormal
-4143

--
Regards,
Tom Ogilvy

"La Durande" > wrote in message
...
> the following VBA works with Excel 2000 but gives error 1004 when used
with
> Excel 2002 (XP)
> '
> ' 14/09/2004 by Alf Dorrian
> '
> Range("A2:M73").Select
> Selection.Copy
> Workbooks.Add
>
> Range("A2").Select
> Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
> SkipBlanks:=False _
> , Transpose:=False
> Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone,
> SkipBlanks:=False _
> , Transpose:=False
>
>
> Application.CutCopyMode = False
> Filesavename = Application.GetSaveAsFilename( _
> fileFilter:="Excel Files (*.xls), *.xls")
>
> If Filesavename False Then
>
> (the code below this gives the error)
> ActiveSheet.SaveAs Filename:=Filesavename, FileFormat:= _ xlNormal,
> Password:="", WriteResPassword:="",
> ReadOnlyRecommended:=False _ , CreateBackup:=False
>
> End If
> ActiveWorkbook.Close SaveChanges:=False
> ActiveWorkbook.Close SaveChanges:=False
>
> End Sub
>
> Have "repaired" Office XP Pro but still won't work
>

The file was originally created in Excel 97. There are no macros, no vb code anywhere. There are formulas that are placed in cell "V5" and "Q5". The cell "O22" is somehow linked to these two formulas. From cell O22, if you execute the hot keys "control-D", it will execute the formula in cell "V5", and "control-I" will execute the "Q5" formula. The formulas take all of the data listed in column "R", calculates it and then displays it under column "O22" and below.

These shortcut hotkey commands do not work with Excel 2000 & 2002.

Any ideas on this one?

I'm using Jakarta POI to access to a excel
Poi works and updates correctly the values in the cells but if I after open
the resulting document with Excel 97, does not update the values of the
formulas

With Excel 2000 it doesn't happen and I must to do that it works with Excel
97. Do you know how I can to fix it?

Thank you and sorry for my english :-)

hi,

Im back again for more learning. I have a two codes written specifically to work with 2 command buttons namely START and END. My question is can I combine two formulas or codes to work with only 1 command button?

Here is the code for the START button:
Private Sub cmdstartb1_Click()
    Dim iHour As Integer, iMin As Integer, iSec As Integer
    Dim Target As Range
      Cells(CurRow, "F") = Time
      iHour = Hour(Now())
      iMin = Minute(Now()) + 30
      iSec = Second(Now())
      
        MsgBox "Please be back on or before:" & Chr(13) _
                 & "           " & TimeSerial(iHour, iMin, iSec) & vbCrLf _
                 & "Thank you! Have a good time.", vbOKOnly + vbInformation, "30 Minutes Break Only"
    
       'c.Value = TextBox1.Value          ' write amendments to database
       With Me
        Cells(CurRow, "F").Value = Time
        ActiveWorkbook.Save
        TextBox1.Value = vbNullString
        TextBox1.SetFocus
        OptionButton1.Enabled = False
        OptionButton2.Enabled = False
        OptionButton3.Enabled = False
        Frame1.Enabled = False
        cmdstartb1.Visible = False
        cmdendb1.Visible = False
        ClearOptions Frame1
        Label2.Caption = "Employee Name"
        cmdstartb1.Enabled = False
        End With
        
   
End Sub
Here is the code for the END button:
Private Sub cmdendb1_Click()
    Dim iAnswer As Integer
    Dim BreakTime As Integer
    Dim Min As String, Sec As String
    Dim StartTime As Single
    Dim StopTime As Single
    Dim TLeft As String
    Dim Overbreak As Integer
    
    
      BreakTime = 30     'Break Time in minutes
    
        StartTime = Cells(CurRow, "F").Value
        StopTime = StartTime + TimeSerial(0, BreakTime, 0)
       'Format the time remaining to show only minutes and seconds remaining
        TLeft = Format(StopTime - Time, "hh:mm:ss")
       'Ignore the hours
        TLeft = Right(TLeft, Len(TLeft) - 3)
       'Separate the minutes and seconds
        Min = Left(TLeft, 2)
        Sec = Right(TLeft, 2)
        
        With Me
         If Time < StopTime Then
           iAnswer = MsgBox("You still have " & Min & " minutes and " & Sec & "
seconds remaining. " _
                        & vbCrLf & "Do you want to end ?- select Yes or No ", vbYesNo + vbInformation,
"Just right ON TIME")
                                              
                If iAnswer = vbYes Then Cells(CurRow, "G") = Time
                
                ActiveWorkbook.Save
                TextBox1.Value = vbNullString
                TextBox1.SetFocus
                OptionButton1.Enabled = False
                OptionButton2.Enabled = False
                OptionButton3.Enabled = False
                Frame1.Enabled = False
                cmdstartb1.Visible = False
                cmdendb1.Visible = False
                ClearOptions Frame1
                Label2.Caption = "Employee Name"
           
                End If
                
                        If Time > StopTime Then
                            Overbreak = MsgBox("You are " & Min & " minutes and " & Sec &
" second overbreak. " _
                                            & vbCrLf & "Please come back on time nextime", vbOKOnly +
vbCritical, "OVER BREAK")
                            
                            If Overbreak = vbOK Then Cells(CurRow, "G") = Time
                            ActiveWorkbook.Save
                            
                            TextBox1.Value = vbNullString
                            TextBox1.SetFocus
                            OptionButton1.Enabled = False
                            OptionButton2.Enabled = False
                            OptionButton3.Enabled = False
                            Frame1.Enabled = False
                            cmdstartb1.Visible = False
                            cmdendb1.Visible = False
                            ClearOptions Frame1
                            Label2.Caption = "Employee Name"
                            cmdendb1.Enabled = False
                           
                        End If
            
          End With
       
            
End Sub
Is it possible to put together all these vba codes and make it work using only one command button? Like if user clicks on START then it will paste the time on the worksheet and make the END button appear. Then when the END button is clicked the button becomes disabled. These button will not only work once because there are a lot of users.

i am working with excel sheet. here i am giving the example also
Invoice No. Month Client Consultant Period Hours Rate Amount Payment Due
Date Payment Status Current Date No of Days Report Status

5629 APR Ciber, Inc Talluri 04/15/2006 to
04/21/2006 40 65 2600.00 5/24/2006 Pending 4/27/2006 27 Current
if report status is overdue i want this excel sheet to be mailed to
concerned persons

I am looking for a possible solution or bump in the right direction
when working with excel on the web. Currently I am using and developing
in visual studio 2005. Here is the situation I have a lot of
spreadsheets with macros that I would like to deliver to people via a
web application.... Some problems that I am running into are:

1) macros do not work when embedding the excel sheet in the browser.
2) Trying to figure out charting and graphing..

Sorry I am still a bit new to all this and am looking for some
advice....

Thanks

I have a workbook created in with excel 2007, and I need the macros in it to work when I send it to someone with excel 2003. When I save it as type "Excel 97-2003 Workbook (*.xls), the macros don't work though.

Thanks in advance,

Claire

I use this code to adjust Y axis using min and max functions in the cells. I have to click on the cells to activate the change. How can I change the code to work with "Calculate"? Also, what code do I need to work for secondary Y axis?

	VB:
	
 Range) 
    Sheet5.Unprotect Password:="password" 
    Select Case Target.Address 
    Case "$M$2" 
        ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlValue) _ 
        .MaximumScale = Target.Value 
    Case "$M$3" 
        ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlValue) _ 
        .MinimumScale = Target.Value 
    Case Else 
    End Select 
    Sheet5.Protect Password:="password" 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Thanks.

Hi, I really need some optimization help.

I'm creating an interface for automated testing process.
I have a process tree arranged with check boxes:


	VB:
	
 CheckBoxFD_Click() 
    If CheckBoxFD.Value = True Then 
        CheckBoxFD001.Value = True 
        CheckBoxFD002.Value = True 
    End If 
    If CheckBoxFD.Value = False Then 
        CheckBoxFD001.Value = False 
        CheckBoxFD002.Value = False 
    End If 
End Sub 
 
Private Sub CheckBoxFD001_Click() 
    If CheckBoxFD001.Value = True Then Range("AA3").Value = 1 
    If CheckBoxFD001.Value = False Then Range("AA3").Value = 0 
End Sub 
 
Private Sub CheckBoxFD002_Click() 
    If CheckBoxFD002.Value = True Then Range("AA4").Value = 1 
    If CheckBoxFD002.Value = False Then Range("AA4").Value = 0 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

According to choice made by each check box I'm coping line of data to another worksheet.
The problem is that at the moment I've hardcoded the value of each check box to the specific cell in the line which will be copied in case of checkbox.value=true (AA3, AA4,...).
At the moment there are around 100 check boxes. And in the future number of check boxes is going to grow to 1000 and they will be inserted not only at the end of the list...


	VB:
	
) 
 
Application.ScreenUpdating = False 
 
Dim cell As String, n As String, i As Integer, k As Integer 
Dim csfcell As String, cefcell As String, sfn As String, efn As String 
Dim cstcell As String, cetcell As String, stn As String, etn As String 
 
n = "AA" 'column with check box value 1/0
sfn = "D" 'start column in the range of the row which we will copy
efn = "H" 'end column in the range of the row which we will copy
 
k = 1 'number of row where we will copy
stn = "B" 'start column in the range of the row where we will copy
etn = "F" 'end column in the range of the row where we will copy
 
For i = 1 To 127 'last string
     
    cell = n & i ' 'cell with check box value
     
    Dim chkbox As Integer 
    chkbox = Worksheets("Overview").Range(cell).Value 
    If chkbox = 1 Then 
         
        csfcell = sfn & i 'start cell from the range which will be copied
        cefcell = efn & i 'end cell from the range which will be copied
         
        cstcell = stn & k 'start cell from the range where will be copied
        cetcell = etn & k 'end cell from the range where will be copied
         
        Worksheets("Temp").Range(cstcell, cetcell).Value = Worksheets("Overview").Range(csfcell, cefcell).Value 
        Worksheets("Overview").Range(csfcell, cefcell).Copy 
        Worksheets("Temp").Range(cstcell, cetcell).PasteSpecial 
         
        k = k + 1 
         
    End If 
     
Next i 
 
Application.ScreenUpdating = True 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

How to optimize this code to work with check boxes without having deal with the exact names of the cells (AA3, AA4, ...)

Hi,

Am trying to find out if can I get the IF function to work with the FIND function where multiple values are involved. I tried looking this up on other forums but couldn't get an answer. My current formula looks like this:-

=IF(ISERROR(FIND("UN:",O3)),"NON DG","DG")

I need something which would help me return the same values as above if the cells in column O criteria contained anyone of the flwing - "IMO", "IMCO", "UN" (some instances they contain at least 2 of the criteria - does this pose an issue too?)

Appreciate some expert help here!

Thanks.

Rgds,

MChong.

I use SUMIF and COUNTIF formula's to sum and count data within specific
ranges. Here are the formula's I use to find data from 5.0 to 15.0:

=SUM(N2:N220,-SUMIF(N2:N220,{"=15.0"}))

=COUNTIF(N2:N220,">=5.0")-COUNTIF(N2:N220,">=15.0")

Is there a way to modify these formula's to work with SUBTOTALS?

Thanks,

Steve

Is there a way that I can get .pmd files to work in excel?

how do i open spreedsheets created in works, with excel 2003

Working in Excel 2002/XP on an Excel worksheet which was created in Excel
2000, I get an error message "Subscript out of range". How do I update the
macro to work in Excel 2002?

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work...but this is redundant any
ideas how to format the data? or to prepare the data prior to importation? I
need this data to import and display without having to re-key the data.
Thanks for the insight.

Demo: Up to speed with Excel 2007


No luck finding an answer? You could always try Google.