Explore Web Dev on Experts Exchange

Expert Solutions for Your Web Dev Problems

Web DevWeb Development

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and ...

Read more
  • 1M Content
  • 81K Contributors

Expert Spotlight
Citrix Technology Professional / Director of TechDev Services, IPM

40+ years of consulting. Citrix CTP. Citrix CCP-N, and ShareFile certified. PowerShell, MS Office, VBA, ASP.Net (C#/VB.Net).

Article
WordPress 5.5.3 Update Breaks Site

WordPress Update 5.5.3 Broke my Website

I always make backups of my website before upgrading WordPress, but this time, I decided not to bother and sure enough, Murphy's law struck - it broke my website! This article explains how I fixed it without a backup. The process wasn't easy to find, so I hope this Step by Step helps you out.
Article
A look at PDF Wrench

PDF Wrench - A free new way to manipulate PDF files

2
A new and innovative way to manipulate PDF Documents and Images in the browser without having to upload your documents to the cloud. Includes an interview with the site owner and creator.
Article

Add Security Protections for Data Extraction

The Get & Transform Data Wizard in Excel is a powerful tool. It allows the users to extract the data from the connected sources. But by delegating the privilege to users to access the connected sources, how could we ensure there is at least some degree of security is in place?
Article

Developer's Choice: Tools for Web Data Visualization

2
This article explores the benefits of a dashboard as a tool for data analysis and visualization and recommends approaches to building a web-based dashboard using free data visualization libraries.
Article
Top5 Image

Top 5 Browser Extensions for 2020

A listicle showcasing my favourite Top 5 Web Browser extensions for 2020...
Article
Python & SharePoint - Getting Data, Creating Lists and Uploading Files

Python & SharePoint - Getting Data, Creating Lists and Uploading Files

For most Python developers, Microsoft business software is either a great unknown or a necessary evil. Microsoft SharePoint is no exception. Yet, knowing how to integrate Microsoft SharePoint from Python can make all the difference. Plus, it is not that complicated!
Article

Truly Random Numbers in VBA

6
Pseudo random numbers are right at hand in VBA. Obtaining truly random numbers, however, requires an external source. One is the Swiss Quantis QRNG Chip. The output from one of these has been made public by ETH Zürich, and here we present a complete solution for retrieval of random numbers in VBA.
Article

A matter of highlighting in Excel

1
I have seen some great articles online relating to how can we highlight a cell or range of cells based on certain criteria, whether it's using simple conditional formatting or with the help of macro scripts. In this article, I discuss some of these implementations.
Article

AutoComplete feature with ASP.NET and SQL Server

One of my friends recently asked me how to do an AutoComplete feature. I thought it was easy and there are already a lot of examples online. But I wish to provide him with a working solution instead of providing links. And in this article, I will explain the steps that I used to build that solution.
Article

Turn an old laptop into pH measaurement station by arduino and visual studio code

Turn an old laptop into a pH measure station by Arduino and visual studio code. You may create your own application by using an old laptop. Arduino emulator coding and visual code studio programming required.
Article
Conflict Resolution - Moving from Divergence to Convergence

Conflict Resolution - Moving from Divergence to Convergence | Muneeb Imran Shaikh

The path from constructive divergence to convergence is far stronger than the fake uniformity. It is therefore extremely important for the Senior Management of any organization to understand the dynamics of change and importance of constructive disagreements.
Article

How to Navigate IT Education and Your Career

As technology is a constantly growing, evolving platform, there is an emphasis to stay tuned in to technological changes and the latest research. When you implement this into your weekly education, it will allow more opportunities to become available to you.
Article

How to run a SQL Server stored procedure asynchronously from Microsoft Access

When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass. In this example a form flashes a message while the stored procedure executes, and then closes itself once the procedure has finsihed.
Article

The Effective Way to Find the Last Line Content of a Large Text File

Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate an effective way to find the last line content of a large text file using VBA codes.
Article
SharePoint - Delete List and Items Under Retention

SharePoint - Delete List and Items Under Retention

One of the results of enabling retention policies in SharePoint is that you cannot delete a container, such as a site, list of a folder, without deleting the containing content first. This script is my attempt to address the issue, without disabling retention policies.
Article

How to load JSON's data into SQL Server in different ways

Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.
Article

Office file dialogs

Provides a one size fits all solution for File Dialog calls for all MS office applications. Module contains function fncGetFilePathTRM() which does all the filter building for you. I've used a similar version of this for over 15 years, 1 module import, 1 line of code, all done... GLHFSS
Article
How to use a custom language switcher with Transposh to build a multi-language Wordpress website

How to use a custom language switcher with Transposh to build a multi-language Wordpress website

How to build a multilingual website in Wordpress using the plugin Transposh and a custom language switcher. To do it, we'll have to use some plugins and learn how to load and use our custom javascript code.
Article
How to load Excel's data into SQL Server in different ways

How to load Excel's data into SQL Server in different ways

3
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing Excel data into MS SQL Server.
Article
Time Zones, and Microsoft Office - Part 2

Time Zones, Windows, and Microsoft Office - Part 2

Listing and selecting time zones in Microsoft Access and Excel is not straight forward. In the previous article was shown how to retrieve the time zones of Windows. Here will be demonstrated how to create tables to store these and how to display and select a time zone in Microsoft Access and Excel.

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more in Web Dev