Macro's

Nobby Hall

Member
Credits
0
I have had to install 'Crossover" on the laptop in order for me to get the information required to copy the Macros from the Excell to a new one I want to run under Libra.

14 days and ticking, anyone point me in the right direction that will let me see the info of the Macros and are they able to be copied and pasted please?

Trying to view the code returns with password protected, and as its written by the HSE, thats as far as I was able to go.
 


wizardfromoz

Super Moderator
Staff member
Gold Supporter
Credits
10,019
Hi Nobby, I haven't used Crossover - are you using the free trial or paid for it?

There might be something to be said for installing Wine and PlayOnLinux, and then installing Excel under that environment. BTW I have not used this method either, I just don't have the need.

Which version of Ubuntu are you using? eg 16.04 Desktop (Unity DE), 18.04 Desktop (GNOME DE) or MATE? And do you have Synaptic Package Manager installed?

This article might be of use to you.

https://www.makeuseof.com/tag/install-microsoft-excel-linux/

Someone else may know better.

Good luck :)

Wizard
 

Nobby Hall

Member
Credits
0
Hi Nobby, I haven't used Crossover - are you using the free trial or paid for it?

There might be something to be said for installing Wine and PlayOnLinux, and then installing Excel under that environment. BTW I have not used this method either, I just don't have the need.

Which version of Ubuntu are you using? eg 16.04 Desktop (Unity DE), 18.04 Desktop (GNOME DE) or MATE? And do you have Synaptic Package Manager installed?

This article might be of use to you.

https://www.makeuseof.com/tag/install-microsoft-excel-linux/

Someone else may know better.

Good luck :)

Wizard
Hi wizfromoz

I tried to install Wine and PlayOnLinux but couldn't get it to run, kept crashing when trying to play.. Hence why the FREE Trial of crossover.

I am currently using the latest version of Mint, but will look at the link you have attached as I am sure it is me and not the comp thats causing the problem.
 

JasKinasis

Well-Known Member
Credits
5,076
There are various ways to bypass/remove password protection on VBA that is embedded in excel and other MSOffice files.

All of them require you to be running windows though I think.

Here are two threads on stackoverflow:
https://stackoverflow.com/questions...the-password-on-an-excel-vba-project#19704979
https://stackoverflow.com/questions/272503/removing-the-password-from-a-vba-project#7835861

There are a few other methods, but the ones listed in those two threads contain the most common ones that I am aware of.

And the best method to use would depend on the version of excel that was used to create the file and the file-format it has been saved as.

Having said all of that:
Although you have legitimate reasons for bypassing/cracking the password on the VBA in the spreadsheet AND there are lots of documented ways to achieve this - I don't know where you stand from a legal standpoint.

I thought the UK government had already committed themselves to releasing public data using open document formats.

Ref:
https://www.gov.uk/government/news/open-document-formats-selected-to-meet-user-needs

So another option might be to contact the HSE, explain what you are doing with Ian's RosterBuilder software and ask if there is any possibility that they can start providing the spreadsheet in the open-document format too, with any necessary macros included in the document.

That way, you won't have to resort to cracking the password protection on the VBA in their excel file and you'll have all of the data in the format you require it to be in. Might be worth a punt!
 
Last edited:

Nobby Hall

Member
Credits
0
There are various ways to bypass/remove password protection on VBA that is embedded in excel and other MSOffice files.

All of them require you to be running windows though I think.

Here are two threads on stackoverflow:
https://stackoverflow.com/questions...the-password-on-an-excel-vba-project#19704979
https://stackoverflow.com/questions/272503/removing-the-password-from-a-vba-project#7835861

There are a few other methods, but the ones listed in those two threads contain the most common ones that I am aware of.

And the best method to use would depend on the version of excel that was used to create the file and the file-format it has been saved as.

Having said all of that:
Although you have legitimate reasons for bypassing/cracking the password on the VBA in the spreadsheet AND there are lots of documented ways to achieve this - I don't know where you stand from a legal standpoint regarding cracking the password and removing the protection.

I thought the UK government had already committed themselves to releasing public data using open document formats.

Ref:
https://www.gov.uk/government/news/open-document-formats-selected-to-meet-user-needs

So another option might be to contact the HSE, explain what you are doing with Ian's RosterBuilder software and ask if there is any possibility that they can start providing the spreadsheet in the open-document format too, with any necessary macros included in the document.

That way, you won't have to resort to cracking the password protection on the VBA in their excel file and you'll have all of the data in the format you require it to be in. Might be worth a punt!
Email sent to the HSE and I will post their response. Thanks
 

atanere

Well-Known Member
Credits
0
Besides the password problem, I don't think you will be able to copy/paste from Excel macros into LibreOffice Calc macros. A little Googling shows their underlying script engines are not directly compatible. You may find a converter to help you transition the code if HSE can't or won't help you with this task.

I'm in the dark as to what HSE is anyways, but I gather it is part of your government.

Cheers
 

Nobby Hall

Member
Credits
0
A colleague sent me a copy of his FRI, that he runs on Libra Office, but on his windows comp.

HSE???? Likewise
 

Condobloke

Well-Known Member
Credits
6,473
FWIW

HSE......The Health and Safety Executive is the body responsible for the encouragement, regulation and enforcement of workplace health, safety and welfare, and for research into occupational risks in Great Britain
 

Condobloke

Well-Known Member
Credits
6,473
well damn !.....i should have known that.....
 

atanere

Well-Known Member
Credits
0
A colleague sent me a copy of his FRI, that he runs on Libra Office, but on his windows comp.

HSE???? Likewise
Okay... if that file is something you need, LibreOffice doesn't care if it's on Windows or Linux, so any macros contained in it should run without modification or conversions.

(Famous last words. :D)
 

Nobby Hall

Member
Credits
0
FWIW

HSE......The Health and Safety Executive is the body responsible for the encouragement, regulation and enforcement of workplace health, safety and welfare, and for research into occupational risks in Great Britain[/QUOTE
Okay... if that file is something you need, LibreOffice doesn't care if it's on Windows or Linux, so any macros contained in it should run without modification or conversions.

(Famous last words. :D)
A colleague just sent me a copy he uses on L/Office so i now I have it on the laptop.
It warns about the macros, but will not run them. When you look at the macros, they are blanked out so cannot run them
Checked all the settings etc but to no avail.
It wont let me upload it unfortunately.
 

atanere

Well-Known Member
Credits
0
A colleague just sent me a copy he uses on L/Office so i now I have it on the laptop.
It warns about the macros, but will not run them. When you look at the macros, they are blanked out so cannot run them
Checked all the settings etc but to no avail.
It wont let me upload it unfortunately.
You have to change the macro security setting to allow it to run.
 

wizardfromoz

Super Moderator
Staff member
Gold Supporter
Credits
10,019
There is this, if'n you want to try it (I haven't), and you have the VBA code.

https://www.business-spreadsheets.com/vba2oo.asp

If it converts Excel Macros to Open Office, and with Open Office having forked Libre Office, then the outcome may well be compatible?

BTW Nobby - I am born under the sign of Libra , we are talking Libre Office, that's French (pron lee-bray), you know, those guys across the ditch from you who eat snails :)

Cheers all, off for my night.

Good luck!

Wiz
 

atanere

Well-Known Member
Credits
0
Go to the Tools menu, click Options at the bottom. On the left menu that opens, expand the first entry (if not already expanded)... this is just titled LibreOffice. Come down in the list to Security and click it. Then on the right you can change Macro Security.

I'd choose the Low or Medium. Then you need to close your file and reopen it so the new setting will take effect.
 

Nobby Hall

Member
Credits
0
Go to the Tools menu, click Options at the bottom. On the left menu that opens, expand the first entry (if not already expanded)... this is just titled LibreOffice. Come down in the list to Security and click it. Then on the right you can change Macro Security.

I'd choose the Low or Medium. Then you need to close your file and reopen it so the new setting will take effect.
I did that and it came up with the page of script and runs in the background without the macro being enabled.
Initially I had the setting on Low but changed it so I get the security 'Prompt'

Not sure what I am doing wrong but here is the link to the calculator, if you want to play.

http://www.hse.gov.uk/research/rrhtm/rr446.htm
 

Members online


Latest posts

Top