How to avoid "$" from a cell address ?

**nemo66ro** · 11-18-2012, 04:27 AM

Hello guys,

I would like to get a cell address in the following format: "string + long". The first idea was to use the replace function

. Even it seems a bit puerile it works. To be more specific I post the code below:

Please Login or Register  to view this content.

Do you know other solutions to solve better this small exercise ? Thanks in advance.

**Norie** · 11-18-2012, 04:31 AM

Use Address(0,0).

**nemo66ro** · 11-18-2012, 04:45 AM

Hello Norie,
Thank you very much for this simple detail. It is exactly what I want. By the way, are you the same person with that from my last post posted on the Access section ?

**Norie** · 11-18-2012, 04:51 AM

nemo66ro

Yes it was me - did you get anywhere with the problem?

I know I wasn't really much help especially with using an array to add records, but that really was the first time I'd seen it for ADO.

**nemo66ro** · 11-18-2012, 05:40 AM

Hello Norie,

Your suggestions helped me in way...After many searches and tests I think that my issue cannot be solved within ADO limits. Because of this limitation - we can load an array using GetRows method but we do not have something complementary to populate the rows from array - I am about to change the Access with Microsoft SQL Server 2008 which has a bulk insert option besides many other features. Because it is not properly to develop here this topic, I will come back to that thread posting a solution rather convenient - even it is based on looping

...Thank you very much for your interest.

**Norie** · 11-18-2012, 05:49 AM

What do you mean by there's nothing 'complementary?

I think it is possible by manipulating the array populated wth GetRows into a suitable format.

Might not be pretty but it could be done.

PS Did you look into my suggestion of importing/linking the table with the data you want to add then running an append query?

All of that could be done with code.