| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I like to open a folder,auto print,save then close
I would like to open a folder that has about 70 excel doc. inside and
automatly send,then save and close each doc that is inside all automatly.How can I do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I like to open a folder,auto print,save then close
Why open the documents. You can just create an email and add them as an
attachment. See Ron de Bruin's site for either approach: Ron de Bruin http://www.rondebruin.nl/sendmail.htm http://msdn.microsoft.com/library/en...odc_xlmail.asp http://www.rondebruin.nl/tips.htm Dick Kuselika www.dicks-clicks.com Tim Zych www.rubbershoe.com/olmail.htm -- Regards, Tom Ogilvy "tied of opening files" <tied of opening wrote in message ... I would like to open a folder that has about 70 excel doc. inside and automatly send,then save and close each doc that is inside all automatly.How can I do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I like to open a folder,auto print,save then close
each fax,e-mail goto someone differnt. currently I use a fax server and I
embed to fax numbers but I still must open all of them and send it to the server one at a time by a addin button then save and close each one before I move to the next one.The e-mail are allmost the some a little faster not much.So I'm try to find a way to make all this automatice. "Tom Ogilvy" wrote: Why open the documents. You can just create an email and add them as an attachment. See Ron de Bruin's site for either approach: Ron de Bruin http://www.rondebruin.nl/sendmail.htm http://msdn.microsoft.com/library/en...odc_xlmail.asp http://www.rondebruin.nl/tips.htm Dick Kuselika www.dicks-clicks.com Tim Zych www.rubbershoe.com/olmail.htm -- Regards, Tom Ogilvy "tied of opening files" <tied of opening wrote in message ... I would like to open a folder that has about 70 excel doc. inside and automatly send,then save and close each doc that is inside all automatly.How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto save and close | Excel Worksheet Functions | |||
| Auto Open, Refresh, Save, Close | Excel Discussion (Misc queries) | |||
| Auto-save worksheet on close? | Excel Discussion (Misc queries) | |||
| Auto open 8 workbooks in different folders, then save on close... | Excel Programming | |||
| Auto Close and Save | Excel Programming | |||
Linear Mode
