teleren/devto huggingface dataset:
How to Save the Current Workbook in 97-2003 Format in Excel!!
Tags: excelpreface, vbamacros, saveworkbook972003fo
Published: 2020-12-24 03:45:05

---
title: How to Save the Current Workbook in 97-2003 Format in Excel!!
published: true
date: 2020-12-23 12:31:15 UTC
tags: ExcelPreface,VBAMacros,saveworkbook972003fo
canonical_url: https://geekexcel.com/save-current-workbook-97-2003-format/
---

For instance, you have an Excel file that is created in the Excel 2013 version, and you need to open it in 2003 or later versions by default. How could you open the file? Because Excel 2003 or later versions cannot access the file that is created in Excel 2013 versions. In this case, you need to save the workbook in a 97-2003 format so that it can open in Excel 2003 or other lower versions.

Here is the tutorial to **save the Excel file in 97-2003 format**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **Steps to save the worksheet in 97-2003 format:**

Just follow the below steps to save the file.

### Step 1:

- First, you need to open your Excel file.
- Then, you need to click the **“File” ** tab in the current workbook.

![Open the file](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/save.png)<figcaption id="caption-attachment-20244">Open the file</figcaption>

- Here click the **“Save As”** , and you need to click the **“Browse”** button.

![Click save as](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Browse.png)<figcaption id="caption-attachment-20246">Click save as</figcaption>

- Click the **“Save as types”**.

![select workbook](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/select-workbook.png)<figcaption id="caption-attachment-20247">Select workbook</figcaption>

- It will expand the drop-down list as shown in the below image.
- And you need to select the **“Excel 97-2003 Workbook”** from the list.

![Select 97-2003](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/select-97-2003.png)<figcaption id="caption-attachment-20248">Select 97-2003</figcaption>

- Now, click the “Save” button.

![Save](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/EXCEL_L4n6QW0Nn6.png)<figcaption id="caption-attachment-20249">Save</figcaption>

## **Wrap-Up:**

From this guide, you can get some clarification on **how to save the current workbook in 97-2003 format in Excel**. Please share your **query** below in the **comment** box. We will assist you. Thank you so much for visiting our site!!

### Read Also:

- **[Excel VBA Operators in Office 365 with Examples!!](https://geekexcel.com/excel-vba-operators/)**
- **[Excel VBA String Functions in Office 365 ~ Work with String Functions!!](https://geekexcel.com/excel-vba-string-functions-office-365/)**
What's the most unique portfolio you have seen?
Tags: watercooler, webdev, portfolio
Published: 2020-12-23 12:27:51

---
title: What's the most unique portfolio you have seen?
published: true
description: 
tags: watercooler, webdev, portfolio
cover_image: https://lh3.googleusercontent.com/proxy/cVRkY2Y87_nfRVkTQc4eGGxZfw_ae-vx_TSeTLrIet94zE0_HEdbrzvk4H3Cx5jBD_IswSvvmrMDOKHc4sHVk_gJmhagNUSMrQdrYgrTKelmyMVQtYg0SbH4gnbXNi8_1NM_x4SH9OoWEbIqVsYS5qNkIBB2iA
---
Could you recall some portfolios that stood out due to their uniqueness and creativity? Something extraordinary, one of the kind. Share them below!

To start off, I'm gonna give it to [Ben](https://benhalpern.com/) and [Jake](https://jakealbaugh.com/).
Case sensitivity in SQL
Tags: sql, database, sqlite, unicode
Published: 2020-12-23 12:22:20

Of course, by default SQL keywords and identifiers are case insensitive. In additional, SQLite LIKE is case-insensitive _only for ASCII._

However, case-sensitive identifiers can be enabled in PostgreSQL, but not SQLite.

https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Data_structure_definition/Delimited_identifiers

Situation helps greatly, if you can compile your own SQLite, perhaps natively, or with Rust or [Golang](https://github.com/mattn/go-sqlite3).

As for unicode-enabled SQLite case-sensitive LIKE, I have seen people compile their own COLLATION in Rust.
Document ready Vanilla JS
Published: 2020-12-23 12:20:31

```
document.addEventListener("DOMContentLoaded", function() {

});
```
```
var ready = (callback) => {
  if (document.readyState != "loading") callback();
  else document.addEventListener("DOMContentLoaded", callback);
}

ready(() => { 
  /* Custom JS */ 
});
```
Fetch using useReducer!
Tags: react, webdev, hooks, usereducer
Published: 2020-12-23 12:18:20

In this post, we will gonna see how to make a *Fetch* request with the help of the *useReducer* hook.

This is our reducer function,

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/usd2u2tfa7pt46bavuak.JPG)

Let's have a look at our functional component,

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/v7hz85g28ok3ctmhbqc0.JPG)

Complete Code:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/pgexetdtom2zlicw7omw.JPG)

*I hope it might help you!*

*Happy coding!*

*-Jayant khandelwal*
What web analytics tools do you use?
Tags: discuss, webdev, analytics
Published: 2020-12-23 12:13:18

---
title: What web analytics tools do you use?
published: true
description: 
tags: discuss, webdev, analytics
cover_image: https://www.octoboard.com/static/assets/imports/octocat/google-analytics-audience-template.png
---
Web analytics is the measurement, collection, analysis, and reporting of web data to understand and optimize web usage.

Aside from [Google Analytics](https://analytics.google.com), what tools are you using?
Adding Login, Onboarding, and other Flows to your Xamarin.Forms App
Tags: xamarinforms, mobile
Published: 2020-12-23 12:10:18

Xamarin.Forms makes it extremely simple to add a flyout menu or tab bars when using Shell scaffolding. Adding a login page or any other flow of content that is separate from the main navigation is also really easy, though it's not immediately obvious just *how* easy. This video shows you how to use the route parsing order of Shell to interject a login page (and a registration modal), and manage the navigation stack so users cannot use the Android back button to bypass your application navigation.

This same technique may be used to have different sets of tabs, and mix-match with flyouts or other structures of content (onboarding for example).

{% youtube f1uYhDjvem4 %}

#### Resources:
* [Docs: Shell Navigation](https://docs.microsoft.com/xamarin/xamarin-forms/app-fundamentals/shell/navigation)

{% github davidortinau/ShellLoginSample %}
Node.js - Data persistency and a custom parser
Tags: node, javascript, database
Published: 2020-12-23 12:09:01

Hey folks!

This is my second entry on my "devlog" for my database project, today I've started working on the data persistency and in the parsing of more complex inputs (strings with more than one word).

---

### New functionalities 

* Data persistency: now whenever I call the command "using" or "create" or "insert" the database is writing itself to disk with the .ldb extension (it is still a JSON, I just made this so it would not keep triggering the nodemon whenever I made a change to any table)

Example:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/5i6bp2kpye3ntwvsmqsa.png)

* Parsing strings with multiple words: in yesterday's version it wasn't possible to pass parameters with multiple words, now I've made a custom parser that supports it 

Example:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/dxnnihnz8156bobwd0qy.png)

---

### Code structuring changes

First of all, I've cleaned some of my code, the parser file was getting way too big, so I moved some things around, this is my new structure:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/xztwmne9jnv2zms13scn.png)

* commandExecutor: holds references for each command
* database: returns the memory instance of the current database, allows me to set it to a new value, and saves the database
* parser: transforms the input string into an array of commands and parameters

and the commands folder holds a file for each possible command:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/3iexhe0r5m5eaa2oksia.png)

---

### Conclusion

loving to work on this project, I didn't even mean to write about it again before Christmas, but I was so happy with this morning's results that I could not wait

and again, this is the repository for this project, if anyone wants to check it out: 

{% github ciochetta/learndb %}
Control Access to Pages and Routes in Xamarin.Forms
Tags: xamarinforms, mobile
Published: 2020-12-23 12:04:19

Xamarin.Forms Shell has an `IsVisible` property you can use to show/hide pages from the flyout menu and tabs, and control if those pages are routable based on any criteria such as authorization role.

{% youtube 6QZp9nERxvg %}

#### Resources:
* [Docs: Shell Tabs](https://docs.microsoft.com/xamarin/xamarin-forms/app-fundamentals/shell/tabs#shellcontent-class)
* [Docs: Messaging Center](https://docs.microsoft.com/xamarin/xamarin-forms/app-fundamentals/messaging-center)

{% github davidortinau/ShellLoginSample %}
Jest SyntaxError: Unexpected token 'export'
Tags: jest, react, testing, rtl
Published: 2020-12-23 10:45:18

In this post, I'm not going to explain how to configure react-testing-library and Jest, there is a lot of useful information about it. This time I'm going to talk about a specific error: `SyntaxError: Unexpected token 'export'`.

I spent 2 days trying to figure out what was causing the error as my configuration was working fine and I could test some simple components until I tried to test a component which is using an external dependency, in my case `react-day-picker`.

```javascript
// MyCoolComponent.jsx

import 'react-day-picker/lib/style.css';

import React, {useState} from 'react';
import PropTypes from 'prop-types';

import AsyncSelect from 'react-select/async/dist/react-select.esm';
import DayPicker, {DateUtils} from 'react-day-picker';
import MomentLocaleUtils from 'react-day-picker/moment';
...
// the rest of the component's code
```

The component works fine with this imports
```javascript
import AsyncSelect from 'react-select/async/dist/react-select.esm';
import DayPicker, {DateUtils} from 'react-day-picker';
import MomentLocaleUtils from 'react-day-picker/moment';
```
but Jest doesn't like it and throws a `SyntaxError: Unexpected token 'export'`

I tried different things, like play around with `.babelrc` and some dependencies, `moduleNameMapper` and `transformIgnorePatterns` in `jest.config.js`, and the last one was close but I was still missing one important thing... the `imports`.

So the final fix was:
1. Update the `imports`
```javascript
import AsyncSelect from 'react-select';
import DayPicker, {DateUtils, LocaleUtils} from 'react-day-picker';
```
2. Add those dependencies to `transformIgnorePatterns` in `jest.config.js`
```javascript
...
transformIgnorePatterns: [
  '/node_modules/(?!react-select)',
  '/node_modules/(?!react-day-picker)',
],
...
```
Probably it was caused by hurrying up writing a component and autocompleting an import with an IDE help. For Webpack it is fine because it passes all the code through Babel, links all dependencies, and transpile them to vanilla js which in Jest's case isn't.

I still have doubts about, drop me a comment, and let's discuss it :)

Happy coding, thanks for reading.

Thanks [@kazukyakayashi](https://unsplash.com/@kazukyakayashi) for the picture.
Ajax Tutorial for Beginners
Published: 2020-12-23 11:43:55

Ajax is a technology for web development that utilizes HTML, CSS, XML, and Javascript to build better, quicker, and more immersive web applications. With Ajax, web applications can send and receive data from a server asynchronously without interfering with the display and actions of the current page. Ajax is a technology for a web browser that is independent of the applications for web servers. You can find the best Ajax tutorial for Beginners if you are a fresher and you find the best Ajax tutorial point for building a website using Ajax. Our Ajax tutorial point for beginners will allow you to learn step-by-step about Ajax technologies from basics to advanced topics. https://www.phptpoint.com/ajax-tutorial/
Best PST recovery tool to repair and recover corrupt PST files
Published: 2020-12-23 11:42:20

Hi all, Use an  Outlook PST Recovery as this can recover as well as convert all your files to any other format like PST, MBOX, and other formats like PST, EML, DBX, MSG, PST safely. It will help you create a backup and remove corruption. It comes with 3 modes of recovery- Standard deep and advanced to deal with different levels of corruption that can arise in Outlook PST.

Visit-https://www.data-recovery-solutions.com/pst-recovery.php
How to Clean Up Your AWS Resources in 5 Minutes?
Published: 2020-12-23 11:31:24

Do you want to save your AWS bills? Look at "Nuke".

Cloud-Nuke is a tool for cleaning up your cloud accounts by nuking (deleting) all resources within it. It's open source tool and hosted under [GITHUB](https://github.com/gruntwork-io/cloud-nuke)

[**Caution: Please do note that this tool is not intended for the production environment]

## Getting Started with Cloud Nuke

## Pre-requisite

- Ensure that you have ```aws configure``` configured. 

### Download 

- Linux System

```
wget https://github.com/gruntwork-io/cloud-nuke/releases/download/v0.1.24/cloud-nuke_linux_amd64
```

If you're on MacOS, ensure that you pick up 

```
wget https://github.com/gruntwork-io/cloud-nuke/releases/download/v0.1.24/cloud-nuke_darwin_amd64
```


### Move the binary to a folder on your PATH. 

```
mv cloud-nuke_darwin_amd64 /usr/local/bin/cloud-nuke.
```

### Add execute permissions to the binary. 

```
chmod u+x /usr/local/bin/cloud-nuke
```

Test it installed correctly: 

```
cloud-nuke --help.
```

That's it. Run the below CLI to clean up the overall AWS resources.

```
sudo cloud-nuke aws
INFO[2020-12-23T11:33:42Z] The following resource types will be nuked:  
INFO[2020-12-23T11:33:42Z] - ami                                        
INFO[2020-12-23T11:33:42Z] - asg                                        
INFO[2020-12-23T11:33:42Z] - ebs                                        
INFO[2020-12-23T11:33:42Z] - ec2                                        
INFO[2020-12-23T11:33:42Z] - ecscluster                                 
INFO[2020-12-23T11:33:42Z] - ecsserv                                    
INFO[2020-12-23T11:33:42Z] - eip                                        
INFO[2020-12-23T11:33:42Z] - ekscluster                                 
INFO[2020-12-23T11:33:42Z] - elb                                        
INFO[2020-12-23T11:33:42Z] - elbv2                                      
INFO[2020-12-23T11:33:42Z] - lambda                                     
INFO[2020-12-23T11:33:42Z] - lc                                         
INFO[2020-12-23T11:33:42Z] - rds                                        
INFO[2020-12-23T11:33:42Z] - s3                                         
INFO[2020-12-23T11:33:42Z] - snap                                       
INFO[2020-12-23T11:33:43Z] Retrieving active AWS resources in [eu-north-1, ap-south-1, eu-west-3, eu-west-2, eu-west-1, ap-northeast-2, ap-northeast-1, sa-east-1, ca-central-1, ap-southeast-1, ap-southeast-2, eu-central-1, us-east-1, us-east-2, us-west-1, us-west-2] 
INFO[2020-12-23T11:33:43Z] Checking region [1/16]: eu-north-1  
```

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ie0rzp8vipeeuiw2ijhk.png)
How Odoo ERP System Can Help Your Business In 2021
Tags: odoo, blog, erp, business
Published: 2020-12-23 11:20:54

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/uqbpu9fed58qybkmzbkr.jpg)

As we all know Odoo may be a business management software bundled with many modules including Accounting, CRM, E-commerce, Inventory, HRMS, and lots of more. Odoo was formerly referred to as Open ERP and was founded by Fabien Pincakers in 2005. The word Odoo stands for On-Demand Open Project. the rationale why it's named Odoo is that it's an Open Source Software and it are often customized consistent with the business needs. Since the launch of Odoo in 2005, It’s been leading the ERP software market with 5 Million Satisfied user’s across the world.

Many businesses use several different software systems to manage the various aspects of their business, for instance, QuickBooks for accounting, SalesForce for CRM, and PeopleMatter for human resources. Oftentimes these different software solutions cannot communicate with one another, complicating matters and leaving much room for errors when data must be transferred from one platform to a different one. Using Odoo means having all of those functions, plus far more, integrated into one software, employing a different module for every business need. This facilitates the sharing of data between the modules, reducing errors, and time needed to finish tasks.

For many, their business is simply a begin. For few their business may be a small scale and that they cannot make big investments. For other, their business could also be an outsized scale but their investments are made already hence they're trying to find something which will help them mapped out during a minimal. Odoo is such platform where you'll have your business solution with least expenditure. It updates itself constantly. it's a bit like the other apps that have time to time messages or notification for any updates. it's open-source software and it doesn't have licensing fee.

Read more> [https://techultrasolutions.com/blog/our-blog-1/how-odoo-erp-system-can-help-your-business-in-2021-10](https://techultrasolutions.com/blog/our-blog-1/how-odoo-erp-system-can-help-your-business-in-2021-10)
What is Identity Proofing and Why is it Important

Tags: identityproofing, customeridentitymanagement, loginradius, digitalidentity
Published: 2020-12-23 10:48:00

Identity proofing is the process of verifying that the claimed identity of a person matches their real identity. You’ve most likely gone through this process a lot of times yourself at hotels, financial institutions, and retailers.

Importance of Improved Identity Proofing

Your Personally Identifiable Information (PII), including your bank account details and security questions, fall in the possession of fraudsters who can misuse your information fraudulent transactions. 

To epitomize, identity proofing is particularly valuable when a user is attempting to claim an account, access content over a certain age, or register for an e-commerce site.

Ensure Your Business Identity With LoginRadius CIAM Solutions 

1. Multifactor Authentication or MFA: Multi-factor authentication conquers the defects of typical password-based confirmation and commands it for a user to check the claim to a record through two or more methods. 

2. Password Management Solution: LoginRadius identity and access management (CIAM) solutions offer a secret phrase the board that helps make traditional password key-based identity proofing more secure in itself. 

By improving privacy, the identity proofing process helps fabricate a trustable image in the consumers' psyches towards your brand. 

To additionally strengthen your framework's environment, LoginRadius' tools uphold restricted access and stave off automated assaults on your framework.

See more: https://www.loginradius.com/blog/start-with-identity/2020/12/identity-proofing/
CodeReveiwers - DO Hackathon post submission
Tags: dohackathon
Published: 2020-12-23 09:59:43

## What I built
I built [CodeReviewers](https://codereviewers.gq), a website that allows you to post code for others to review. CodeReviewers does not only that, but also allows you to edit your code online, but also give suggestions to the developer on how they can improve their code.

### Category Submission: 
**Built for Business** because I feel that many businesses and enterprises will use this app to test out their developers.

### App Link
[codereviewers.gq](https://codereviewers.gq)

### Screenshots
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/322s0g7jq1zpe0fohosk.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/6srzvgsfp05o6wyibk6c.png)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/dksjv1v6bp9ujrdiumbl.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/81qxaz7n62pzhponzwha.png)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/nn9m58csk93cmag5gy3i.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ie0vr02vu9umrt6r3ydq.png)

### Description
Code reviewers is a website/webapp that allows you to upload code for others to rate, review and suggest changes. It helps developers fix bugs in their code and to get to know each other.

### Link to Source Code
Frontend: [github.com/arnu515/code-reviewers](https://github.com/arnu515/code-reviewers)

Backend: [github.com/arnu515/code-reviewers-backend](https://github.com/arnu515/code-reviewers-backend)

### Permissive License
MIT

## Background
I was inspired by Github and the open source nature of git. These two things allowed developers to collaborate with each other, but learning git and Github was like learning a new language alltogether, so, I decided to make an app that allows developers to collaborate and contribute to each others' code without all of the fuss.

### How I built it 
DigitalOcean's App Platform made it really easy for me to deploy my code. At first, I decided to deploy my frontend on App Platform and my backend on a Droplet, but I came to know that DigitalOcean's App Platform supported Dockerfiles, which made it much easier to deploy. I also used a Redis and PostgreSQL database, both provided by DigitalOcean, that integrated well with App Platform. Finally, I used DigitalOcean Spaces for storing files.

### Additional Resources/Info
None