>>NHS IT.
It doesn't surprise me. Miss Z reports totally different software running between her last trust and her current trust. Two DG hospitals in the current trust have different patient care software packages.
She had to write a paper for publication a while back for her last trust. Huge amount of data to sort and it wasn't in a consistent format.
I wrote some code in VBA to sort the different formats of data in to one flat file so that it could at least be sorted, filtered, added up, averaged and pivoted.
One of the problems probably security. They see email as vulnerable to attack hence printing out the workbooks. You can password protect workbooks and zip them to encrypted files.
The second complaint I have seen with emailing Excel files from numerous sources is that it takes an age to extract the attachments and save them down to a common folder.
Years ago now, I wrote a piece of VBA for Outlook that looked at each email in an account and if there was a matching file attachment it automatically saved it to a specified folder. It then opened each Excel workbook in the folder in turn and copied the data to a master workbook. Seriously - if I could do it then any half competent programmer could do it!!!
The NHS still use bleepers (life savers in the depths of a hospital) and fax machines - they are reliable.
Banks are notoriously slow for IT changes. We only moved to Windows 10 in 2019 and from Excel 2007 at the same time. Compatibility with existing apps is the main issue.
Last edited by: zippy on Sat 10 Oct 20 at 17:06
|