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