- Thank you received: 0
Welcome to the fracta.net forum!
Share your coding ideas or ask questions.
Share your coding ideas or ask questions.
Question Export from CMS to Excel using VBA
3 years 9 months ago #734
by Saeed
Export from CMS to Excel using VBA was created by Saeed
Hi All,
I've been trying to extract a specific report from CMS to an Excel sheet using VBA codes but everything i end up with a disappointment. Please if anyone can write a script for me that i can paste in VBA it will be highly appreciated.
What i do to get the report is simply press on the below to reach it:
Commands - Reports - Then i select from the category "Split/Skill" then i select from the report "Agent Status by Location" - Split Skill will be " Let's not say in public " and Location IDs "4;43;45;1" - refresh every 30 seconds - Enable report threshold ticked
Please achieving this will be a great help so appreciate if anyone help me with it noting that my knowledge in VBA is very limited so if something required me to edit after i paste it please explain in details
Best regards,
I've been trying to extract a specific report from CMS to an Excel sheet using VBA codes but everything i end up with a disappointment. Please if anyone can write a script for me that i can paste in VBA it will be highly appreciated.
What i do to get the report is simply press on the below to reach it:
Commands - Reports - Then i select from the category "Split/Skill" then i select from the report "Agent Status by Location" - Split Skill will be " Let's not say in public " and Location IDs "4;43;45;1" - refresh every 30 seconds - Enable report threshold ticked
Please achieving this will be a great help so appreciate if anyone help me with it noting that my knowledge in VBA is very limited so if something required me to edit after i paste it please explain in details
Best regards,
Please Log in or Create an account to join the conversation.
3 years 9 months ago #735
by roller
Replied by roller on topic Export from CMS to Excel using VBA
It's very hard to get this working and debug without some intermediate VBA skills.
Please Log in or Create an account to join the conversation.
Time to create page: 0.426 seconds