Macro is not there but still runs

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
Cdasilva
Posts: 3
Joined: Thu Jul 31, 2008 2:56 pm

Macro is not there but still runs

Post by Cdasilva »

I am programming in VBA to change an Excel sheet. After the file closed and autorecovery- Now I am unable to see one of my macros in Module 1, whilst macro's in Module 2 are visible. Whats even stranger is that the(invisible) macro runs. Please help, it took me weeks to program it.
OOo 2.3.X on Ms Windows Other
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Macro is not there but still runs

Post by Villeroy »

Go to Module1, hit Ctrl+A, Ctrl+C. What's in the clipboard?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Cdasilva
Posts: 3
Joined: Thu Jul 31, 2008 2:56 pm

Re: Macro is not there but still runs

Post by Cdasilva »

Ctrl A and Ctrl C does nothing so I assume there is nothing in the clipboard. Any other suggestions?
OOo 2.3.X on Ms Windows Other
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Macro is not there but still runs

Post by Hagar Delest »

Can you upload the file here (see here: How to attach a document here)?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Cdasilva
Posts: 3
Joined: Thu Jul 31, 2008 2:56 pm

Re: Macro is not there but still runs

Post by Cdasilva »

Sorry Hagar file is way too big I can only zip it to a 1000 KB and the sharing file is undergoing maintenance
OOo 2.3.X on Ms Windows Other
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Macro is not there but still runs

Post by Hagar Delest »

Even if you remove all the content to keep only the macro modules it's too big?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Macro is not there but still runs

Post by Villeroy »

Hagar de l'Est wrote:Even if you remove all the content to keep only the macro modules it's too big?
He could also paste his clipboard content for the same purpose ;)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Macro is not there but still runs

Post by Hagar Delest »

But his clipboard seems to be empty!
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Macro is not there but still runs

Post by Villeroy »

Ctrl A and Ctrl C does nothing so I assume there is nothing in the clipboard. Any other suggestions?
Hagar de l'Est wrote:But his clipboard seems to be empty!
Copying does not do anything visible, which is why he assumes that it is unchanged.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Macro is not there but still runs

Post by Hagar Delest »

It should at least highlight the code.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Post Reply