Skip to main content
Share Your Experience: Take the 2024 Developer Survey
4 votes

Software to learn Excel VBA without buying Excel

One mechanism that you could possibly use would be to install a Virtual Manchine, such as Virtual Box, download one of the windows test images at https://developer.microsoft.com/en-us/microsoft-edge/...
Steve Barnes's user avatar
  • 31.6k
3 votes

"Honeypot" code to send me forensic data when stolen files are opened

I think something like canary tokens fit the bill here. See canarytokens.org and Thinkst Canary. Also I recommend also posting on infosec for more ideas.
Harv's user avatar
  • 141
2 votes
Accepted

What softwares should we use in creating a live web-based dashboard?

All of the above issues sound like they can be resolved with using Power BI. Power BI has come a long way and can now be embedded in PowerPoint files, plus you can view real time dashboards online via ...
makman's user avatar
  • 46
2 votes

"Honeypot" code to send me forensic data when stolen files are opened

The best solution for proving that someone is illegally accessing your computer is to have some information on there that you can prove is not true and could not have come from anywhere else that the ...
Steve Barnes's user avatar
  • 31.6k
2 votes

"Honeypot" code to send me forensic data when stolen files are opened

The simplest and least technologically sophisticated way to have something like this is likely an HTML document or an HTML email that links to an external image hosted in your server when opened in a ...
Lie Ryan's user avatar
  • 411
2 votes

Free tools to convert COBOL source code to VB6/VB.Net/C#/Java?

A conversion of complete programs is commonly not useful, given that COBOL commonly uses precompilers, both third-party (often for EXEC SQL and similar) and in-house ones (often for macro extensions) ...
Simon Sobisch's user avatar
2 votes
Accepted

Software to learn Excel VBA without buying Excel

In Europe (not sure about USA), it is legal to resell software licenses. When PCs are scrapped, companies who buy them for spare parts also run some software which extracts license key numbers, which ...
Mawg's user avatar
  • 9,023
1 vote

Software to learn Excel VBA without buying Excel

I found the best tutorial for this topic was through lynda.com: 3 hour tutorial, it assumes you know very basic programming already. The alternative is to use google spreadsheets + googlescripts, ...
Vincent Tang's user avatar
1 vote

Why do you chose to not use Microsoft Access to develop applications?

My organization’s experience has been that when we upgrade from one version of Access to the next - and on at least one occasion, when we applied a patch to Access - the saved code in the Access files ...
Jeff Zeitlin's user avatar
1 vote

Converting Visual Basic Code to .NET Framework

You can also consider the services of https://www.vbmigration.com/ VbMigration is headed by Francesco Balena, a great VB developer.
Maurizio Bellantone's user avatar
1 vote
Accepted

Converting Visual Basic Code to .NET Framework

You can take a look at https://phoenix.selise.ch/ for conversion to C#. They offer free consultation, so that may be a good way to estimate costs or understand exactly how their process works.
Md Ashaduzzaman's user avatar
1 vote

What softwares should we use in creating a live web-based dashboard?

You can use visualize javascript plugin such as AMCharts.js, D3.js, Chartjs to visualize your data but you need to have codding skills using javascript and use such libraries give you enough ...
burg.developer's user avatar
1 vote

VBA in Excel vs Access for data conversion

The features you gain from using a database make this a Access hand down winner. However, mysql/mariadb might be an even better choice long term. You will eventually need to learn SQL, but know it ...
cybernard's user avatar
  • 1,726
1 vote

Convert CSV file to another layout

I managed to get it working just using power query, though now I need to figure out how to automate the process of creating a CSV from this new data. I might end up using your solution if this turns ...
Ualati's user avatar
  • 11
1 vote

Convert CSV file to another layout

You can normalize crosstabbed data in the way that you want using a Python program named un-xtab.py. It can be installed from Python Package Index (PyPI) at https://pypi.org/project/un-xtab/. The ...
rd_nielsen's user avatar
1 vote

C# Library for manipulating Excel Files?

You can have a check on Spire.XLS for .NET library. Spire.XLS for .NET is a feature rich Excel library written in C#, it does not have any dependency on MS Office and can be easily applied to create,...
Rahul's user avatar
  • 11
1 vote

Library to modify Excel in Python

Pandas will work in 3.7.2. https://pandas.pydata.org/ This is a great tool for what you're looking to do.
C. Gaboury's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible