Jump to content

Excell/VBA DOCSS Dialer

From Squirrel's Lair
Revision as of 19:38, 2021 October 31 by Ttenbergen (talk | contribs)
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.


  • need file, zipped, to have all parts together.
  • Actioned 2021-10-31


  • Cargo

{{#cargo_store: _table = ToDo |what=computer |question=

  • need file, zipped, to have all parts together.

|actionDt={{subst:Now}} }}


  • troubleshoot why this works over some phone lines but not others.
  • Actioned 2021-10-31


  • Cargo

{{#cargo_store: _table = ToDo |what=computer |question=

  • troubleshoot why this works over some phone lines but not others.

|actionDt={{subst:Now}} }}



  • Cargo

{{#cargo_store: _table = Project | shortDescription = File that plays DTMF tones based on numeric entries in an Excel file. | longDescription = 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.


  • need file, zipped, to have all parts together.
  • Actioned 2021-10-31


  • Cargo

{{#cargo_store: _table = ToDo |what=computer |question=

  • need file, zipped, to have all parts together.

|actionDt={{subst:Now}} }}


  • troubleshoot why this works over some phone lines but not others.
  • Actioned 2021-10-31


  • Cargo

{{#cargo_store: _table = ToDo |what=computer |question=

  • troubleshoot why this works over some phone lines but not others.

|actionDt={{subst:Now}} }}

| geekery = | mainImage = Squirrelslair.png | skillSet = Programming; Visual Basic for Applications(VBA) | projectType = Office Automation | northForge = No }}

  • Categories


  • Default form