Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #111219
| From | Adrian Caspersz <email@here.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Getting Office Version Number from Excel VBA |
| Date | 2019-11-29 11:33 +0000 |
| Organization | Keep Usenet Text Newsgroups Alive!! |
| Message-ID | <h4ce0uFrcqrU1@mid.individual.net> (permalink) |
| References | <ad4d08d9-8aa1-4554-afab-4bea85ccc4b0@googlegroups.com> |
On 29/11/2019 10:01, Raymond Allan wrote: > Hi, > > I am using verNum = Application.Version to pull the current office version, without declaring the variable it brings in 16.0, when declaring this as a single it only brings in 16, 16.0 is required as I am using this to read & write registry setting. Declare the variable as Variant -- Adrian C
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Getting Office Version Number from Excel VBA Raymond Allan <rafmedit@gmail.com> - 2019-11-29 02:01 -0800
Re: Getting Office Version Number from Excel VBA Adrian Caspersz <email@here.invalid> - 2019-11-29 11:33 +0000
Re: Getting Office Version Number from Excel VBA Raymond Allan <rafmedit@gmail.com> - 2019-12-02 03:11 -0800
csiph-web