| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy cells from work book then auto close without losing data
Hi Bigg,
Try replacing: ActiveWorkbook.Close SaveChanges:=False with Application.CutCopyMode = False ActiveWorkbook.Close SaveChanges:=False --- Regards, Norman "Bigg19" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy cells from work book then auto close without losing data
Thanks
I tried it earlier, bit it removes the data from the clipbpoard, and I need to save it for future pasting. Bigg19 "Norman Jones" wrote: Hi Bigg, Try replacing: ActiveWorkbook.Close SaveChanges:=False with Application.CutCopyMode = False ActiveWorkbook.Close SaveChanges:=False --- Regards, Norman "Bigg19" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy cells from work book then auto close without losing data
Hi Bigg,
'---------------- I tried it earlier, bit it removes the data from the clipbpoard, and I need to save it for future pasting. '---------------- Try: Application.DisplayAlerts = False ThisWorkbook.Close SaveChanges:=False Application.DisplayAlerts = True --- Regards, Norman |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy cells from work book then auto close without losing data
Application.displayalerts=false
'...code Application.displayalerts=true However, I would normally copy/paste, then continue with other code, rather than expecting clipboard data to remain unchanged over time. NickHK "Bigg19" wrote in message ... Thanks I tried it earlier, bit it removes the data from the clipbpoard, and I need to save it for future pasting. Bigg19 "Norman Jones" wrote: Hi Bigg, Try replacing: ActiveWorkbook.Close SaveChanges:=False with Application.CutCopyMode = False ActiveWorkbook.Close SaveChanges:=False --- Regards, Norman "Bigg19" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy cells from work book then auto close without losing data
Thanks
Your solution Worked Regards Bigg19 "NickHK" wrote: Application.displayalerts=false '...code Application.displayalerts=true However, I would normally copy/paste, then continue with other code, rather than expecting clipboard data to remain unchanged over time. NickHK "Bigg19" wrote in message ... Thanks I tried it earlier, bit it removes the data from the clipbpoard, and I need to save it for future pasting. Bigg19 "Norman Jones" wrote: Hi Bigg, Try replacing: ActiveWorkbook.Close SaveChanges:=False with Application.CutCopyMode = False ActiveWorkbook.Close SaveChanges:=False --- Regards, Norman "Bigg19" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy cells from work book then auto close without losing data
Thanks
That did the trick, only I had to use ActiveWorkbook.Savechanges= False. When I tried ThisWorkbook.Savechanges = False, it closed my destination workbook (from which the macro was being run) Bigg19 "Norman Jones" wrote: Hi Bigg, '---------------- I tried it earlier, bit it removes the data from the clipbpoard, and I need to save it for future pasting. '---------------- Try: Application.DisplayAlerts = False ThisWorkbook.Close SaveChanges:=False Application.DisplayAlerts = True --- Regards, Norman |
| Reply |
| 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 | |||
Linear Mode
