zip

  1. J

    Lookup From a Column based on Multiple Criteria (in Columns)

    Hi folks, Below is a visual of my problem. I have zips all listed in one row / several columns B:F (all zips are unique), I would like to have zip in Column J lookup the value in Column A, if it finds a zip that are in columns B:F. Do you have any suggestion? or maybe how I can simply...
  2. M

    Excel not creating full schema - please help!

    <rate<font color="#000000"><rate name="SEATTLE" code="1726" staterate="0.065" localrate="0.036">I have a working spreadsheet which uses a vba to query a web service and return a tax value and other information. However, recently I found a bug that stems from excel having not created the schema...
  3. J

    index - match - 1 value - 3 possible matches

    I am currently trying to look up 1 value - which is a state and could have up to 3 matches with that state, where there are up to 3 different zip codes that I would like to return in order to do other formulas based on the 1-3 results. I would like to reference the look value on 1 tab and have...
  4. R

    Data Validation with Dialog Box

    I have a routine that creates a new copy of a worksheet and then the user inputs data through drop down boxes. In zip code, I have the cell with data validation linked to a named list of zip codes. However, one can enter anything in the dialog box and it will input it into the zip code cell...
  5. R

    Data Validation with Dialog Box

    I have a routine that creates a new copy of a worksheet and then the user inputs data through drop down boxes. In zip code, I have the cell with data validation linked to a named list of zip codes. However, one can enter anything in the dialog box and it will input it into the zip code cell...
  6. S

    match and index question

    I have never really used match and index before and I believe these will be needed to solve my problem I price list in one sheet and an invoice in another In the invoice I get in info in 4 columns that I use to check against my price list - Country, zip code, weight and then price The price...
  7. N

    Pivot table format

    If I want to select a group of people in a state and do reports by city and list them by first and last names with their address, and zip code, is pivot table the way to go or should I just sort them by city and then make separate worksheets by city?
  8. X

    VBA - Send to Compressed Zip Folder

    Hi, I'm looking for a code to zip the folders of a path specified in my cells(1,1).value After searching i found vba codes to zip the files of a folder but they are using WinZip. My office machine does not have a WinZip installed and we are restricted to use WinZip. Could anyone please help...
  9. A

    Hyperlink function question

    Can a hyperlink on a spread sheet be constructed to lookup last four digits of a US zip code entered in another cell?
  10. Devin

    Windows Folder Options Affecting Listing of Files (Shell.Application)

    My goal is to get file sizes for XML files located in a ZIP folder. I have changed an Excel file’s extension to “.ZIP” and I am trying to only extract the .XML file names. FYI, this may only work on new versions of Windows and Excel. I am using Shell.Application to extract the file names. My...
  11. M

    Anyone has the UPS Zone calculator handy ?

    Hi , I am in need to have an excel sheet with 3 digit OriginZIPcodes( from) and 3 digit DestinationZIPCodeses(To) on Rows and columns which will give me which zone it will fall under . I can get it from UPS site . But it means each time i input the Zipcode one by one . Any help is greatly...
  12. J

    Autosave & extract Zip attachment VBA Outlook/Excel

    Hi Everybody, In combination with rules & alerts I manage to automatically save a certain ZIP file (containing 1 file) to a directory specified below. However, to be able to work with this file in a macro it has to be automatically extracted in this directory as well. Doing this extract, the...
  13. M

    VBA to extract excel files from Multiple zip files

    Can someone help me with the vba code to extract only excel files from multiple zip files from a folder..
  14. M

    Assigning macro to each button to zip files dependent on button name

    I'm very new to VBA and programming and so I have no real idea how I can get around this problem that I have. Any help would be greatly appreciated! Sorry if it's difficult to understand exactly what I'm trying to do. If you need clarification on anything I will be online to answer any questions...
  15. T

    Winzip using VBA - add file to zip subfolder

    Hi all This is really a DOS/Command Line/Shell question but it's being run out of VBA and I know this forum better than any other. I need to add a file to a zip file. I have working code that does this using SHELL() the below: "C:\Program Files\Winzip\winzip32" -min -a...
  16. B

    Can Excel recognize the city names for zip codes?

    Hi people! I want to know if its possible for Excel to recognize city/state names for US zip codes. The idea being that I have a column of zip codes and want to know if there is a formula/ way of having the column next to it automatically name the city/ state for me? Another question: Anyone...
  17. S

    Trouble Zipping Files with VBA

    Hi, I am trying to use the code provided here: http://www.rondebruin.nl/windowsxpzip.htm to get excel to zip some files for me. I included the first bits and am trying to use the sub that zips an entire folder that I specify. It keeps giving me Run-time error though. It says: Run-time error...
  18. A

    Creating a temporary file and zipping the file, password protected.

    Hi, I'm using a module in excel that sends an email. The module selects a named range, creates a temporary excel file, pastes in the named range and then sends the temporary file in email. I need the module to zip the temporary file and add a password before emailing the file. This is...
  19. A

    Sending an encrypted email from excel

    I need to send an email from excel vba. I've got the code to create a temp file and send a specfic range. What I need now is to add a password to the excel file and zip the file and add a 2nd password. Does anyone have any code that code password protect and zip a temp file?
  20. C

    Zip excel worksheet and attach to an email

    Hi folks.. I'm relatively ok with navigating excel and using the VBA. What I'm trying to do is zip one of the 2 worksheets in my workbook and attach it to an email. So basically... the user would input information into Sheet 1, click a button, the information would fill in a hidden Sheet 2 and...

Some videos you may like

This Week's Hot Topics

Top