| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close file
using code I am a opening a worksheet (source), copying data & pasting in
worksheet (target). Target file contains code as well. My requiredment is after copy/pasting, the source file automatically close, keep in mind source filename keeps changing. folloiwng code opens file ChDir _ "\\ccgrp2.office.adroot.gc.net\OCt\Desktop Deployment\Backlog FY09 Project\Received Inventory Files\" FName = Application.GetOpenFilename(filefilter:="Excel Files (*.xls), *.xls") Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Everytime i close an excel file, it creates a new backup file | Excel Discussion (Misc queries) | |||
| Close & save a file at set time only IF the file is open | Excel Programming | |||
| Close file and run macro from newly opened file | Excel Programming | |||
| VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Threaded Mode
