[AccessD] Excel Question
fuller.artful at gmail.com
Fri Jan 21 19:35:32 CST 2022
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.
> On Fri, Jan 21, 2022 at 3:12 PM Arthur Fuller <fuller.artful at gmail.com>
> > 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
> Website: http://www.databaseadvisors.com
More information about the AccessD