Macro/Page Setup Issue - Converting Excel to PDF

Normally we like to work with sample workbooks which means they have enough data to prove the point and not the entire history of the company. Try cutting down the amount of data to several dozen or several hundred records. If that doesn't do it, then save the file in XLSB format (they can be 40% smaller) and finally, if that doesn't work, compress the workbook and attach the *.zip file to the post.

I commend you on a very thorough attempt to make this application portable and creating the form must have taken days. You put a lot of good work into this.

I noticed that as I stepped through the code, that it detected my OS as Windows 7 - 32 Bit. My system is Windows 7 - 64 Bit. Nonetheless, I produced a good PDF file. I also conducted a test with my laptop (Windows 7 - 32 Bit) and it identified the OS correctly and produced a good PDF file. So I have not been able to duplicate the bad condition.

I suggest that this might be the area to investigate. Hopefully you can round up different machines with the various OS. Hopefully some people will chime in here.

A note to testers, comment out the if statement that checks if all the questions have been answered. The macro is in the module AA_Master_Codes. Otherwise it will take a while to fill the form out. Fill in the information for Machine SN and Machine Stock # as these fields are used to create the file name. The file should wind up on your desktop.