Search results for query: *

I've been asked to create an Outbound reports with the following metrics: Number of Outbound Calls Talk Time Work Time Hold Time Outbound Time Average Handle Time Occupancy I'm used to doing Inbound calls using the ACD split/skill reports. I'm unsure what CMS reports I can use to track these...

no problem. I'm using excel. The data I want is on the same workbook as the report itself.

not sure I understand. could you please give me an example. I'm seeing allot of example on the net but i don't get it. see exampl bit below: Set QT = WSW.QueryTables.Add(Connection:=ConnectString, Destination:=WSW.Range("A1")) With QT .Name = "portfolio" .FieldNames =...

Never used QueryTables before need help. I have 1 workbook with to sheets. A datasheet and a reportsheet. the datasheet has field names: Dept, Location, Skill, Calls Offered, & BAHT. So lets say in the reportsheet on Cell A1 I need a specific Dept,Location summary from teh datasheet. How do I...

does anyknwo know how to get cms data via the scripting through access vba

Still having problems. Does anyone have an help they can offered , Please:)

my company uses all 3 cms verion. My code work great for 9 & 11. However 13 will not export. there are no error msg. the loop just keeps going as there seems to be no data coming from the application. this is where it keeps looping: freetmpnum = FreeFile() For i = 1 To 9 Line Input #1...

I use CMS 9 11 & 13 script's the 13 will not run the report engine. I check the log and it shows: User ID and password for automatic scripts with this CMS server have not been specified how do i fix this

Thx that helped me on my way. So now I have it opening the AccessDB then a macro runs to open the form. Is there no way to just open the form without having to open the AccessDB.Here si what I have in my script: Sub controlAccess() Dim objAccess As Object Set objAccess =...

I'm using office xp. I have a form in my accessDB that changes the dates in my queries. I would like to access this form via Excel. Does any one have any code they can share with me that would help.