search

hilkoc / vbaDeveloper

Tools for development and version control of vba code
MIT License
510 stars 138 forks source link

Import fails if workbook has named ranges containing comma #17

Open SteGriff opened 8 years ago

SteGriff commented 8 years ago

Hi there,

Thanks for making this add-in!

In our project, we have named ranges based on formulae which contain commas. When the import procedure tries to parse NamedRanges.csv, it gets in a pickle because of our extra commas.

I fixed this by writing and reading the NamedRanges.csv file using semicolon as a separator instead. I can submit a pull request for this if you think it's a good step!

Thanks! Ste