[AccessD] Excel Question

[Arthur Fuller]

Thanks, all.

On Fri, Jan 21, 2022 at 11:26 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Excel calls VBA Subs"macros"  It doesn't have macros in the sense that
> Access does.
>
> When you "record a macro", it builds a VBA Sub  in a Standard VBA module.
>
> On 21 Jan 2022 at 20:05, Rocky Smolin wrote:
>
> > 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
> > >
> > --
> > 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