.xls ss will not run under anything but Excel

Creating a macro - Writing a Script - Using the API

.xls ss will not run under anything but Excel

Postby Cambirder » Sun Jul 27, 2008 10:15 pm

I will shortly be starting a course that I am required to use an Excel based modeling tool that unfortunately won't run under anything other than Excel (I've tried on every OS ss I know of including OOO 3). This is a bit of a pain as I don't have, and don't want Excel. The problem document is the CASS tool that can be found at the following site.

http://www.steverox.info/software_downloads.htm

The issue seems to be with the macro associated with the "Run" button, and unfortunately my macro skills are zero. Can anyone advise if this ss is easily fixable, or am I going to have to borrow a pc with Excel on it for a couple of weeks?
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: .xls ss will not run under anything but Excel

Postby squenson » Sun Jul 27, 2008 10:42 pm

As I thought, the macros are protected by a password and therefore it is not possible to assess the complexity. Unles you could obtain it from the owner of the program, the solution to borrow a PC with Excel seems to be your only choice...
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: .xls ss will not run under anything but Excel

Postby Hagar Delest » Sun Jul 27, 2008 10:54 pm

squenson wrote:the macros are protected by a password and therefore it is not possible to assess the complexity.

Are you sure? I can access the macros under my xubuntu box. But they seem rather complex. Rewriting them would take some time I guess.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: .xls ss will not run under anything but Excel

Postby Cambirder » Sun Jul 27, 2008 11:50 pm

Thanks for your replies, I think I will have to dose myself in holy water and temporally go over to the dark side :evil:

I had a bit of a delve but can't actually find any of the macros that are supposed to be linked to any of the buttons
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: .xls ss will not run under anything but Excel

Postby squenson » Mon Jul 28, 2008 6:08 am

In Excel, the macro are protected by a password. I *know* that in Calc I can see them but in my opinion it would go against the author's will to access them.
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: .xls ss will not run under anything but Excel

Postby Hagar Delest » Mon Jul 28, 2008 9:05 am

As they're given for free without any kind of license, it's worth asking him if it can be translated to OOo.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: .xls ss will not run under anything but Excel

Postby Cambirder » Mon Jul 28, 2008 10:25 am

Hagar de l'Est wrote:As they're given for free without any kind of license, it's worth asking him if it can be translated to OOo.


I will do that. He has also protected the sheet but without putting a password in place, so I suspect its done more to protect from accidental damage than anything else.

I assume as the protected macros can't be converted OOO just removes them, which is why I can't see them.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: .xls ss will not run under anything but Excel

Postby Hagar Delest » Mon Jul 28, 2008 11:03 am

I can see the macros both under xubuntu and W2k with OOo.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: .xls ss will not run under anything but Excel

Postby Cambirder » Mon Jul 28, 2008 11:31 am

Well I can see some macros but don't seem to be able to anything linked to the particular button (but I could just be being a bit thick here) This is the error message I get from OOO 3.0

Image

I can't find that module either.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: .xls ss will not run under anything but Excel

Postby Hagar Delest » Mon Jul 28, 2008 11:36 am

When I press the Run button (with 2.4.1 under W2k), the IDE interface opens with an error due to VBA code.

But I can see all the macros it seems:
Macros.png
Macros.png (6.74 KiB) Viewed 2754 times
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: .xls ss will not run under anything but Excel

Postby Cambirder » Mon Jul 28, 2008 11:43 am

Interesting, see the same thing in 2.4.1, but its mostly missing under 3.0.

2.4.1 throws up a BASIC syntax error (Symbol expected)
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 6 guests