EXCEL

[Almevt]

I am trying to work on excel doing a logbook on my mac. I have 2 xlsb files (places and reasons) that have to merge to give me the column in my mine file xlsm. The first function I have to do is to do in the workbook is to enable Macros. Then update. The the whole workbook appears, I enter all the amounts in the various columns. When I want to fill in the PLACES and REASONS I get the following answer: ( I have attached the 3 images I get. I hope you will be able to help me as it is urgent.

EDIT:
I can seem to upload the images as they are to big. but it says the following: Unable to open Excel File: Logbook Reasons.xlsb
Unable to open Excel File: Logbook Places.xlxb
the last message I get
Microsoft Visual basic:

Script out of range.

Thank you so much!!

 

[sijpie]

Can you open the xlsb files manually on your Mac?

Normally excel files are stored as .xlsx or .xlsm, which are essentially zipped xml files. .xlsb is a binary storage format, and is more akin to the old .xls format.

I use .xlsb format when I have files with very large data sets, as they are then very much smaller in file size then the equivalent .xlsx

So if you cannot open the xlsb file, ask someone with a windows pc to open the file and store as xlsm

Then amend the extensions in the macro

 

[Almevt]

Can you open the xlsb files manually on your Mac?

Normally excel files are stored as .xlsx or .xlsm, which are essentially zipped xml files. .xlsb is a binary storage format, and is more akin to the old .xls format.

I use .xlsb format when I have files with very large data sets, as they are then very much smaller in file size then the equivalent .xlsx

So if you cannot open the xlsb file, ask someone with a windows pc to open the file and store as xlsm

Then amend the extensions in the macro

Thank you so much for coming back to me. I can open the xlsb files on my Mac and I saved them as xlsm files. Can you please tell me how to amend the extensions in the macro. I am a not really a computer boffin!!

 

[MARK858]

Script out of range.

If you mean Subscript out of range then that is caused by a naming error in the code.
In your case this is probably because you have spelt the extension wrong in "Logbook Places.xlxb", it should be .xlsb

 

[Almevt]

If you mean Subscript out of range then that is caused by a naming error in the code.
In your case this is probably because you have spelt the extension wrong in "Logbook Places.xlxb", it should be .xlsb

Sounds complicated to me but I will try. Thank you so much.

 

[sijpie]

Open the macro in the VBA editor. Do a search for xlxb. Replace it with xlsb. Then retry