access query reports to excel formatting help

[fastmike]

hi. i am really very new in excel programming. i did not even knew that we can do some programming in Excel until last week when i came up with a problem. i hope you guys can help me out. but first let me tell you i dont have no clue about programming in excel. so treat me like a newbie and i will really appreciate that.
i have created a database in Msaccess. i have 3 buttons for my reports based on my query in my access form.
1) Problems resolved[Field Names(Problems(text), Short description(text), Long description(Memo), DateOpen(text), Date Closed(Text)].
2) Problems not resolve(Same as Above)
3) Problems all(Same As Above)
In access i am using an onclick button procedure through VB for all my 3 buttons which is as follow:
Private Sub Problems_not_resolve_Click()
DoCmd.OutputTo acReport, "Problems not resolved", acFormatXLS
End Sub
when a user clicks on any of the button it will give him an option to save the file in his computer in an excel worksheet in which i have accomplished. now here is what my problem is searched alot with different answers but cannot understand it since i am a newbie in this programming.
my problem is when a user opens that file he recently saved in his computer through that onclick button procedure in excel, the whole formatting is bad. Long description field text has the cell width too much or some fields width is too short that the whole description cannot be displayed properly. my question is that is there anyway that when a user save that file and open that file the excel worksheet should be perfectly formatted without doing any manually resizing ? please help me. i am stuc k with this thing for like 9 days now and this is the end of my database.
Thanks alot

[Kernow Girl]

Hi Fastmike - does it have to be done exactly in this way? Take a look at
Data/Import External Data in Excel. You can link the ss to the .mdb file, and
each time it opens it re-links and updates the data. It can be linked to a
Table or Query and you can then alter the Excel side of the Query. I have set
up 20 workstations doing this and many of the ladies do there own 'ad hoc'
links. You can then say to either keep or not keep the formatting.

HTH - Dika

"fastmike" wrote:

>
> hi. i am really very new in excel programming. i did not even knew that
> we can do some programming in Excel until last week when i came up with
> a problem. i hope you guys can help me out. but first let me tell you i
> dont have no clue about programming in excel. so treat me like a newbie
> and i will really appreciate that.
> i have created a database in Msaccess. i have 3 buttons for my reports
> based on my query in my access form.
> 1) Problems resolved[Field Names(Problems(text), Short
> description(text), Long description(Memo), DateOpen(text), Date
> Closed(Text)].
> 2) Problems not resolve(Same as Above)
> 3) Problems all(Same As Above)
> In access i am using an onclick button procedure through VB for all my
> 3 buttons which is as follow:
> Private Sub Problems_not_resolve_Click()
> DoCmd.OutputTo acReport, "Problems not resolved", acFormatXLS
> End Sub
> when a user clicks on any of the button it will give him an option to
> save the file in his computer in an excel worksheet in which i have
> accomplished. now here is what my problem is searched alot with
> different answers but cannot understand it since i am a newbie in this
> programming.
> my problem is when a user opens that file he recently saved in his
> computer through that onclick button procedure in excel, the whole
> formatting is bad. Long description field text has the cell width too
> much or some fields width is too short that the whole description
> cannot be displayed properly. my question is that is there anyway that
> when a user save that file and open that file the excel worksheet
> should be perfectly formatted without doing any manually resizing ?
> please help me. i am stuc k with this thing for like 9 days now and
> this is the end of my database.
> Thanks alot
>
>
> --
> fastmike
> ------------------------------------------------------------------------
> fastmike's Profile: http://www.excelforum.com/member.php...o&userid=36723
> View this thread: http://www.excelforum.com/showthread...hreadid=564493
>
>