exists

<tbody> I have 2 spreadsheets which I will refer to as (spreadsheet 1) and (spreadsheet 2). I have values under a row called "name" in spreadsheet 1 that I need to cross reference with spreadsheet 2 within 4 of its sheets as to whether or not those values exists that I referenced...

Hello, In Sheet1, Col A and Col B has list of emails based on user's role. Sheet2 has just a handful of emails, about 2000. I am trying to write a formula that tells me if either of the emails exists in the lists of emails from Sheet2. For example, if I just need to see if email from Cell A2 in...

I have written a VBA code (function) to check whether a URL exists and returns true if it exists. Now I want to further check the page for a known text (in HTML) for example - to check whether a google map exists in the page - to check whether a image (known file name) is embedded in the page -...

I have a list of names that I need to remove the first name if it exists. Not all of them will have it. My list may looks like this: John Doe Steven Smith Johnson I found this formula: =MID(A2,FIND(" ",A2)+1,256) The problem is, that if there is no first name (so no space), it will give me...

ActiveWorkbook.Save ChDir "C:\Users\mikec\Documents\XL" ActiveWorkbook.SaveAs Filename:= _ "C:\Users\mikec\Documents\XL\Budget Personal.xlsm", FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False I created this macro to backup my budget. It works, but when...

Hi, I'm havingconsiderable trouble writing a macro to do the following: 1) Select aparticular sheet in the workbook 2) Select a cell inthat worksheet 3) Check using a forloop if sheets exists and then insert data into a table if true The sheets I'mchecking for existence (whether they are...

Dear all, I have been trying to create a macro that: 1) opens all my excel files in a folder 2) adds a new connection to each file 3) for each pivot table (of each sheet in each file) that is linked to my data cube, I instruct the macro to replace the existing connection and replace it with...

I need to check if there is in specific column (column C) values other than wanted, like if there is any employees that are not on our´s company payment list. If there is no employees that are not on our´s company payment list msg box should return some message like "It is OK, would you like to...

I try to delete a ListObject with a specific name, but get an error if the ListObject does not exists. How can I check if the ListObject exists before I try to delete it? I've tried following If .ListObjects(strDataListName).Exists Then .ListObjects(strDataListName).Delete End If

It's been a while since I've had to use SQL and that was Oracle. Basically I have two tables and I want to just display the items from table a that aren't in table b. Below are the methods of how I thought you would do it, but it doesn't bring in the right results. (The fields are all...

hello all, In my code i need to find if a range exists in my workbook and msgbox"yes"if yes and "no"if no! i have at the moment a code that results in an error if it dosnt exist (so Im using on error goto statement) but that seems a bit crude Any help would be appreciated!

I got the following code a long time ago and if worked perfectly for the workbook that it related too however I have tried to use it in another workbook and instead of adding a number to the filename it is adding .xls, so if the file exists it ends up as i.e. testbook.xls.xls whereas it should...

Hey all, I have the two formulas I want to apply if the condition is true or false. Problem is I need to determine whether there's a comma after the second ampersand in a cell. For example, if the field looks like this: HernaraMartin,Harry & Marie Anne & Ann Sally then I want to execute this...

I have the following code to show a folder upon opening my excel file, however, if the folder doesn't exist then it bugs out. I have tried codes like on error resume next, on error resume line1" etc... and even if err.number= 75 and nothing will skip over the script if the folder doesn't...

Ok I have a Template workbook that has an auto save as macro that triggers on open. It creates the filename based on criteria entered into a few input boxes buy the user. The problem I am having is that there are many different templates that I have with a simmaler macro, and sometimes the...

Is there an easy way to check if a folder (c:\timecards) and file (timecards.xls) exists. if true continue with sub, if false then create them and continue with sub? Private Sub btncontinue_Click() Dim ShName As String ShName = ActiveSheet.Name 'check if folder\file exists here, create if...