Hi,
I'm struggling with formatting values using VBA by using the standard accounting symbols.
My plan is to take the information from a report that provides me with values and currency information in two separate columns. The currency is a three-letter code like USD, EUR, AUD etc. and I would use that to translate it to the proper accounting symbol.
My idea would be to set the accounting format using VBA (as if I would do it manually over "format cells - accounting - symbol") but I have only found complex and individual formatting code that I would need to apply and pre-define. As I don't know which currencies the report includes, an automated mapping from the three-letter code to the accounting symbol would be perfect but I fear that's not available.
Is there any property available to set the accounting symbol for the different currencies?
Hope you understand my problem and can help
Thanks
I'm struggling with formatting values using VBA by using the standard accounting symbols.
My plan is to take the information from a report that provides me with values and currency information in two separate columns. The currency is a three-letter code like USD, EUR, AUD etc. and I would use that to translate it to the proper accounting symbol.
My idea would be to set the accounting format using VBA (as if I would do it manually over "format cells - accounting - symbol") but I have only found complex and individual formatting code that I would need to apply and pre-define. As I don't know which currencies the report includes, an automated mapping from the three-letter code to the accounting symbol would be perfect but I fear that's not available.
Is there any property available to set the accounting symbol for the different currencies?
Hope you understand my problem and can help

Thanks