I think it was a reference error I dont believe I had the correct reference checked to run the ADODB connection.

ok couple quick questions can you highlight the things i need to change because it says that it cant activex can't create object and Set Conn = CreateObject("adobe.Connection")

Sorry for being...