Search results for query: *

Fen, This is GREAT!! But, now I have another issue that I did not think of earlier.. In the formula section I need the If(index'Market'!C:C... to do the following Start in column C and do the index then move to column D and do the index. I tried to mimc your code (wkbk etc...) to make this...

I just can't seem to get this...I have a folder where the workbook is found...it looks for the files and opens them. Sub getdata() Dim MAPReport As Workbook With Application.FileSearch .NewSearch .LookIn = ThisWorkbook.Path .SearchSubFolders = False .Filename = "mp*.htm"...

I am having an issue calling/activating a workbook(s) utilizing wildcards, from my main workbook, i.e. (MAP) I have it set up so that the MAP workbook will open all other workbooks in a folder utilizing names such as m1, m2, m3 etc... The wildcard that I state is "m*.htm" in the code. This is...

PH....Thanks alot for the help!!!

I am working on an ADP project and having difficulties getting a SQL statement to work...I have 175 employees assigned to 375 stores.. I have 2 tables; 1 table has a column with store numbers in it. The 2nd table has multiple columns with employee info. Each employee has between 1-4 stores...

Hey I appreciate the response! I figured as much, but hoped that someone would know a way around this...unfortunately they do not want to use webmail, which we could host from our internal server. But I will bring this back up again! I will have to check out with some of the people in the field...

We have several people who work in the field utilizing different ISP's. The company wants evryone's email address to show, i.e.@company.com instead of charter.net or whomever. Is there anyway to set up Outlook so when someone sends an email it will look as though they sent it from the company...

Hey, I appreciate the help! I have been involved in other issues the last 2 weeks and will look into what you all were stating. Thanks for the help and I have 1 additional question. I realize that I need to REALLY convert & learn VB/VBA. What is your opinion of where to really get the loaddown...

I am new to this forum and VBA...I have been utilizing formulas to obtain the information I need, but now I REALLY need to start learning and converting over to VB/VBA... Here is the scenario: I have 3 columns; Column A is the Store Number, Column B is the Store Name, Column C is the District...