Need a MSO .xls file's with macros rewritten to work Office

Just a meeting place for professional offers & requests
Forum rules
Disclaimer: this section of the forum is just a meeting place for professional offers & requests. We do not and cannot insure the liability of the proposal made publicly in the forum or privately after contact has been made in the forum. Therefore, please take up the offers made here at your own risk.

Need a MSO .xls file's with macros rewritten to work Office

Postby Scott#? » Sat Jun 02, 2018 8:26 pm

I have a .xls file that I need the macros rewritten so the file works properly in Open Office 4.1.5. The PC's OS is Windows 7. I am looking for a quote from someone who has this expertise, I can provide the file for analysis. It is 959K so it is to large to upload here.
Thanks,
Scott
OpenOffice 4.1.5 on Windows 7
Scott#?
 
Posts: 5
Joined: Sat Jun 02, 2018 7:08 pm

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Zizi64 » Sat Jun 02, 2018 8:49 pm

It is 959K so it is to large to upload here.


I suggest you to share it on a free file sharing service, like the Google drive. Maybe somebody can help you without fee.
And maybe your macros will run in LibreOffice without any translation. It is anyway the best to rewrite your macros based on the AOO/LO API functions, but you can try the LibreOffice, because the LO has a littlebit higher compatibility with the foreign fileformats and with the MS VBA macros.
- Are your macros pure BASIC codes or are there some callings of functions from third party .dll-s?
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7168
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Scott#? » Sat Jun 02, 2018 9:29 pm

Thank you for your quick response. I will try LO to see if I get any better results. I have moved the file to several PC with no errors so I would assume it is pure basic code. Being new to this process I apologize for my ignorance, I do have a google drive account I can upload the file to but how would that help me find someone who may do it for free?
Thanks
OpenOffice 4.1.5 on Windows 7
Scott#?
 
Posts: 5
Joined: Sat Jun 02, 2018 7:08 pm

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Zizi64 » Sat Jun 02, 2018 9:41 pm

but how would that help me find someone who may do it for free?

Without seeing the code, and without knowing all of the needed features and functions and all of the other details, I have not any information about the volumen of this job.

Yes, there are a small chance to convert your code in a few minutes, but maybe it need days or weeks of working...
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7168
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Scott#? » Sat Jun 02, 2018 9:50 pm

Tibor,
I would be happy to email you the file. It holds no sensitive data.
OpenOffice 4.1.5 on Windows 7
Scott#?
 
Posts: 5
Joined: Sat Jun 02, 2018 7:08 pm

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Zizi64 » Sat Jun 02, 2018 10:20 pm

email address sent by private message
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7168
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Scott#? » Sat Jun 02, 2018 11:33 pm

I have sent an email to you with the file a screen shot and the description of the functions. Please let me know if you do not receive it.
Thank you.
OpenOffice 4.1.5 on Windows 7
Scott#?
 
Posts: 5
Joined: Sat Jun 02, 2018 7:08 pm

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Zizi64 » Sun Jun 03, 2018 7:47 am

Yes, I received it (it went to the Spams, but i found it...).

I will study the file and the macros today.
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7168
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Zizi64 » Sun Jun 03, 2018 9:10 am

Your file will not work perfectly for me anyway, because it contains a link (somewhere, but I not found it yet) to an another file, what is not present on my PC:
file:///E:/Users/embroh/Documents/New_bestgrocerypricebookspreadsheetR2.xls

Linked_File1.png



Linked_File2.png
Linked_File2.png (7.26 KiB) Viewed 1107 times
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7168
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Zizi64 » Sun Jun 03, 2018 4:48 pm

I just studied your file, and I see some problems. I converted the file into .ods format, and purged the macro code, and optimized the picture to 256 color. The file size is only about 300 KiB now.


0.: The whole task seems as a Database related task, but not seems as a Spreadsheet related task. Unfortunately I can not give any help you for the usage of the Base application. This spreadsheet file is a badly managed and badly manageable database-like spreadsheet. Not an easy job to make it useable for the Apache Openoffice Calc or for the Libreoffice. (The existing VBA code can not run in LibreOffice.)

1.: There are some named Cell ranges those are located in the middle of its column (uses a part only of the filled-in column). Why? How they will be managed? And what about the rest parts of the filled-in column? For example the column "L" (Dairy) on the sheet named "Store, Category, and Product". See the picture:
Named ranges.png


2.: There are some unusable Sheet names (It is not too big problem: we can rename them, and we can substitute the names in the StarBasic code.) Never use white spaces and special characters in the Sheet names.

4.: The VBA macro code sometimes references the sheets by theirs number but not by theirs name. One subroutine call the sheet 3 and deletes the content of the cells from the cell A4 to the last used cell. Why from the row 4? The Sheet nr.3 (named: "Store, Category, and Product") has not 3 row header, but the sheet nr.2 has a 3 row header . Which one must be cleared? Maybe the original file has some hidden sheets, but I can not find them in the file what you sent for me.

5.: And there are lines in the VBA code that seems important. Who (and why) REM-ed them?

...and many more...

Please send the file to others too. Probably I can not convert your macros in a short (acceptable) time.
Last edited by Zizi64 on Sun Jun 03, 2018 6:26 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7168
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Need a MSO .xls file's with macros rewritten to work Off

Postby Scott#? » Sun Jun 03, 2018 4:58 pm

Tibor,
Thank you for your time and effort I will wait and see if anyone else responds.
Thank again.
OpenOffice 4.1.5 on Windows 7
Scott#?
 
Posts: 5
Joined: Sat Jun 02, 2018 7:08 pm


Return to Paid support

Who is online

Users browsing this forum: No registered users and 1 guest