norman | Fri, 23 May 2008 07:29:00 GMT |
david | Fri, 23 May 2008 07:30:00 GMT |
Hi, Can someone help me create a code that zip, send and than mail (attached the zipped file) workbook to several recipients? Regards...
Hi I'm searching for code that allows to create zip files with Excel workbooks. Thanks Luis...
I create text files (csv) from Informix 4gl and I often need to send zipcodes. When csv files open in excel, you lose the leading 0 for states like CT, NJ, and MA. Is there an ascii character to put in front of zip? I can't depend on users to change the formatting of the cells....
I have an address data base in excel. Zip codes with the plus 4 (77777-1234) show as 0 when I do a mail merge for address labels using word. I have tried reformatting the zip code cells to zip + 4 and serveral other formats and nothing works. Help please and thank you...
I am using Excel 2002 and I am trying to do a mail merge for address labels. In my "zip code" column, I have a few that begin with 0. I have formatted the column as a "zip code" column, but when I do the merge, the first 0 drops off. How do I get the first 0 to stay' Thanks -- Ray Remove NO...
I need to change Zulu time back 1 hour due to the daylight savings time. I have a format I need to follow, which is example ?P 04:45Z? Where the P needs to remain because it signifies proposed, and the Z needs to remain, because it signifies Zulu and the time 04:45 needs to be made 03:45 while p...
Hi, Not exactly an excel question but still posting here. I want to do z-test using Excel. I do have the analysis tool pak installed (along with Analysis tool-pak VBA). Being used to Canned software (The concerned tabulation software terms it as Z-Test for percentages) which tell me automaticall...
Does Excel (2002, 2003) support Z-Ordering of Inserted Objects?...
Argh! Form controls now *always* appear on top of shape/drawing objects. What's up with that? Prior versions of Excel allows you to send Form controls behind shape objects by right clicking on them and choosing "Order->Send to back". Ok, so you're probably asking "why would you ever...
How can I click on a row (or cell) and that record is seen separately on a different worksheet....
Hi, I have more worksheet in the workboock. I wish the Application in another PC - wiht different Monitor-resolution to opening. However in the sam workSheet-largeness. A.) Automatlically? B.) Via macro (Button) in the defined Zoom, for all workSheet t activate? Have I any cance? Thank you very...
Hi, I have an excel workbook with multiple sheets. It is been used on different computers and I would like my workbook to zoom always to right screen width. How can I do this? I have freezed panes on top of every sheet with a background picture that has a width of 33,52 cm. I would like to have...
Whenever a user opens an Excel Spreadsheet the sheet automatically zooms to 400%. This happens when the user is connected to a projector or second monitor. I have updated the display driver and downloaded all MS Office Updates. Nothing else seems to be having issues except Excel and Word. The on...
Please you know why setting the Window.Zoom property can have no effect on an activedocumenthost? Thnak you....
I've created a data entry Excel file at work, and have placed severa text boxes on the sheet to let users enter notes. My usual scree resolution is 800X600, so this is the resolution I created th application in, and am having no problems at this resolution. However some users have their scr...