Formatting Excel spreadsheet in Access

J

Jason Yin

Joined
May 23, 2008
Messages
1
Reaction score
0
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Excel using Access VBA 1
Border formatting row of cells 22
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Conditional formating 4
Export Data from Queries in Access 2007 to Excel Spreadsheet 1
Exporting Data from Access To Excel 10
Using Data in an Access Form to fill in Excel Spreadsheet 2
Cut & Paste in Excel without erasing cell borders? 1

Back
Top