Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kitackers

  1. kitackers

    PHP If statement always returning else condition

    Ok - Thanks Feherke, appreciate the help
  2. kitackers

    PHP If statement always returning else condition

    So, this is the full code (with the sensitive stuff removed), I'm using PDO, so I guess this isn't the right route if it does't have num_rows, should I be using something like row count? <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Home</title> <link...
  3. kitackers

    PHP If statement always returning else condition

    Oon my Search page I've got dropdowns that are linked to an SQL database and pull a list of names (e.g. the combination accent northern-brown-male-manchester brings up A & B, southern-grey-female-london brings up X & Y) This works fine. What I'm trying to do is add an if statement so if no rows...
  4. kitackers

    Excel VBA objects missing between 2 differing Excel 2013 32bit installations

    Why didn't I think of that?! Will check when I'm back in work tomorrow....Thank you very much!
  5. kitackers

    Excel VBA objects missing between 2 differing Excel 2013 32bit installations

    Hi, I've got a piece of VBA that logs in to CMS, pulls the data in to the workbook and logs out. This works fine on my (older) desktop PC, but my laptop gives a "run-time error 429 ActiveX component can't create the object" at; Dim cvsApp As Object, cvsConn As Object, cvsSrv As Object, Rep...
  6. kitackers

    Import csv into excel - 2007 problem

    My work have recently upgraded from excel 2003 to 2007 (very progressive!!) and, amongst other problems, I had a macro that imported 2 csv files into an excel workbook that worked fine in 2003 but won't in 2007; When I run; Sub Import() Dim oCSV As Workbook Set oCSV =...
  7. kitackers

    Autofilter multiple criteria with VBA in Excel

    I currently use the following code to filter for 2 criteria that are required from a range: Sub FilterRange() Sheets("Call Centres").Select Selection.AutoFilter Field:=2, Criteria1:=Range("ICC1").Value, _ Operator:=xlOr, Criteria2:=Range("ICC2").Value End Sub Where the criteria required are...
  8. kitackers

    Update linked cells from another workbook with a Macro

    Much appreciated
  9. kitackers

    Update linked cells from another workbook with a Macro

    I've trawled through the internet and cannot find anything on this at all. All I'm after is a macro that will update linked cells once fired, rather thatn having to close a workbook, then open it again, updating the links when prompted! Anyone got anything?
  10. kitackers

    Excel Runtime error 13 Colour formatting

    Good spot!
  11. kitackers

    Excel Runtime error 13 Colour formatting

    Brilliant. Much appreciated (feel guilty about being so lazy with my code sometimes!!)
  12. kitackers

    Excel Runtime error 13 Colour formatting

    Oops - Have reposted, Thanks
  13. kitackers

    Excel Runtime error 13 Colour formatting

    I've got a workbook with the enclosed code embedded to each worksheet, which format the cells depending on the data entered (I know the code isn't too tidy, I'm only doing this as a favour!!). When more than one cell is selected and data is deleted, I get a Runtime error 13, type mismatch. Gone...
  14. kitackers

    Excel Runtime error 13 Colour formatting

    I've got a workbook with the enclosed code embedded to each worksheet, which format the cells depending on the data entered (I know the code isn't too tidy, I'm only doing this as a favour!!). When more than one cell is selected and data is deleted, I get a Runtime error 13, type mismatch. Gone...
  15. kitackers

    Rename Files Using VBA

    the structure of the files is currently Branch_name - mm/dd/yy
See more

Part and Inventory Search

Back
Top