[AccessD] Excel Question

[Stuart McLachlan]

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
>