Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formatting an excel file

Status
Not open for further replies.
esengul

esengul

Instructor
Dec 9, 2004
59
US
afte i exported my data into excel ( DoCmd.TransferSpreadsheet...). How can i set the formatting settings such as fontsize, bgcolor, fontcolor... of this excel file?
Thank
 
Sort by date Sort by votes
You can record macros while performing each task, then see the code that Excel writes for you and cludge it all together into one big macro. You might want to hit the MS Office forum for help on that.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
I guess i wasn't clear with my question. I want to set my formatting settings in Access. 'cause everytime i export my data from access into excel, it creates a new file.
i hope it is clear now
thanks
ebru

 
Upvote 0 Downvote
would this help?

thread181-340749

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hermanlaksko
  • Question
Convert PDF file to text
Replies
6
Views
419
hermanlaksko
hermanlaksko
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
348
combo
combo
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
508
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
737
Andrzejek
Andrzejek
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68

Part and Inventory Search

Sponsor

Back
Top