Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110511
| 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:16 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <p849rm$65c$1@dont-email.me> (permalink) |
| References | <g2maaddpsctst3hgn6kt5c9u6kt17gpugf@4ax.com> <XnsA8A276AF9B5F4auricauricauricauric@85.214.115.223> |
>
> 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.
--
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