467,925 Members | 1,807 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,925 developers. It's quick & easy.

WrapText in Docmd

Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "table1", path
How to use the WrapText property to allign the cells according to the content of the table?
Feb 28 '09 #1
  • viewed: 1588
2 Replies
Expert Mod 16PB
What WrapText property?

What actually do you want to achieve?
Feb 28 '09 #2
Expert 8TB
The only way that I see this happening is:
  1. Export the Table to an Excel Spreadsheet as previously indicated.
  2. Open the Spreadsheet via Automation Code, then apply this Property to specific Cells as needed.
  3. The Syntax (within Excel) would be:
    Expand|Select|Wrap|Line Numbers
    1. Worksheets("Sheet1").Range("B1").WrapText = True
  4. I imagine that the problem would be to determine when and where to apply this logic.
  5. Good Luck.
Feb 28 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

15 posts views Thread by Thelma Lubkin | last post: by
2 posts views Thread by Mike | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.