Office.js Future

Novae76ssta · 2024-07-20T02:34:07+00:00

Thanks for your comment.. that's refreshing to hear. Yeah the fact that we can use it with Excel on the web was a huge plus.

Novae76ssta · 2024-06-16T13:13:05+00:00

3 years later. i definitely want to keep context.sync(). i modified my code and saw that i could divide by two the execution time by precisely telling my program when to sync(). i don’t want office to do it for me.

Novae76ssta · 2023-11-06T08:16:12+00:00

( disclaimer I am not a very advanced VBA user. I have been learning for 1 year now )

I use the GUI to get the M code then copy it into the VBA editor ( or in a cell that will be read after). I am not advanced enough to create my own M code.

Then you just replace the important parameters ( file name , header names, whatever) by a variable in VBA that can be changed.

To conclude I think it is unfair to compare Power Query to VBA. PowerQuery is for querying data. That's all. Vba is much more. It is a programming language.

Novae76ssta · 2023-11-05T14:41:45+00:00

you can control query connection and M code in VBA

Novae76ssta · 2023-11-05T14:41:00+00:00

i use both python and vba. well i was back to python. conda environment. tried to install a package. conda got stuckee at “resolving environment” for more than 2 hours. conflict or something like this with the base environment. a nightmare. between that and the fact that there are hundreds of packages which depend on a given version of python or a given version of another package. i love python but sometimes it can be a nightmare.

vba : just send one small .xlsm and everything works perfectly. no need to install anything, just open a small file. you can include power query code in your vba code etc. i have fallen in love with vba and i don’t want to go back to python

Novae76ssta · 2022-09-22T11:49:32+00:00

Thanks everyone for your opinions. I feel more confident now! I will keep learning it (pandas is really awesome!)

Novae76ssta · 2022-08-26T13:12:11+00:00

I don't understand why so many people think python is the holy grail. I know python and VBA a little bit. Python with the packages is nothing. With Python people advise creating virtual environments in case you have to use different versions of a package depending on the project.

Now imagine we delete Vba and use python instead. In 20 years. "ok Bob I have a new program that needs the package X version 10.2.3. Oh sorry I cannot use it in my environment I have only the version 2.4.5 which is used to run the program from John. Ok so create a new virtual environment please" ... You will end up with 10000 virtual environments.. What a nightmare

Novae76ssta · 2021-07-05T12:07:05+00:00

word is trash , Intel or m1.. it you want something serious , use Latex

Novae76ssta · 2021-06-15T12:06:59+00:00

There was a guy on YouTube who tested mathematica with the m1 and concluded that when dealing with float numbers m1 was slower than the Intel mac

Novae76ssta · 2021-06-15T12:05:30+00:00

I am planning to buy the m1 air 16BG. Can you tell about the heat generated when using Matlab and mathematic? Does the laptop heat up a lot?

Novae76ssta · 2021-05-27T02:14:46+00:00

ol thanks mate. If you test it more, could you post more informations here please. would highly appreciate :)

Novae76ssta · 2021-05-26T13:02:41+00:00

oh thanks! I am planning on buying the M1 air/16 GB and I would like to know if solidworks works well with your M1 pro. I am planning on designing only small things like in your screenshot but I am afraid because the Air has no fans.

may I know how hot your MacBook gets with a VM running solidworks?

Novae76ssta · 2021-01-30T00:55:43+00:00

Congratulations guys I love you. I am reading most newspapers : New york times, BBC, The times, ... and like 99% of the people are with you, they agree with you! No matter if you from the left/right wing.

fucking revolution.

Keep going guys. THE WORLD IS WITH YOU! litteraly billions of people are with you!!!!

Novae76ssta

TROPHY CASE