Page 1 of 1

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

Posted: Sat Jun 02, 2018 8:26 pm
by Scott#?
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

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

Posted: Sat Jun 02, 2018 8:49 pm
by Zizi64
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?

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

Posted: Sat Jun 02, 2018 9:29 pm
by Scott#?
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

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

Posted: Sat Jun 02, 2018 9:41 pm
by Zizi64
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...

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

Posted: Sat Jun 02, 2018 9:50 pm
by Scott#?
Tibor,
I would be happy to email you the file. It holds no sensitive data.

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

Posted: Sat Jun 02, 2018 10:20 pm
by Zizi64
email address sent by private message

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

Posted: Sat Jun 02, 2018 11:33 pm
by Scott#?
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.

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

Posted: Sun Jun 03, 2018 7:47 am
by Zizi64
Yes, I received it (it went to the Spams, but i found it...).

I will study the file and the macros today.

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

Posted: Sun Jun 03, 2018 9:10 am
by Zizi64
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 15670 times

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

Posted: Sun Jun 03, 2018 4:48 pm
by Zizi64
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.

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

Posted: Sun Jun 03, 2018 4:58 pm
by Scott#?
Tibor,
Thank you for your time and effort I will wait and see if anyone else responds.
Thank again.