Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110513
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: File Path Issue in Excel 2016 for Mac |
| Date | 2018-03-11 18:50 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <p84brb$otp$1@dont-email.me> (permalink) |
| References | <g2maaddpsctst3hgn6kt5c9u6kt17gpugf@4ax.com> <XnsA8A276AF9B5F4auricauricauricauric@85.214.115.223> <p849rm$65c$1@dont-email.me> <XnsA8A29FF4B775Eauricauricauricauric@85.214.115.223> |
> GS wrote: > >>> Sub whereAmI() >>> Cells(1, 1).Value = ActiveWorkbook.Path >>> End Sub >> >> Just a minor point, but depending on context it's a very important point! >> >> VBA 'best practice' suggests: >> >> - use ActiveWorkbook only when the code is acting on or referencing a >> workbook other than itself; >> >> - use ThisWorkbook when code refs the workbook running the code. > > Good point. I figured since you program in other languages that you'd pick up on the 'This' part of an object ref-ing itself! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
File Path Issue in Excel 2016 for Mac colglbo <bcolglbo@gmail.com> - 2018-03-11 12:27 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-11 18:40 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-11 18:16 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-11 22:43 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-11 18:50 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-12 03:46 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-12 01:08 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-12 06:00 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-12 04:04 -0400
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-03-14 17:34 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-15 02:25 -0400
Re: File Path Issue in Excel 2016 for Mac Patrick <patrick@nowhere.invalid> - 2018-03-12 07:59 +0100
Re: File Path Issue in Excel 2016 for Mac colglbo <bcolglbo@gmail.com> - 2018-03-12 07:47 -0400
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-12 19:22 -0700
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-04-13 08:46 -0400
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-16 21:48 -0700
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-04-20 19:50 +0100
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-21 00:17 -0700
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-04-21 05:00 -0400
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-04-23 22:19 +0100
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-04-23 22:11 +0100
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-23 21:07 -0700
csiph-web