PDA

View Full Version : VBA Data Transmission - Sound Output/Input



theta
10-25-2015, 06:17 AM
I have a very unique problem. I have thought of an idea to solve it (and act as a testing project to develop).


I work on a machine that has no USB and no method of FTP or data transmission. I often share files between this machine and my laptop but it requires me to burn it onto CDR then move it across.


This is costing me a fair amount in CDR's, and is slow process for quick changes.


The machine does allow VBA and VBS files to run. I would like to use the 3.5mm sound output on the old machine to transmit data to the laptop - that will also be running a VBA Excel macro (or VBA) to receive said data.


All data can be stored on the sheet or in memory before recompiling.


What is the best way of going about doing this? The end product would be a workbook containing excel macros to read a single file, convert into digital (binary/base64) and send over an analogue 3.5mm line. The same workbook, but on a receiving machine, would listen and then decode the data before recompiling it into a target file.

The functionality for encoding and decoding of base64 to create/compile files already exists within VB:
1. http://www.motobit.com/tips/detpg_base64encode/
2. http://www.source-code.biz/snippets/vbasic/12.htm
3. http://thydzik.com/vb6vba-functions-to-convert-binary-string-to-base64-string/
4. https://ghads.wordpress.com/2008/10/17/vbscript-readwrite-binary-encodedecode-base64/


Thoughts, suggestions, help, links all welcome :)



http://awesomegeekblog.blogspot.co.uk/2009/04/file-transfer-over-sound-card.html

SamT
10-25-2015, 08:32 AM
Many connections on the back of your computer can be used for machine to machine data transmission. Any computer repair facility can make you a cable for this and explain how to set up the computers to use it.