[AccessD] Excel Question

Rocky Smolin rockysmolin2 at gmail.com
Fri Jan 21 22:05:10 CST 2022


I NEVERF use macros in my code.  But for creating automation code that
works the recorder can't be beat.

r

On Fri, Jan 21, 2022 at 5:35 PM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Thanks, Rocky. I've not used macros much, but shall give it a whirl. In
> years past, I've written some fairly complex Excel code, but tody I've
> learned more about Excel VBE than in the past several years.
>
> On Fri, Jan 21, 2022 at 7:13 PM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
> > Firat - about the limits - if you;re anywhere near the limit of
> worksheets,
> > I'd say you're using the wrong tool.
> >
> > Regarding setting any property in Excel - virtually everything can be
> done
> > from code. I've done a lot of automating from Access - setting column
> > headings, bolding, setting column widths, formulas - everything.  The
> trick
> > is not know the VBA code to do these things but to use the macro
> recorder,
> > do what would do manually, like select a row and then bold everything
> > selected, and then stop the macro recorder and look at the code it
> > generated. It's mostly a cut and paste job.
> >
> > r
> >
> > On Fri, Jan 21, 2022 at 3:12 PM Arthur Fuller <fuller.artful at gmail.com>
> > wrote:
> >
> > > I am creating an Excel workbook from VBA code. I need to know this: Is
> > > there a maximum number of sheets in a Workbook?
> > > I also need to know if there is a way to programmatically set the
> > > column-widths (equivalent to moving the cursor to the right edge of a
> > > column then double-clicking).
> > >
> > > And finally, how can I set row 1 (containing the headers to Bold?
> > >
> > > --
> > > Arthur
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list