ST Alpha - "BTW, I just remembered something I did at a previous employer" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

In response to "Guys, I'm gonna be super geeky about helicopters for a little while. This is my new toy. So, apparently when the airspace is closed," by loosilu

BTW, I just remembered something I did at a previous employer

Posted by zork Apr 16 '21, 08:09

Don't know if they ever needed to modify it but has to do with an Excel file I did with crazy macros.

There were hidden sheets and a lot of locked down stuff with the VBA locked as well. You had to enter 99919 in a certain cell to be able to unlock it.

It also would read data from one or two external files. Those filenames were hard coded in and they had to be in the same directory as the main file.

Responses:

At some point, excel programs need to be replaced by computer programs - just for the ease of documentation and maintenance. -- nm - Beryllium Apr 16, 08:23 1
- python replacing vba? -- (link) - zork Apr 16, 08:41 [youtube]

Post a message top

BTW, I just remembered something I did at a previous employer

Replies are disabled on threads older than 7 days.