.xls ss will not run under anything but Excel
.xls ss will not run under anything but Excel
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?
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
Re: .xls ss will not run under anything but Excel
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
- Hagar Delest
- Moderator
- Posts: 32654
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: .xls ss will not run under anything but Excel
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.squenson wrote:the macros are protected by a password and therefore it is not possible to assess the complexity.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: .xls ss will not run under anything but Excel
Thanks for your replies, I think I will have to dose myself in holy water and temporally go over to the dark side
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
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
Re: .xls ss will not run under anything but Excel
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
- Hagar Delest
- Moderator
- Posts: 32654
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: .xls ss will not run under anything but Excel
As they're given for free without any kind of license, it's worth asking him if it can be translated to OOo.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: .xls ss will not run under anything but Excel
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.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 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
- Hagar Delest
- Moderator
- Posts: 32654
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: .xls ss will not run under anything but Excel
I can see the macros both under xubuntu and W2k with OOo.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: .xls ss will not run under anything but Excel
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
I can't find that module either.
I can't find that module either.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
- Hagar Delest
- Moderator
- Posts: 32654
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: .xls ss will not run under anything but Excel
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:
But I can see all the macros it seems:
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: .xls ss will not run under anything but Excel
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)
2.4.1 throws up a BASIC syntax error (Symbol expected)
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10