Discussion Locked
0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm working on Excel XP and I've created a lot of code using Excel XP's Visual Basic. Unfortunally it doesn't work for Excel 97/2000. How can I convert it without having to write the code all over again.
4 replies
What exactly do you mean by "doesn't work"?
How are you trying to use it? Cut & Paste/Export and Import to 97/2k? Or did you try to open it in 97/2k?
by medina
For example, the code for sorting data in 97/2000 is: Selection.Sort Key1:=Range("AJ13"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
FOR XP the code is the same but at the end it adds this: ,_ DataOption1:=xlSortNormal
Is there a way to make this and other changes automatically?
Being lazy, what I'd do is run a compile in Excel VB then as each problem cropped up I'd do a search and replace for the argument (whatever:= )
by medina
Poster rated this answer
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
0 helpful
1 reply
0 helpful
1 reply
1 helpful
3 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply