Click here to Skip to main content
15,884,598 members

The Insider News

   

The Insider News is for breaking IT and Software development news. Post your news, your alerts and your inside scoops. This is an IT news-only forum - all off-topic, non-news posts will be removed. If you wish to ask a programming question please post it here.

Get The Daily Insider direct to your mailbox every day. Subscribe now!

 
GeneralRe: Microsoft announces Windows Server 2022 with new security features Pin
David O'Neil2-Mar-21 11:14
professionalDavid O'Neil2-Mar-21 11:14 
GeneralRe: Microsoft announces Windows Server 2022 with new security features Pin
markrlondon3-Mar-21 2:50
markrlondon3-Mar-21 2:50 
GeneralRe: Microsoft announces Windows Server 2022 with new security features Pin
Dan Neely3-Mar-21 3:05
Dan Neely3-Mar-21 3:05 
NewsHow many hours of work pay the internet bill? Pin
Kent Sharkey2-Mar-21 10:46
staffKent Sharkey2-Mar-21 10:46 
GeneralRe: How many hours of work pay the internet bill? Pin
Nelek3-Mar-21 20:28
protectorNelek3-Mar-21 20:28 
NewsIntroducing Microsoft Power Fx: the low-code programming language for everyone Pin
Kent Sharkey2-Mar-21 9:46
staffKent Sharkey2-Mar-21 9:46 
GeneralRe: Introducing Microsoft Power Fx: the low-code programming language for everyone Pin
David O'Neil2-Mar-21 11:23
professionalDavid O'Neil2-Mar-21 11:23 
GeneralRe: Introducing Microsoft Power Fx: the low-code programming language for everyone Pin
markrlondon3-Mar-21 3:03
markrlondon3-Mar-21 3:03 
David O'Neil wrote:
Is that an implicit acknowledgment that most Excel users aren't good enough coders to be considered programmers? Unsure | :~

In my very humble opinion, there is no shame in saying this. It is undoubtedly true. Surely most Excel users are people who want to store and manipulate data; why should they be programmers.

What I do not get, however, is how or why this new language will change anything. The whole point of VBA was that it was an easy to use macro language that non-programmers could use with little additional effort. Now we have a shiny new language that non-programmers could use with little additional effort.

Was VBA not easy enough?

Are people more stupid today?

I suppose that people do increasingly expect "I want to do more, it has to be easy, it has to just work" and if ActiveFX... err I mean if PowerFX can do that more easily than VBA then so be it. I can see Microsoft's thinking in terms of basing it on Excel functions which are at least familiar to Excel users.

But I very, very strongly suspect that this will give rise to a whole new class of errors. If it succeeds in not merely displacing VBA but in opening up macro programming to a much wider range of end users then the new style of non-coding errors will make old fashioned faulty corporate and home spreadsheets look like mere typos.

David O'Neil wrote:
(And anyone who uses Excel as a database should wear a scarlet letter, or something, and be unhirable. Unless management won't allow them to purchase any DB, and won't allow MySQL or an equivalent. Then management should be the ones with the scarlet letter, and unhirable.)

Isn't this a "getting things done expediently" and "getting things done with minimal or no budget requirement" issue. Excel has the sweet spot of the ability to store data coupled with a useable UI (which is configurable with quickly learnable skills). In contrast, making a database that useful requires a lot more work to get to the same spot.

I fully accept and agree that, beyond a certain point of complexity, moving to a database is important but at that point it's going to require either skills that the end user doesn't have, time that the end user doesn't have, or a not-insignificant budget approval. Real life (both at home and in business) means that the spreadsheets often soldier on.

I can see how Microsoft might be thinking that PowerFX will in part address this situation. Bolting on PowerFX as a programmable front end to Access (alongside VBA, not instead of it) might help migration to an extent.
GeneralRe: Introducing Microsoft Power Fx: the low-code programming language for everyone Pin
David O'Neil3-Mar-21 7:16
professionalDavid O'Neil3-Mar-21 7:16 
GeneralRe: Introducing Microsoft Power Fx: the low-code programming language for everyone Pin
Nelek3-Mar-21 20:30
protectorNelek3-Mar-21 20:30 
GeneralRe: Introducing Microsoft Power Fx: the low-code programming language for everyone Pin
markrlondon4-Mar-21 4:49
markrlondon4-Mar-21 4:49 
GeneralRe: Introducing Microsoft Power Fx: the low-code programming language for everyone Pin
Marc Clifton3-Mar-21 6:01
mvaMarc Clifton3-Mar-21 6:01 
GeneralRe: Introducing Microsoft Power Fx: the low-code programming language for everyone Pin
David O'Neil3-Mar-21 7:09
professionalDavid O'Neil3-Mar-21 7:09 
NewsMicrosoft shows off its Mesh mixed-reality collaboration platform Pin
Kent Sharkey2-Mar-21 8:01
staffKent Sharkey2-Mar-21 8:01 
GeneralRe: Microsoft shows off its Mesh mixed-reality collaboration platform Pin
Nelek3-Mar-21 20:32
protectorNelek3-Mar-21 20:32 
GeneralRe: Microsoft shows off its Mesh mixed-reality collaboration platform Pin
Kent Sharkey3-Mar-21 20:43
staffKent Sharkey3-Mar-21 20:43 
NewsHackers exploit websites to give them excellent SEO before deploying malware Pin
Kent Sharkey2-Mar-21 8:01
staffKent Sharkey2-Mar-21 8:01 
GeneralRe: Hackers exploit websites to give them excellent SEO before deploying malware Pin
Nelek3-Mar-21 20:36
protectorNelek3-Mar-21 20:36 
NewsAutomate tasks with Power Automate Desktop for Windows 10—no additional cost Pin
Kent Sharkey2-Mar-21 7:16
staffKent Sharkey2-Mar-21 7:16 
GeneralRe: Automate tasks with Power Automate Desktop for Windows 10—no additional cost Pin
  Forogar  2-Mar-21 10:35
professional  Forogar  2-Mar-21 10:35 
NewsVisual Studio 2019 v16.9 and v16.10 Preview 1 are Available Today! Pin
Kent Sharkey2-Mar-21 7:01
staffKent Sharkey2-Mar-21 7:01 
NewsIntroducing the .NET Upgrade Assistant Preview Pin
Kent Sharkey2-Mar-21 7:01
staffKent Sharkey2-Mar-21 7:01 
GeneralRe: Introducing the .NET Upgrade Assistant Preview Pin
Dan Neely3-Mar-21 3:09
Dan Neely3-Mar-21 3:09 
NewsScientists have invented light-up OLED tattoos Pin
Kent Sharkey1-Mar-21 10:31
staffKent Sharkey1-Mar-21 10:31 
GeneralRe: Scientists have invented light-up OLED tattoos Pin
raddevus1-Mar-21 12:02
mvaraddevus1-Mar-21 12:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.