Home |
Search |
Today's Posts |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
code is not working on another machine
Thank you Tom.
I understand now. "Tom Ogilvy" wrote: because xlSortNormal is the default. You don't need to specify it since it is the default. As I said, this option wasn't even available in older versions of excel. Anyway, these options allow you to specify how to sort the data under each sort key - treat it as number or treat it as text. On the second situation. If it is a library not found error, then you need to check the references on that machine (in the VBE) after the error and see if any are Marked as MISSING. -- Regards, Tom Ogilvy "Papa Jonah" wrote in message ... Tom, The statement is: pareto.Sort Key1:=Range("AA2"), Order1:=xlDescending, Key2:=Range( _ "AC2"), Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase _ :=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, _ DataOption2:=xlSortNormal Why is this not necessary? Also, I just learned that another coworker, who is running the same version of excel (with same service packs) is having a problem at another spot in the code. A spot that the first coworker, with the older version of excel, does not have a problem with. "Tom Ogilvy" wrote: this person is using an older version of excel that does not recognize that argument. You need to remove the argument in the code as it is not ususally necessary. -- Regards, Tom Ogilvy "Papa Jonah" wrote in message ... I have an excel app with a bunch of vba. It works as expected on my computer when loaded on my harddrive or when I run it from a server. However, when a coworker runs it from the server, it works to a point. When my coworker tries to run another macro, he gets an error "Compile error: named argument not found". The debugger highlights "Data option1" within a line that sorts some data. It works fine on my computer and when I run it from the server. Any ideas why this is happening? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Event not working on 1 machine | Excel Discussion (Misc queries) | |||
Excel xls files open as Machine Code | New Users to Excel | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Macro code error; machine dependent | Excel Worksheet Functions | |||
Password not working on one machine | Excel Discussion (Misc queries) |