Moving data from form to spreadsheet + VBA advice
 

What I have attempted to do is to convert a word document and macro into
an excel format to do the same as the original (automatically generate a
calibration certificate) however I am now a little stuck.

When I open the file (which will be a calibration certificate template
on sheet 2) I am automatically greeted with a dialogue box that prompts
me for the following

1. A 4 digit serial number
2. 2 tickbar or radio button boxes to select options a)Single
Certificate or b)Multi certificates. If multi certificates is ticked
then the first serial number data entry box will disappear and be
replaced by two serial number data entry boxes which will prompt for a
range i.e. First Number - Last Number
3. Data entry boxes where we can enter temperature, humidity , and
date.
4. Data box usually showing a permanent reference to the a source
directory where sequentially numbered text files are stored.
5.Active button "Generate" so that when clicked it will check the
integrity of the data entered above (i.e. valid serial no etc) and
bring all required data from the text file and populate it into the
relevant cell, it will also take the data entered into the data boxes
(temperature etc) and also populate those into the relavent cell.
6. Active button to "Quit" the program


I do not have a problem in bringing the data from the text files and
populating the relevant cells when hitting the generate button. The
bits that I am not sure how to do are

1. Get the information from the initial data form that pops into the
cell on the spreadsheet
2.The code for the multi generation of certificates
3.The word document auto printed the finished certificate but I want to
close it and save it automatically with the serial number as the name
i.e. 1234.xls


Any help will be greatly appreciated the spreadsheet and associated
text files + original word document can be found here

http://forum.lem.co.uk/showthread.php?p=1#post1


--
psipsi
------------------------------------------------------------------------
psipsi's Profile: http://www.excelforum.com/member.php...o&userid=26780
View this thread: http://www.excelforum.com/showthread...hreadid=400355