assigning the filename

**mvel_sky** · 05-14-2009, 04:12 AM

Dear All,

i have assigned a file name in a cell as mentioned below:

Cell Range File Name
AW17 Report1.xls

Thro' VBA code i am calling the file name as said below:

filename = Cells(17, 49).Value
Set TargetWB = Workbooks.Open(tPath & Application.PathSeparator & "filename")

But it is not working. Please tell me the right method for calling the file name.

**royUK** · 05-14-2009, 04:39 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

assigning the filename

LinkBack

Thread Tools

Rate This Thread

Display

assigning the filename

Re: assigning the filename

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions