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...
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...
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 =...
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...
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?
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...
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...
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...
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
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...
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)...
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...
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!!
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.