#1   Report Post  
Old November 5th 20, 06:49 PM posted to microsoft.public.excel.programming
JJG JJG is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 2
Default VBA


Hi.
I have Excel 2013 and I program with VBA.
Anyone know if VBA would be in the latest versions of Excel?
In version 365, macro automation creates Typecript code.
VBA works in the latest version.
Regards.

  #2   Report Post  
Old November 5th 20, 07:46 PM posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 92
Default VBA

On 11/5/2020 11:49 AM, JJG wrote:

Hi.
I have Excel 2013 and I program with VBA.
Anyone know if VBA would be in the latest versions of Excel?
In version 365, macro automation creates Typecript code.
VBA works in the latest version.
Regards.


MS cannot possibly drop support for VBA -- too much code out there
relies on it.

They may choose to feature something else, but it can't go away.

--



  #3   Report Post  
Old November 5th 20, 11:38 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 532
Default VBA

dpb wrote:

On 11/5/2020 11:49 AM, JJG wrote:

Hi.
I have Excel 2013 and I program with VBA.
Anyone know if VBA would be in the latest versions of Excel?
In version 365, macro automation creates Typecript code.
VBA works in the latest version.
Regards.


MS cannot possibly drop support for VBA -- too much code out there
relies on it.

They may choose to feature something else, but it can't go away.


I have 365 here. I can say for sure that VBA is included, and there aren't
any notes or anything saying things like "deprecated" or "do not use".

--
The Guide is definitive. Reality is frequently inaccurate.
  #4   Report Post  
Old November 6th 20, 03:13 PM posted to microsoft.public.excel.programming
JJG JJG is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 2
Default VBA

El jueves, 5 de noviembre de 2020 a las 19:38:35 UTC-3, Auric__ escribió:
dpb wrote:

On 11/5/2020 11:49 AM, JJG wrote:

Hi.
I have Excel 2013 and I program with VBA.
Anyone know if VBA would be in the latest versions of Excel?
In version 365, macro automation creates Typecript code.
VBA works in the latest version.
Regards.


MS cannot possibly drop support for VBA -- too much code out there
relies on it.

They may choose to feature something else, but it can't go away.

I have 365 here. I can say for sure that VBA is included, and there aren't
any notes or anything saying things like "deprecated" or "do not use".

--
The Guide is definitive. Reality is frequently inaccurate.

Thanks guys for the reply!

Auric, if you create a macro in 365, what code does it generate?
VBA or Typescrip?
  #5   Report Post  
Old November 7th 20, 11:06 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 532
Default VBA

JJG wrote:

El jueves, 5 de noviembre de 2020 a las 19:38:35 UTC-3, Auric__ escribió:
dpb wrote:

On 11/5/2020 11:49 AM, JJG wrote:

Hi.
I have Excel 2013 and I program with VBA.
Anyone know if VBA would be in the latest versions of Excel?
In version 365, macro automation creates Typecript code.
VBA works in the latest version.
Regards.

MS cannot possibly drop support for VBA -- too much code out there
relies on it.

They may choose to feature something else, but it can't go away.

I have 365 here. I can say for sure that VBA is included, and there aren't
any notes or anything saying things like "deprecated" or "do not use".


Thanks guys for the reply!

Auric, if you create a macro in 365, what code does it generate?
VBA or Typescrip?


VBA, when recording a macro. The editor is still the normal VBA editor, and
doesn't support any other language AFAICT. I don't even know where/how to
look for typescript. Searching the help system returns no relevant results.

VBA is the only thing that keeps me on "modern" Excel. If they remove it,
I'll probably drop back to Office 2007. Or maybe 2000, the majority of my
code runs there.

....I might do that anyway.

--
- How has humanity lasted this long?
- Because sharks can't walk.


  #6   Report Post  
Old November 8th 20, 12:07 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2018
Posts: 6
Default VBA

On 8-Nov-2020 11:06 am, Auric__ wrote:
JJG wrote:

El jueves, 5 de noviembre de 2020 a las 19:38:35 UTC-3, Auric__ escribió:
dpb wrote:

On 11/5/2020 11:49 AM, JJG wrote:
Hi.
I have Excel 2013 and I program with VBA.
Anyone know if VBA would be in the latest versions of Excel?
In version 365, macro automation creates Typecript code.
VBA works in the latest version.
Regards.
MS cannot possibly drop support for VBA -- too much code out there
relies on it.

They may choose to feature something else, but it can't go away.
I have 365 here. I can say for sure that VBA is included, and there aren't
any notes or anything saying things like "deprecated" or "do not use".

Thanks guys for the reply!

Auric, if you create a macro in 365, what code does it generate?
VBA or Typescrip?

VBA, when recording a macro. The editor is still the normal VBA editor, and
doesn't support any other language AFAICT. I don't even know where/how to
look for typescript. Searching the help system returns no relevant results.

VBA is the only thing that keeps me on "modern" Excel. If they remove it,
I'll probably drop back to Office 2007. Or maybe 2000, the majority of my
code runs there.

...I might do that anyway.


I've been using Excel 2000 almost exclusively since 2000 or whenever it
first appeared. I've occasionally had to use a more "modern" version of
Excel and haven't liked it - I can't adjust to that ribbon.

VBA with Excel 2000 seems to do everything I need, and I am not aware of
any new feature in VBA in the more recent Excel versions from which I
could benefit. Can anyone provide a good reason for upgrading?

  #7   Report Post  
Old November 8th 20, 04:46 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 532
Default VBA

malone wrote:

On 8-Nov-2020 11:06 am, Auric__ wrote:

[snip]
VBA is the only thing that keeps me on "modern" Excel. If they remove it,
I'll probably drop back to Office 2007. Or maybe 2000, the majority of my
code runs there.

...I might do that anyway.


I've been using Excel 2000 almost exclusively since 2000 or whenever it
first appeared. I've occasionally had to use a more "modern" version of
Excel and haven't liked it - I can't adjust to that ribbon.

VBA with Excel 2000 seems to do everything I need, and I am not aware of
any new feature in VBA in the more recent Excel versions from which I
could benefit. Can anyone provide a good reason for upgrading?


Only if you want to open spreadsheets in the .xlsx format.

I only upgraded to 2007 because my ex-sister-in-law gave me her old copy,
when she upgraded to... uh... whatever the next version was. I have 365 now
for various reasons.

--
Who are you to deny her reality in favor of your own?
  #8   Report Post  
Old November 22nd 20, 10:01 AM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 1
Default

Excel Programming with VBA Best Ebook, try the reference for everyone

Excel 2019 Power Programming with VBA
https://www.readallbooks.org/book/ex...ming-with-vba/

Excel VBA 24-Hour Trainer 2nd Edition
https://www.readallbooks.org/book/ex...r-2nd-edition/


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017