Re: How can I format Excel Spreadsheet in OutpuTo Macro?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

rashar,
macros are a bit limited in what they can accomplish compared with using vba
code instead.
If you search these discussion groups, you will find many examples using vba
code to format an excel spread***.
Unfortunately, a macro is just not the correct tool to use for this.

Jeanette Cunningham -- Melbourne Victoria Australia


"rashar via AccessMonster.com" <u9200@uwe> wrote in message
news:840c3dd4e5cd8@xxxxxx
Hello,

I've created a macro that takes the contents of a table, and dumps the
data
into an excel spread***. What I would like to do is somehow format that
data as it arrives in the excel spread*** so that I can tell at a glance
which data is new.

So is there a way to possibly bold the data that is being transferred to
an
excel *** using the OutputTo Macro?

Thanks in advance.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-macros/200805/1



.

Quantcast