Hi, I am currently doing a project which involves formatting spreadsheet in Access, like adding some patterns to cells or drawing some borders. It is weird that the Access will not let me use Excel cells's property keywords, for example,
The code "XXX.Weight = xlThin" does not work out on my side, and I have to use "XXX.Weight = 2" instead. Can I ask why?
Furthermore, when I try to add some patterns on cells. Access gave an error message said that the property ".PatternColorIndex" is failed to perform (sort of, I can not remember the exact word). What should I do about this? Thank you all in advance.
Regards,
Jason
The code "XXX.Weight = xlThin" does not work out on my side, and I have to use "XXX.Weight = 2" instead. Can I ask why?
Furthermore, when I try to add some patterns on cells. Access gave an error message said that the property ".PatternColorIndex" is failed to perform (sort of, I can not remember the exact word). What should I do about this? Thank you all in advance.
Regards,
Jason