convert integer value column to list

I have a column i want to convert it to list .
Example-
CODE
34
45
65
76
78
56
91
83
94
85
48
39

i want to covert it list; output should look like 
'34','45','65', '76','78','56','91','83','94','85','48','39'

then want to store this list in a macro..