I have two worksheets. One is the data sheet, the other is a form. When I run the program that populates the template, it doesn't retain the format on the form. How can I set it so that it protects the integrity of the form.


jbond007

Did you use excel 2007 to make the template?
You need to use excel 2003.

I am using excel 2003. There has to be a way to keep the formatting intact.

Is you Webfocus report being loaded into a separate sheet? If not, you are writing over your form. You specify the sheet number in your hold/pchold statement. If you are alreading doing this, try saving the workbook as format .xls.

I have two sheets. One is where the report is (sheet 1). The other (sheet2) is where the form is. I also tried saving it as an excel, but
samething happened. What I ended up doing is creating two files. One (MHT) and the other an excel worksheet with just the form. The worksheet with the form is setting at the local drive and pointing to the data file.