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!

  • Congratulations Chriss Miller 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: *

  • Users: kitackers
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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 =...
  4. 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...
  5. 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?
  6. 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...
  7. 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...
  8. 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...
  9. kitackers

    Delete Multiple Files

    I hope some one can help.. I was wondering if it is possible to search a file and delete any files that do not start with the string branch_inbound using vba
  10. kitackers

    Excel User form Help needed

    I'm reasonably new to VBA in excel and need some help on a spreadheet with a calender control function. I have a calender control on a spreadsheet that opens up with a button, when the date is selected it populates cell D8 with the date, but I then have to click the "X" to close the calender. I...
  11. kitackers

    Runtime error opening Outlook for the first time

    I had MS office installed on a home PC, and it was used mainly for checking email via outlook. There was a problem with excel so I uninstalled it, then reinstalled it and everything now works except Outlook. I get a Runtime Error (Program:C:\Program Files\Microsoft Office\Office10\OUTLOOK.EXE)...
  12. kitackers

    Microsoft Access - Port and SSL settings

    Please someone help. My brotherhas set up an email account using his own domain name and accessing it through Outlook. It was working up until halfway through last month, then no more emails arrived, even though they were sent. Using the test feature on Outlook, it failed on "Log onto...
  13. kitackers

    Tracking who has opened a workbook

    I know it's possible and very simple to do in Access, but can anyone tell me if there is a way to track who has opened up a workbook with times and dates. I've been scratching my head for a while, but just can't work it out!!
  14. kitackers

    Sending an email from excel with VBA as review not attachment

    I've got a spreadsheet that gets completed and sent to a group of people on the click of a button, which is Sub Mail_workbook() ActiveWorkbook.SendMail "xxx_xxxxx@xxxxx.co.uk", _ "Daily Absence Log" & " " & Now() End Sub Nice an simple and does the job! Is...
  15. kitackers

    Converting Hours and Minutes to decimals

    At the moment I've got a custom format for time of [h]:mm:ss is some cells and want to be able to get it to show as hours and minutes eg 2 hours 15 minutes as 2.25 (ignoring the seconds) There must be an easy way to do it, but I just can't fathom it out
  16. kitackers

    Logging out agents automatically

    I'm relativley new to Using Meridian Max 9 and I know that there is a an option toset meridian to log agents out when there phone headset is unclipped, but can't for the life of me find where. Also, if someone can help is there anotheroption toset the status to not ready rather than log them...

Part and Inventory Search

Back
Top