JohnL

Short but large macro zip codes I would like a macro when filling out a form that complete the city, state and zip based on entry of zip. Example short key prefix followed by US##### (USzipcode) or hot key producing dialog box requesting zip code. Then the macro would look up the city-state save a variable and complete text type of city <tab> state <tab> zip. I wrote one a couple years ago that went to an excel sheet that listed the zips that found zip city and state and transferred to the application. However it was slow and cumbersome since it required disk access and cross application and seem to work about 75% of the time. It would be nice if the zip data were contained within the macro so you don’t have to load the excel file but not clog the memory with the macro itself. Any help would be appreciated Thanks John