How To Import Share Prices?

[Bazza06]

I have been given a spreadsheet that is used to automatically update share prices from a publicly available website on a regular basis.
I am using a MAC but the spreadsheet was designed to be used on a PC.

However, on my MAC I use MS Excel for MAC and whilst I am able to open and view the spreadsheet, the price update function does not work.

The column that contains the fields for the updated prices has this formula: =@VBAProject.Module4.CryptoQuote([@Code])

I am a very basic user of Excel and I have no idea what this means, and I do not understand why a spreadsheet that was designed for Windows OS cannot equally function within the same software but running on a MAC.

Is it possible for this to work on my MAC and, if so, how do I go about doing so?

Thank you.

 

[steve the fish]

Its a user defined function, you will have function called 'CryptoQuote' in module4. These types of queries are going to be operating system specific so it isnt going to work on a mac without a rewrite of the code.

 

[Bazza06]

Its a user defined function, you will have function called 'CryptoQuote' in module4. These types of queries are going to be operating system specific so it isnt going to work on a mac without a rewrite of the code.

Thanks for your reply.

Could I take the spreadsheet I have and change the specific column / cells where I want the prices to be updated and have the code rewritten to be compatible for the MAC or isn’t it as simple as that? Does the whole spreadsheet need to be rewritten?

Sorry, I’m not fluent in Excel, and my simple mind doesn’t understand why one Excel spreadsheet cannot work both on a PC and Mac.

 

[steve the fish]

Just the code needs to be rewritten. Look for mac alternatives to xmlhttp which im presuming you are using in the code. I dont have a mac to help further sorry.

 

[Bazza06]

Just the code needs to be rewritten. Look for mac alternatives to xmlhttp which im presuming you are using in the code. I dont have a mac to help further sorry.

Thanks, Steve. Appreciate your help.