Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Migration from Excel 2000 to 2003
1. In XL2000 and XL2002 VBA, there is no such thing as
"ACTIVESHEET.PASTELINK=TRUE". Do you mean "ActiveSheet.Paste Link:=True" ? 2. This is still (potentially) valid syntax. Maybe you have other errors preventing compilation. NickHK "pmonica" wrote in message ... Dear All, I was working in the past with Excel 2000, where I have made most of my VBA macros. Now I have installed Excel 2003 and some of the commands are not working. Just to examples: 1. In the VB editor, when you write "ACTIVESHEET.PASTELINK = TRUE", all the "unnecessary" caps would be desapearing. In my 2003 excel the LINK remains with caps and the instrution is not working. 2. In the VB editor, when you write "SELECTION.VALUE = "bla-bla"", all the "unnecessary" caps would be desapearing. In my 2003 excel the VALUE remains with caps and the instrution is not working. Help please. -- Paulo Mónica |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Migration from Excel 2000 to 2003
They still work, in 2002 anyway. I would be surprised if they are broken in
2003. Of course the code will fail if the conditions are correct ; something suitable to paste as a link and a selection that can take a value. NickHK "pmonica" wrote in message ... 1. Indeed I was not writting the code correctly on the previous post. Indeed I meant "ActiveSheet.Paste Link:=True" For both errors they were working perfectly on Excel 2000... -- Paulo Mónica "NickHK" wrote: 1. In XL2000 and XL2002 VBA, there is no such thing as "ACTIVESHEET.PASTELINK=TRUE". Do you mean "ActiveSheet.Paste Link:=True" ? 2. This is still (potentially) valid syntax. Maybe you have other errors preventing compilation. NickHK "pmonica" wrote in message ... Dear All, I was working in the past with Excel 2000, where I have made most of my VBA macros. Now I have installed Excel 2003 and some of the commands are not working. Just to examples: 1. In the VB editor, when you write "ACTIVESHEET.PASTELINK = TRUE", all the "unnecessary" caps would be desapearing. In my 2003 excel the LINK remains with caps and the instrution is not working. 2. In the VB editor, when you write "SELECTION.VALUE = "bla-bla"", all the "unnecessary" caps would be desapearing. In my 2003 excel the VALUE remains with caps and the instrution is not working. Help please. -- Paulo Mónica |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel 4.3 macro migration | Excel Discussion (Misc queries) | |||
QueryTables - Excel 2000 to 2002 migration | Excel Programming | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Migration from Excel 2000 to 2003 | Excel Programming | |||
Migration of Excel97 to Excel XP | Excel Programming |