Posted to microsoft.public.excel.programming

Kashyap

external usenet poster

Posts: 131

Get file name to open from cell

I have the below code where file name is 'Disposition'..

I need to make macro to pick file name from Sheets("Set").Range("B2").Value

Workbooks.Open ThisWorkbook.Path & "\Misc\Disposition_of_Calls.xls", True

ActiveWorkbook.Sheets("Calls_Report").Range("F2"). Value =
ThisWorkbook.Sheets("mySheet").Range("L7").Value

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to Open excel file when file name is entered in cell	K[_2_]	Excel Programming	4	March 17th 09 12:12 AM
using cell value to open file	Doug	Excel Programming	4	June 7th 08 01:11 AM
open file by inputting file name in cell?	Roger Abbot	Excel Discussion (Misc queries)	1	September 15th 07 02:38 PM
Open file with file name from cell	Thore	Excel Programming	1	August 24th 04 10:20 AM
Open file from Cell	Brad	Excel Programming	2	April 13th 04 04:56 PM

All times are GMT +1. The time now is 08:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us