formatting

**Spitfire999** · 07-26-2007, 09:19 AM

Good morning everyone, I have a pretty simple task that I am trying to accomplish, but as I am still completely incompetent when it comes to VBA I call upon your help.

The following code opens up a new excel spreadsheet with a bunch of information pulled form an access database. I have cut out most of it, with the exception of the code relating to excel.

Please Login or Register  to view this content.

The following is what I need to accomplish:

All of the columns need to be auto fit, as well as word wrapped. With the exception of the comments column, where only the heading needs to be auto fit, then the rest can be word wrapped.

Initial inquiry date, last updated, order date need to be formated as dates.
Blended Margin and probability of order need to be formated as percentages

Thanks very much in advance.
-Ben-

**antoka05** · 07-26-2007, 10:16 AM

Try to use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

**Spitfire999** · 07-26-2007, 10:24 AM

Where should I enter it.

Sorry, I really am pretty hopeless

**Spitfire999** · 07-26-2007, 10:34 AM

Actually, I was able to get it working, but for some reason the auto fit isn't doing anything

**Spitfire999** · 07-26-2007, 04:16 PM

Anyone have any suggestions?

**antoka05** · 07-27-2007, 03:22 AM

I think 'AutoFit' doesn't work with wrapped text

In this case try to add these two new rows:

Please Login or Register  to view this content.

before of these rows:

Please Login or Register  to view this content.

Regards,
Antonio

**Spitfire999** · 07-27-2007, 01:22 PM

Hmm, for some reason it still is not working, and I really don't see why It wouldn't. I don't think word wrap was being used to begin with (I suspected that there may be some conflict between wrap and autofit, and now I am sure that it is not wrapping it.

Anything else you may suggest.

**antoka05** · 07-27-2007, 03:29 PM

Please attache a little example of your workbook... it isn't easy to help without see the file.

Regards,
Antonio

**Spitfire999** · 07-27-2007, 03:41 PM

The code that you see above, that opens the workbook is actually in access. The macro I put above is the only thing that relates to the excel workbook. When I do run it however the output looks like the following attachment.