Hi.
TL;DR:
I need to buy a new computer as a secondary machine in case my Windows laptop breaks down. I hope it doesn't have to be with Windows, but it's more likely that I have to get a Windows PC to use Excel and VBA and later figure out how to transition to Linux, some other spreadsheet software and another programming language.
Any advice is greatly appreciated.
I came to this forum because I hope to avoid some big mistakes. I can't afford to plunge into a new system head first. My situation is unusual, so I don't expect a quick fix.
I can't expect to understand everything at the first reading. So, if people keep answering my questions here, I'll keep asking new ones that build on the previous ones.
If you notice that I missed something and I'm asking the wrong questions, I'll be happy if you warn me.
My first two questions:
Is there some timing, speed or frequency of replies that you expect from me? Or you would notice a new entry if I return to a thread that I have not touched for months and it doesn't matter when do I return to it?
Feel free to be a pushy fanboy for your favorite distro, desktop environment, file manager, virtual machine or any trick that would fit my situation.
I'll be happy to read your reasons why your solution is the best and why everything else smells from a mile away.
I REALLY want to leave all Microsoft software. But I need a plan that I can understand.
I expect this transition to take years with a lot of learning because I assume that I will have to find an alternative to replace my code in VBA that I use daily in Excel.
I have to be in FULL control of the timing of restart for updates.
The decision by Microsoft to disable that particular freedom of choice in Windows 10 is that "last straw" that broke the camel's back. They pushed me now to be willing to invest as much time as necessary to get rid of Microsoft.
Very soon I want to buy a new computer as breakdown cover alternative. I want that backup machine sooner than I can learn everything about Linux.
Now I have only one computer (Lenovo 17" laptop, Windows 10). If it breaks down, I'm screwed big time.
I hope that new computer does NOT have to be with Windows, but I assume that using Excel and VBA on Linux is tricky at best. Has anyone made that work reliably? WINE? VM?
If it can't be done, I have to buy a Windows machine for backup AGAIN.
Maybe that's what I should do and later figure out how to transition to Linux, maybe on a third computer with a pre-installed distro.
But long term I need to transition from Windows to Linux, from Excel to some alternative, from VBA to some alternative, from WinCMD (the original version of Total Commander) to some alternative and an alternative to Notepad++ if it doesn't work on Linux.
But for the start I would like to figure out whether it's possible to use Excel with my already existing VBA code on Linux.
I'm looking for advice for
(1) choosing the right
(1.1) hardware (CPU, RAM, storage etc) that will allow smooth transition (I know about SLIMBOOK and their tower machines), it may be laptop or desktop (minimum 17 inch display with FullHD, no other screen resolution)
(1.2) OS with commercial support that I can rely on as a customer (Zorin?)
(1.3) fast and customizable desktop environment where a dark theme works flawlessly, I don't need animation to show what I just did, I use keyboard shortcuts like ALT-TAB to swap between windows FAST and control most actions with the keyboard (Cinnamon? XFCE?)
(1.4) file manager (Double Commander? Krusader? Can I back up their settings and use a text editor to modify their ini files or some similar settings files? Do they allow personalized button bars with my own icons that can run terminal commands, e.g. open a file in the appropriate software or open specific directories in the file manager or run internal commands of the file manager?)
(1.5) scripting language and spreadsheet software combination (python? Open Office? Can I create buttons like on the quick access toolbar of excel?)
(1.6) A WAY TO RUN EXCEL AND THE VISUAL BASIC EDITOR in Linux until I learn a replacement language to VBA and I rewrite my VBA code in that other language (WINE? Bottles?)
(2) choosing the right sequence to get and learn the alternatives.
For now I'm forced to use Windows 10 by a breakdown of my old computer that was on Windows 8.1.
I already bought the new laptop before the breakdown but I was not yet ready for the transition when the breakdown happened.
The reason why I refused to update the old computer to Windows 10 was that Windows 10 has no option to entirely disable a forced restart for updates.
Now I'm stuck with random restarts without my permission. I know about postponing for 7 days in the settings, but that works only up to a month, and it does not allow to set a specific timing anyway.
I HATE Microsoft. I'm pulling my hair EVERY TIME they kill my work.
I don't have customers and I'm NOT looking for a situation where I would have to deal with people (including working for someone or have someone work for me).
I do my banking through my laptop, using Brave or Chrome, and I use an Android phone for verification.
This can change in the long term:
Most of my VBA code is in 3 *.xlam files that weigh total 395KB.
The most frequently used code is probably less than 5% of that.
The VBA code is usually simple, used mostly to find and copy specific data from CSV to a spreadsheet or to the clipboard or to format spreadsheets (e.g. make the opened CSV black with white text) or for user defined functions for spreadsheets.
I don't plan intensive coding for now. I just need to use what I already programmed.
I can see myself replacing that with an alternative language, but I will have to learn it, so I can't leave Excel immediately.
I expect python to be a likely reasonable choice but I have not started practicing it yet. Only watched a few tutorial videos. I attempted some installations to start learning python, but wasn't able to get it all to work. All of that was on the old computer that broke down, and I don't have time to repeat any of that setup now.
This can change in the VERY long term: I code in Pinescript on Tradingview, and I use Brave or Chrome to view the results and download them in CSV files for more advanced analysis.
Most of the analysis is done through spreadsheet formulas, not VBA code.
Long term I might learn to code communication with the API of some trading platform directly, circumventing Tradingview.
I run my VBA code from various means in Excel:
the Quick Access Toolbar buttons,
the ribbon (added my own tab),
buttons in worksheets.
I still use WinCMD (the old version of Total Commander) because it never failed me and it allows me
- to set keyboard shortcuts to the internal commands of the file manager and
- to create personalized menus and button bars that don't need installation.
I can modify those menus and button bars in any text editor and back up their files (*.ini for menus or *.bar for button bars).
I can use my customized icons on these button bars.
Both the menus and the button bars can
- open specific directories in the file manager or in Windows Explorer,
- open files in the appropriate software,
- run internal commands of the file manager (e.g. open a GUI to set file attributes or copy the file date to the clipboard).
There are only two drawbacks of WinCMD:
- 32-bit, so for some system directories I have to use Windows Explorer,
- it can't display thumbnails of images and videos, but I rarely need that.
Best regards, I hope you're all doing fine, and I mean that financially and mentally, not in any propagandistic political fear mongering way.
TL;DR:
I need to buy a new computer as a secondary machine in case my Windows laptop breaks down. I hope it doesn't have to be with Windows, but it's more likely that I have to get a Windows PC to use Excel and VBA and later figure out how to transition to Linux, some other spreadsheet software and another programming language.
Any advice is greatly appreciated.
I came to this forum because I hope to avoid some big mistakes. I can't afford to plunge into a new system head first. My situation is unusual, so I don't expect a quick fix.
I can't expect to understand everything at the first reading. So, if people keep answering my questions here, I'll keep asking new ones that build on the previous ones.
If you notice that I missed something and I'm asking the wrong questions, I'll be happy if you warn me.
My first two questions:
Is there some timing, speed or frequency of replies that you expect from me? Or you would notice a new entry if I return to a thread that I have not touched for months and it doesn't matter when do I return to it?
Feel free to be a pushy fanboy for your favorite distro, desktop environment, file manager, virtual machine or any trick that would fit my situation.
I'll be happy to read your reasons why your solution is the best and why everything else smells from a mile away.
I REALLY want to leave all Microsoft software. But I need a plan that I can understand.
I expect this transition to take years with a lot of learning because I assume that I will have to find an alternative to replace my code in VBA that I use daily in Excel.
I have to be in FULL control of the timing of restart for updates.
The decision by Microsoft to disable that particular freedom of choice in Windows 10 is that "last straw" that broke the camel's back. They pushed me now to be willing to invest as much time as necessary to get rid of Microsoft.
Very soon I want to buy a new computer as breakdown cover alternative. I want that backup machine sooner than I can learn everything about Linux.
Now I have only one computer (Lenovo 17" laptop, Windows 10). If it breaks down, I'm screwed big time.
I hope that new computer does NOT have to be with Windows, but I assume that using Excel and VBA on Linux is tricky at best. Has anyone made that work reliably? WINE? VM?
If it can't be done, I have to buy a Windows machine for backup AGAIN.
Maybe that's what I should do and later figure out how to transition to Linux, maybe on a third computer with a pre-installed distro.
But long term I need to transition from Windows to Linux, from Excel to some alternative, from VBA to some alternative, from WinCMD (the original version of Total Commander) to some alternative and an alternative to Notepad++ if it doesn't work on Linux.
But for the start I would like to figure out whether it's possible to use Excel with my already existing VBA code on Linux.
I'm looking for advice for
(1) choosing the right
(1.1) hardware (CPU, RAM, storage etc) that will allow smooth transition (I know about SLIMBOOK and their tower machines), it may be laptop or desktop (minimum 17 inch display with FullHD, no other screen resolution)
(1.2) OS with commercial support that I can rely on as a customer (Zorin?)
(1.3) fast and customizable desktop environment where a dark theme works flawlessly, I don't need animation to show what I just did, I use keyboard shortcuts like ALT-TAB to swap between windows FAST and control most actions with the keyboard (Cinnamon? XFCE?)
(1.4) file manager (Double Commander? Krusader? Can I back up their settings and use a text editor to modify their ini files or some similar settings files? Do they allow personalized button bars with my own icons that can run terminal commands, e.g. open a file in the appropriate software or open specific directories in the file manager or run internal commands of the file manager?)
(1.5) scripting language and spreadsheet software combination (python? Open Office? Can I create buttons like on the quick access toolbar of excel?)
(1.6) A WAY TO RUN EXCEL AND THE VISUAL BASIC EDITOR in Linux until I learn a replacement language to VBA and I rewrite my VBA code in that other language (WINE? Bottles?)
(2) choosing the right sequence to get and learn the alternatives.
For now I'm forced to use Windows 10 by a breakdown of my old computer that was on Windows 8.1.
I already bought the new laptop before the breakdown but I was not yet ready for the transition when the breakdown happened.
The reason why I refused to update the old computer to Windows 10 was that Windows 10 has no option to entirely disable a forced restart for updates.
Now I'm stuck with random restarts without my permission. I know about postponing for 7 days in the settings, but that works only up to a month, and it does not allow to set a specific timing anyway.
I HATE Microsoft. I'm pulling my hair EVERY TIME they kill my work.
I don't have customers and I'm NOT looking for a situation where I would have to deal with people (including working for someone or have someone work for me).
I do my banking through my laptop, using Brave or Chrome, and I use an Android phone for verification.
This can change in the long term:
Most of my VBA code is in 3 *.xlam files that weigh total 395KB.
The most frequently used code is probably less than 5% of that.
The VBA code is usually simple, used mostly to find and copy specific data from CSV to a spreadsheet or to the clipboard or to format spreadsheets (e.g. make the opened CSV black with white text) or for user defined functions for spreadsheets.
I don't plan intensive coding for now. I just need to use what I already programmed.
I can see myself replacing that with an alternative language, but I will have to learn it, so I can't leave Excel immediately.
I expect python to be a likely reasonable choice but I have not started practicing it yet. Only watched a few tutorial videos. I attempted some installations to start learning python, but wasn't able to get it all to work. All of that was on the old computer that broke down, and I don't have time to repeat any of that setup now.
This can change in the VERY long term: I code in Pinescript on Tradingview, and I use Brave or Chrome to view the results and download them in CSV files for more advanced analysis.
Most of the analysis is done through spreadsheet formulas, not VBA code.
Long term I might learn to code communication with the API of some trading platform directly, circumventing Tradingview.
I run my VBA code from various means in Excel:
the Quick Access Toolbar buttons,
the ribbon (added my own tab),
buttons in worksheets.
I still use WinCMD (the old version of Total Commander) because it never failed me and it allows me
- to set keyboard shortcuts to the internal commands of the file manager and
- to create personalized menus and button bars that don't need installation.
I can modify those menus and button bars in any text editor and back up their files (*.ini for menus or *.bar for button bars).
I can use my customized icons on these button bars.
Both the menus and the button bars can
- open specific directories in the file manager or in Windows Explorer,
- open files in the appropriate software,
- run internal commands of the file manager (e.g. open a GUI to set file attributes or copy the file date to the clipboard).
There are only two drawbacks of WinCMD:
- 32-bit, so for some system directories I have to use Windows Explorer,
- it can't display thumbnails of images and videos, but I rarely need that.
Best regards, I hope you're all doing fine, and I mean that financially and mentally, not in any propagandistic political fear mongering way.
Last edited: