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

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