Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() i got 2 computers... lets name computer A janphi and computer B pswanie i use pswanie to write and edit a workbook wich i then email a excel workbook to janphi. with the name editinventry.xls. this i got saved in c:\windows\myfolder janphi has a c:\windows\myfolder\inventry.xls i need a macro to run when janphi open the editinventry.xls from the email. this macro then needs to copy\paste info from inventry.xls {sheet1 cell b2} to editinventry {sheet1 cell b2}. next step will be to save as {editinventry.xls} to c:\windows\myfolder\inventry.xls on janphi... this need to run once only. this can be by means of a command button or auto in the background. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to open, Update links, save and close workbooks | Excel Discussion (Misc queries) | |||
Auto Open, Refresh, Save, Close | Excel Discussion (Misc queries) | |||
Open Save & Close All Files in Dir | Excel Programming | |||
Save and Close all Open Workbooks using VBScript | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |