| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO CHANGE RESULT WITH SAME MACRO CODE
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use code/macro to change code/macro in an existing file? | Excel Programming | |||
| Executing code in a library as a result of a worksheet change | Excel Programming | |||
| Macro code to change tab name | Excel Programming | |||
| Change result of Macro Recorder | Excel Discussion (Misc queries) | |||
| Can You Change A CommandButton Code Using A Macro? | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
