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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.