Use Excel VBA to write data into Nav 2009

Has anyone written Excel VBA to bring in excel data into Nav 2009?

is this possible without using Nav-dataport object to import.