Exporting to excel

S

Stlr19

I have a public folder that my company is using a custom
form to track Referral's. I have a Macro written so that
all of the data is dumped into an excel spread sheet but I
am not sure how to sixe the cells and change the fonts.
The Macro is in outlook not in excel.
 
K

Ken Slovak - [MVP - Outlook]

Set a Range in your code and then you can set the Range properties
such as Font, Width, Height and so on. Range also has an AutoFit
method. Use the Object Browser to look at the properties and methods
of the Range object for help on this and to see which properties and
methods are available to you.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm
 

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

Word to Excel: Export comments with text and line number 0
Access Access - Is it possible to repeat fields in a form? 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA Macro that Runs nightly to export folder 0
Access Access variable string for export 0
Export to Excel 3
export table from outlook to excel 0
Copying Data from Exchange to PST file 1

Top