Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HansHamm
  • Content: Threads
  • Order by date
  1. HansHamm

    Move to next column and open new workbook

    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"...
  2. HansHamm

    Utilizing wildcards in Excel/VBA

    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...
  3. HansHamm

    Matching Data in Mutiple Columns

    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...
  4. HansHamm

    Masking the email address

    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...
  5. HansHamm

    Searching for Spreadsheet Data utilizing VBA

    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...

Part and Inventory Search

Back
Top