Format exported Excel cells

G

Guest

I was created export to Excel in this form for about 50 products:

Private Sub Command3_Click()
DoCmd.TransferSpreadsheet 1, 8, "Product1", "D:\Export.xls", True
DoCmd.TransferSpreadsheet 1, 8, "Product2", "D:\Export.xls", True
DoCmd.TransferSpreadsheet 1, 8, "Product3", "D:\Export.xls", True
...
EndSub

How I can in this code insert date formating for B column in every exported
sheet in time format h:mm?
Thanks!
 
G

Guest

You can't do any formatting with TransferSpreadsheet.
If you need to do any formatting from Access to an Excel sheet, you will
need to use Automation.
 

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

Format export to Excel 4
URGENT HELP! Export to Excel Template multiple cells 1
help on a formula (match and etc..) 1
Access export to excel produces "unreadable data" 0
Importing Access query to Excel 3
expected format 3
export to excel - automatic wrap text 3
Date format problem 2

Top