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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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
  16. kitackers

    Delete Multiple Files

    golom thanks you for all your help with my 2 problems i have tried to input and run the above code but it is returning a error user define type not defined and seleting the top row ("Dim FSO As New Scripting.FileSystemObject")
  17. kitackers

    Rename Files Using VBA

    sory i want to look for files with that dat format amd then rename them sorry if i was unclear
  18. kitackers

    Rename Files Using VBA

    golom thanks you very much for you help with this, it works fine.. i am just adapting the code slightly so i can use it with another file and was wondering if it is possible to not only look for a matching string like branch_name but alos to look for any file for the previous day so it looks...
  19. kitackers

    Rename Files Using VBA

    I hope someone can help i have a problem in that there is a folder created auitomatically everynight with a number of txt files, what i need to be able to do is rename these files using VBA. I have the following code that i thought would work Dim oApp As Object Dim FilePath As String, Draft...
  20. kitackers

    Delete Multiple Files

    thanks for you feedback i am trying to think of another way of doing it do you know if it is possible to use the name function and the widcard together, the problem i have is the files are run at different times each night and therfore the name of the file is different each day

Part and Inventory Search

Back
Top