Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CutCopyMode=False does not work
I am using vba in one workbook to make changes in a target workbook. I used
application.cutcopymode=false to clear the clipboard, but it doesn't seem to work correctly. I have the clipboard visible to the side of the window, and all of the copy/paste operations remain in the clipboard. Here is the code I am using: Option Explicit Sub auto_open() Dim FileName As Variant Application.ScreenUpdating = False FileName = Application.GetOpenFilename If FileName = False Then Exit Sub Dim WB As Workbook Set WB = Workbooks.Open(FileName) ThisWorkbook.Worksheets("Sheet1").Activate ActiveSheet.Cells.Copy WB.Worksheets("Sheet1").Range("A1").PasteSpecial WB.Worksheets("Sheet2").Range("A3:D3").Copy WB.Worksheets("Sheet2").Range("A4:D4").PasteSpecia l xlPasteFormats WB.Worksheets("Sheet2").Range("B5:G5").Copy WB.Worksheets("Sheet2").Range("B7:G9").PasteSpecia l xlPasteFormats Application.CutCopyMode = False WB.Worksheets("Sheet1").Activate ActiveSheet.Range("A1").Select Application.CutCopyMode = False Application.ScreenUpdating = True ThisWorkbook.Close savechanges:=False End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CutCopyMode=False does not work
hi, Horatio !
I am using vba in one workbook to make changes in a target workbook. I used application.cutcopymode=false to clear the clipboard, but it doesn't seem to work correctly. I have the clipboard visible to the side of the window, and all of the copy/paste operations remain in the clipboard... windows clipboard ?... see: - http://www.cpearson.com/Excel/clipboard.htm office clipboard ?... see: - http://www.mvps.org/skp/off00004.htm#2 - http://support.microsoft.com/default...;en-us;q207438 - http://techsupt.winbatch.com/TS/T000001071F4.html - http://support.microsoft.com/default...=kb;ES;A196620 hth, hector. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CutCopyMode=False does not work
Your first link about the office clipboard looked good, but it didn't work
for me: Application.CommandBars("Clipboard").Controls(4).E xecute I found a comment on another forum that said you can't clear the office clipboard with vba. I have tried recording a macro for clearing the clipboard, but it just comes up blank. Instead I have settled for just closing the clipboard: Application.CommandBars("Task Pane").Visible=False But since the Task Pane is only in newer versions of Excel, is that line of code going to be an issue for users with an older version of Excel? Thanks, ~ Horatio "Héctor Miguel" wrote: hi, Horatio ! I am using vba in one workbook to make changes in a target workbook. I used application.cutcopymode=false to clear the clipboard, but it doesn't seem to work correctly. I have the clipboard visible to the side of the window, and all of the copy/paste operations remain in the clipboard... windows clipboard ?... see: - http://www.cpearson.com/Excel/clipboard.htm office clipboard ?... see: - http://www.mvps.org/skp/off00004.htm#2 - http://support.microsoft.com/default...;en-us;q207438 - http://techsupt.winbatch.com/TS/T000001071F4.html - http://support.microsoft.com/default...=kb;ES;A196620 hth, hector. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CutCopyMode=False does not work
hi, Horatio !
Your first link about the office clipboard looked good, but it didn't work for me: Application.CommandBars("Clipboard").Controls(4).E xecute office clipboard for xl2000, try with: - Application.CommandBars.FindControl(ID:=3634).Exec ute I found a comment on another forum that said you can't clear the office clipboard with vba. I have tried recording a macro for clearing the clipboard, but it just comes up blank. Instead I have settled for just closing the clipboard: Application.CommandBars("Task Pane").Visible=False But since the Task Pane is only in newer versions of Excel is that line of code going to be an issue for users with an older version of Excel? office clipboard "moved" to task-pane (xl2002 / xl2003) and AFAIK... - it does not expose its OM to VBA :-(( - closest approach ?... see Michael Pierrone (post # 6) in: - http://tinyurl.com/2j8y4x hth, hector. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CutCopyMode=False does not work
It looks like the code will always be dependent on the version of excel being
used. I found a different solution, though. There are samples for bypassing the clipboard, instead of using Copy/Paste, at http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm I have tried it out, and it works great. Thanks for the help. ~ Horatio "Héctor Miguel" wrote: hi, Horatio ! Your first link about the office clipboard looked good, but it didn't work for me: Application.CommandBars("Clipboard").Controls(4).E xecute office clipboard for xl2000, try with: - Application.CommandBars.FindControl(ID:=3634).Exec ute I found a comment on another forum that said you can't clear the office clipboard with vba. I have tried recording a macro for clearing the clipboard, but it just comes up blank. Instead I have settled for just closing the clipboard: Application.CommandBars("Task Pane").Visible=False But since the Task Pane is only in newer versions of Excel is that line of code going to be an issue for users with an older version of Excel? office clipboard "moved" to task-pane (xl2002 / xl2003) and AFAIK... - it does not expose its OM to VBA :-(( - closest approach ?... see Michael Pierrone (post # 6) in: - http://tinyurl.com/2j8y4x hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # | Excel Worksheet Functions | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |