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.
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.