domain

Goal: Prevent exited employees from using certain company spreadsheets. I've searched for this question, but most of the questions refer to allowing only a specific list of users access. I have another workbook that only a few people need access to, so I put their ID numbers on a hidden sheet...

I have various lists of website URLs in all shapes and sizes and I want to just have each website to be in this format: www.[insert your domain name].com Examples: Column A www.normals.com (pretty straight and fwd. About 80% of my list is like this and I don't need to...

Hi Is there a way of getting certain pages urls from a website using vba. My following code gets all the urls from a web site page. I enter the domain in L1 and whatever that domain is, it will go to that page and extract all urls. The problem is 1) It only extracts from that page 2) Not...

Hello, I am working on a macro that identifies the username, asks for the account password and sends out an email from Gmail. I tested it using my personal gmail account and worked like a charm with the default settings smtp.gmail.com and port 25. However, I couldn't manage to make it work...

I am new to this site however hopefully someone will take pity on me and answer my question. I should also say I am only a basic Excel user (very basic). Here is my problem. I have a spread sheet with a column that contains individual email addresses (example = JoeSmith@ABC.com). I need to set...

I have created a questionnaire that consists of around 100 questions. These items are separated into 6 domains where. For the sake of easier understanding, let's just call them Domain 1 - 6. I have them typed in one specific table called "Correspondence", with format like below: <tbody>...

Hello friends, I need the code for VBA userform login to open excel using domain username and password. So, when user open a file, userform will be activated and user need to enter username and password, domain name will be automatically detected and written in 3rd line. But if user need to...

Hi, so Row A contains lots of different but unique individual e-mail addresses, thousands in fact in the format : Alan.Smith@MrExcel.com Karen.Jones@MrExcel.com Clive.Bloggs@Microsoft.com Brenda.Forbes@MrExcel.com what I need to do is count the instances that an e-mail Domain Name appears so...

I know this is technically not an Excel question, but there are a lot of people here with better math skills than mine, so I hope this is OK. I would like to find a family of functions, f(x,m), that meets these conditions: Maps the domain (0,10) onto the same range and is continuous over that...

Hi all, Wonder if someone call help me with something. Basically I have a whole load of data which I need to sort of "sanitize" so to speak. The data looks like this (it can be in a text doc or put into a new sheet) mac-address (omitted) profile persons-name domain LONDON hostname...

Hi team, I have one doubt about how I can find the domain name from companies mail address

Hello, I am designing an excel file which will provide me the company website URL taking the Company name as Input. For this I have found out a free API which does this exact Name->Domain mapping. The API goes like this: https://autocomplete.clearbit.com/v1/companies/suggest?query=[C_NAME]...

I am trying to check some of the common email domain names when people enter them into an Excel Form. I have a spread sheet tab with names like gmail.com Comcast.net Hotmail.com etc Below is the code I am having problems with. I keep getting a Type Mismatch on this line If...

Hi All, I want to ask how can I separate in excel sheet the domain name after "@" and before ".", I have table of email addresses as follows: john@xyz.com john123@yah.org raw348@zyx.com let say for the first one, how can I separate xyz in separate column?? Appreciate your advise. Thank you.

Hello Folks, I have a requirement to extract the domains from a list of URLs. I know this is quite trending and a petty common topic across generic internet search, however no formulas quite seem to match my specific query. My file has a list of domains (which include subdomains and multiple...

I cannot seem to figure this one out... tried sumifs, sumproduct, index/match. Here's what I'm trying to do: Sum data in an array that matches 3 different criteria coming from both columns and rows. Maybe it's best to illustrate. Here's a simplified version: <tbody> Company Allocation 2013...

I have a userform that sends a copy of the workbook via email. The primary goal is to send the form back to me (or my counterpart) but it could be useful to send within the company as well. I want to ensure that any email addresses entered have a company domain. I'm not worried about actually...

Hello guys, I have question for my following issue: I'm trying to figure out the amount of emails registered from each email domain by month, the information I have is Column A the dates of creating (for example(01/01/13)) and in column B I the emails ex (john@gmail.com...

I searched the forum and saw several posts to this effect, but nothing quite had the detail or scenario I am faced with. I have a data dump that I get daily in excel. There are several columns I need to create a new report out of but I also am finding myself needing to do the same manual...

Hi all, In desperate need of assistance. I am currently building a statistical view of data - % data missing, % complete etc. I am the writing these values into a stats table so that one is able to see progress. The only way I can do this is via a number of queries, and to keep things neat...