Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Excel 4.3 macro migration JDT Excel Discussion (Misc queries) 3 November 22nd 06 11:30 PM
QueryTables - Excel 2000 to 2002 migration [email protected] Excel Programming 2 March 1st 06 12:40 PM
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? brigida3 Excel Discussion (Misc queries) 1 January 22nd 06 05:13 PM
Migration from Excel 2000 to 2003 Rene H Excel Programming 3 November 27th 05 09:55 AM
Migration of Excel97 to Excel XP Peter[_27_] Excel Programming 2 September 16th 03 10:56 AM


All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"