Hel with Dim and detrmining dimension

Hi dear friends


Hope all of you are rocking

I am a beginner to VBA and hmm I was scratching my head and digging in google yest onwards is there any way to solve this

I have a network share folder where users will save file


eg:

Dim user3
dim user4
dim user5



user3 = Range("A2").Value
user4 = Range("A3").Value

dis is a example not actual snippet


\\id-fm01\Profiles\WorkTools\Britto\CREDENTIALS.XLSX
\\id-fm01\Profiles\WorkTools\SAM\CREDENTIALS.XLSX
\\id-fm01\Profiles\WorkTools\TAM\CREDENTIALS.XLSX
\\id-fm01\Profiles\WorkTools\USER3\CREDENTIALS.XLSX
\\id-fm01\Profiles\WorkTools\USER4\CREDENTIALS.XLSX
\\id-fm01\Profiles\WorkTools\USER5\CREDENTIALS.XLSX
\\id-fm01\Profiles\WorkTools\USER6\CREDENTIALS.XLSX

IF I run d snippet


problem is dimension value is not taking to path.. it showing as file not found

What is the entire code you are using?

Here is the code ...

Please Login or Register  to view this content.

here in the
path "\\is-fs01\QA & Training\Claims\Consolidation Reports\Schakka\Production Report October 2012.xlsx"


i would like to put "schakka" which is a username in my excel sheet in a specific cell so that tommorow even if my user changes .. I dont need to change the snippet

Thanks a Lot Arul for reply

Thanks Stojk089,
I will implement and get back .. gve me some time , I think it will work cent percent ... thanks a lot and for Arul also...