| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get Cell value and use as file name in macro
halarikeyur This line of code will not work as you have enclosed your variabl inside halarikey quote marks which makes it text With ActiveSheet.QueryTables.Add(Connection:="TEXT;File Nm", _ try With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & FileNm, -- mudrake ----------------------------------------------------------------------- mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247 View this thread: http://www.excelforum.com/showthread.php?threadid=27266 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy a cell in excell and paste in a txt file with macro | Excel Discussion (Misc queries) | |||
| excel - create a macro to use cell text as part of a file name | New Users to Excel | |||
| How to save file in a macro taking new name from cell contents? | Excel Discussion (Misc queries) | |||
| macro save a file name from a cell in 1st worksheet | Excel Discussion (Misc queries) | |||
| This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) | |||
![mudraker[_320_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
