| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells from work book then auto close without losing data
I am trying to prepare a Workbook for people who don't use excel much. I
need it to open a CSV file, manipulate the data, copy cells and then close the file before pasting without user input. So Far I can open the file, manipulate the data, copy the data and close the file using "ActiveWorkbook.Close SaveChanges:=False" But I don't know how to bypass the popup asking if I want to keep the data on the clipboard. Thanks in Advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy workbook files without losing data that was in the org. work | Excel Worksheet Functions | |||
| Open book, copy and paste from sheet, and then close.... | Excel Programming | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| Copy and paste ranges from a close book using Validation | Excel Programming | |||
| close work book via macro | Excel Programming | |||
Threaded Mode
