Excell/VBA DOCSS Dialer: Difference between revisions
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
|longDescription=Physicians in Manitoba use [http://docss.net/ DOCSS] to submit their billing. The system requires the user to dial in on a phone and press the right phone buttons to submit the info. The process is tedious. We created an Excel file using [[VBA]] to play DTMF phone sounds based on the contents of the excel file to automate the call-in process. | |longDescription=Physicians in Manitoba use [http://docss.net/ DOCSS] to submit their billing. The system requires the user to dial in on a phone and press the right phone buttons to submit the info. The process is tedious. We created an Excel file using [[VBA]] to play DTMF phone sounds based on the contents of the excel file to automate the call-in process. | ||
{{ | {{To Do | | ||
* need file, zipped, to have all parts together. }} | * need file, zipped, to have all parts together. }} | ||
{{ | {{To Do | | ||
* troubleshoot why this works over some phone lines but not others. }} | * troubleshoot why this works over some phone lines but not others. }} | ||
|skillSet=Programming; Visual Basic for Applications(VBA) | |skillSet=Programming; Visual Basic for Applications(VBA) | ||
| Line 12: | Line 12: | ||
|northForge=No | |northForge=No | ||
}} | }} | ||
[[Category:In-process projects]] | [[Category:In-process projects]] | ||
Latest revision as of 20:24, 2021 October 31
| Projects | |||||
| {{#cargo_query:
tables=Project |
fields=CONCAT("File:",mainImage,"" )= | where=_pageName="Excell/VBA DOCSS Dialer" | format=list | default=
}} | |
| Project: | Excell/VBA DOCSS Dialer (I) | ||||
| Description: | File that plays DTMF tones based on numeric entries in an Excel file. | ||||
| Skillset(s) : |
{{#cargo_query: tables=Project |
fields=skillSet | where=_pageName = "Excell/VBA DOCSS Dialer" | format=list | default= No skillsets
}} |
| Project Type(s) : |
{{#cargo_query: tables=Project |
fields=projectType | where=_pageName = "Excell/VBA DOCSS Dialer" | format=list | default= No project type
}} |
Physicians in Manitoba use DOCSS to submit their billing. The system requires the user to dial in on a phone and press the right phone buttons to submit the info. The process is tedious. We created an Excel file using VBA to play DTMF phone sounds based on the contents of the excel file to automate the call-in process.
|
|
|
|
|
|
|