trim space in front and behind

[Welshgasman]

here is the file, i just deleted sensitive information
, there are some macros, i didnt know how to remove them

As long as there enough to replicate the issue.
No workbook?
That is essential don't you think?

DB is too late for me.
I can still work with the workbook if you supply that and a DB of my own.

[Micron]

I removed what would have been the first reply because I thought I was being dense. After waiting for others to add clarity that I still don't have, I must ask:
You're opening a connection to an Access database ( with cnn variable) and then trying to reference ActiveSheet (an Excel object) after making that connection, but Access has no such thing such as "ActiveSheet" and I see no reference to any workbook in that code. How is that supposed to work.

[Welshgasman]

Micron,
O/P said in post 12 I shall point out that the macro is ran from excel and saving the name into a column on a cell in access. (not sure if this matters)

[Micron]

I guess if I had made that first post y'all wouldn't have had to wait for post 12 to find out. Kinda surprised that no one asked before then but it didn't seem to matter. I guess my problem is that I did first look to see where the thread was posted and it is in Access forum.
I just figured the connection was from Access to Access. My bad I guess.

[chubbychub]

ok, its unlocked now.. took me a while to figure it out

[chubbychub]

HI, MOKE123 that was the answer, it does work, for some reason it didnt work when i tried it the first time (Probably my lack of knowledge, dont really know what i did) but i tried it again and it worked! thank you all for the replies. Thread solved, and rep added to all that replied, thank you all again Welshgasman and Micron.
this works:

rst![Name] = trim(Sheets("Quote").Range("C1"))

[moke123]

I did first look to see where the thread was posted and it is in Access forum.

So did I but you would think there wouldn't be much of an issue with something as simple as Trim()

Why is the vbe locked?
Why are the tables hidden?

You need to change the field name for the Field "Name"
You should have gotten an error msg when you made the table

[moke123]

Glad you got it sorted.

You may want to consider using access to link to your excel file and work from access.

https://support.microsoft.com/en-gb/...source%20cells.