Results 1 to 3 of 3

Getting cell data into macro filespec

Threaded View

LonnieP Getting cell data into macro... 09-27-2010, 07:13 PM
JBeaucaire Re: Getting cell data into... 09-27-2010, 07:40 PM
LonnieP Re: Getting cell data into... 09-28-2010, 12:11 PM
  1. #1
    Registered User
    Join Date
    02-25-2010
    Location
    Riverside, CA
    MS-Off Ver
    Excel 2003
    Posts
    23

    Getting cell data into macro filespec

    I've got a drive letter (including the colon) in cell P7 - It's always in P7.
    I've got a file name in (including .xls) in cell W5 - It's always in W5.
    My current hard coded line is:
    Workbooks.Open Filename:=("C:\Calcblox\pool\bm1.xls"), updatelinks:=3

    Question, how do I get the text items in cells P7 and W5 into this line of code.
    Both items are variable under user control.
    I think I'm missing something really simple here.

    Lonnie
    Last edited by LonnieP; 09-28-2010 at 12:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1