Welcome to the fracta.net forum!

Share your coding ideas or ask questions.

Question VBA coding to change the CMS time Zone

  • Payroll
  • Topic Author
  • Visitor
  • Visitor
7 years 11 months ago #612 by Payroll
Replied by Payroll on topic VBA coding to change the CMS time Zone
Thank you very much that worked

Set info = acssrv.reports.reports("Historical\Agent\Login/Logout (Skill)")
If acssrv.reports.CreateReport(info, acsrep) Then
acsrep.TimeZone = "US/Central"
acsrep.setproperty "Skill", 83
acsrep.setproperty "Date", begindate
If acsrep.ExportData(sExportName, 9, 0, False, True, True) Then
Sheets("Agent Login").Activate
Sheets("Agent Login").Cells(blankrow2, 1).Select
ActiveSheet.Paste
End If
acsrep.Quit
Set acsrep = Nothing
End If

You have just made my day!!

Please Log in or Create an account to join the conversation.

Time to create page: 0.438 seconds
Powered by Kunena Forum