L
Legacy 241953
Guest
I'm working on a project where Amateur Radio operators would send and receive up to 83 lines of information on a medical form, say between one hospital to another, if the hospital's means of communication fail. The current way is a Word document that is printed out and the required lines are filled in, then that information is read over the radio and the receiving operator fills in the blanks on his side and delivers to the appropriate medical personnel. We have an email system in place that could also be used, but over the air rate is a blazing 1200 baud, and the printed Word form is 122KB, which takes over 12 minutes of air time to transmit with blank lines, and about the same length to receive. My idea was to take the 83 lines/fields of information and turn the information into a tab delimited text file to attach to the email, which would be imported and repopulate the form. In txt format, the file size is less than 1KB for the actual information.
Although I knocked it out in Filemaker Pro in a hour, I was unfamiliar with Excel much less VBA. Through some online research, I've managed to create a xlsm file in Excell 2007 with a UserForm that will input the field data on a row to "save as" a txt file for attachment to the email, then a second xlsm file to repopulate the field data on a similar UserForm by the receiving operator.
It wasn't until I tried it on a laptop computer that I found that the UserForm, which prints as a 8.5 X 11 sheet, was too large to view the command buttons (input data to row for the Transmit side, populate the form for the Receive, plus one for print and another for close) at the bottom. So I found the code for a vertical scrollbar. Problem now is when printed there's just the visible portion of the form, not the whole thing.
My question for the more experienced and informed is what would be the best way to go about printing? Websearches have confused me... should I even be printing the UserForm or is there some way of formatting the Worksheet to duplicate the look of the original Word form (with the appropriate cells populating the respective fields on it) and print that? My lack of experience with Excel has me looking for the proper keywords to use.
Any help is appreciated, apologies for the length of my first post but I figured the more background the better.
Although I knocked it out in Filemaker Pro in a hour, I was unfamiliar with Excel much less VBA. Through some online research, I've managed to create a xlsm file in Excell 2007 with a UserForm that will input the field data on a row to "save as" a txt file for attachment to the email, then a second xlsm file to repopulate the field data on a similar UserForm by the receiving operator.
It wasn't until I tried it on a laptop computer that I found that the UserForm, which prints as a 8.5 X 11 sheet, was too large to view the command buttons (input data to row for the Transmit side, populate the form for the Receive, plus one for print and another for close) at the bottom. So I found the code for a vertical scrollbar. Problem now is when printed there's just the visible portion of the form, not the whole thing.
My question for the more experienced and informed is what would be the best way to go about printing? Websearches have confused me... should I even be printing the UserForm or is there some way of formatting the Worksheet to duplicate the look of the original Word form (with the appropriate cells populating the respective fields on it) and print that? My lack of experience with Excel has me looking for the proper keywords to use.
Any help is appreciated, apologies for the length of my first post but I figured the more background the better.
Last edited by a moderator: