Sarkis has attended:
Excel VBA Advanced course
Excel VBA
Hi,
Is it possible to setup a network connection using VBA in excel between 2 PCs?
The idea is to have messages flowing back and forth between the 2 PCs so information is kept up to date in real time.
Thanks,
Sarkis
RE: Excel VBA
Hi Sarkis, thanks for your query. It is possible, but difficult, and you'd almost certainly not do it in Excel VBA but simply run a messaging application outside of Excel. However, if you want to go down that route you could download a messaging control (.ocx file) and embed that on the spreadsheet. Alternatively, copy any written Excel message out to a text file on a shared folder, which is then checked and uploaded to the receivers spreadsheet every, say, five seconds, and vice versa. That would be the quickest win using standard text file write/read procedures, a timer and the Do Events statement.
Hope this helps,
Anthony