Forum rulesDisclaimer: 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.

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

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, LO6.1.4 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.1.4 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.

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

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, LO6.1.4 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.1.4 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.

Tibor Kovacs, Hungary; LO4.4.7, LO6.1.4 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.1.4 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.

Tibor Kovacs, Hungary; LO4.4.7, LO6.1.4 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.1.4 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.

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_File2.png (7.26 KiB) Viewed 1517 times

Tibor Kovacs, Hungary; LO4.4.7, LO6.1.4 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.1.4 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.

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:

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, LO6.1.4 on Win7-10 x64Prof.PortableApps, winPenPack: LO3.3.0-6.1.4 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.