Hi all, I got macro in which I have code (see below)
Range("A1").Value = ThisWorkbook.FullName
Above macro code brings "F:\Kas\Documents\Profit.xlsx" text in cell
"A1"
Is there way that by putting "ThisWorkbook.FullName" just bring "\Kas
\Documents\Profit.xlsx" and exclud the word "F:" and add "\\Home\ABC"
in the line
so it should be coming in cell "A1" "\\Home\ABC\Kas\Documents
\Profit.xlsx". I hope I was able to explain my question. Please can
any friend help?