Open File Using Path in One Cell and Filename in Another Cell

**freybe06** · 08-20-2019, 11:03 AM

Hey Everyone!

It's been a little while since I've written a macro so I'm kinda rusty - I did some google'ing but couldn't find exactly what I'm going for.

The easiest way to put it:

If A1 is "YES", then open the file where the folder path is in B1 and the filename is in B2. If A1 does not say "YES", then don't run the macro.

Thanks in advance!

**6StringJazzer** · 08-20-2019, 11:13 AM

What kind of file is it?

**freybe06** · 08-20-2019, 11:14 AM

Its opening a xlsm file

**CK76** · 08-20-2019, 11:17 AM

I assume it's workbook that you are trying to open and that you have the worksheet with stored values active.

Something like...

Please Login or Register  to view this content.

**dangelor** · 08-20-2019, 11:17 AM

Possibly...

Please Login or Register  to view this content.

placed in the sheet's code module.

**freybe06** · 08-20-2019, 11:30 AM

Both worked! Thanks!

Open File Using Path in One Cell and Filename in Another Cell

LinkBack

Thread Tools

Rate This Thread

Display

Open File Using Path in One Cell and Filename in Another Cell

Re: Open File Using Path in One Cell and Filename in Another Cell

Re: Open File Using Path in One Cell and Filename in Another Cell

Re: Open File Using Path in One Cell and Filename in Another Cell

Re: Open File Using Path in One Cell and Filename in Another Cell

Re: Open File Using Path in One Cell and Filename in Another Cell

Thread Information

Users Browsing this Thread

Similar Threads

Open file path from cell, paste into new sheet named from another cell and loop

Save File with set path + cell value as filename - code require fix

[SOLVED] Workbook.open a filename with path and cell value in it

Need to play a wav file based on path and filename in a selected cell using macro: SOLVED!

Find filename and path of a linked file in another cell

[SOLVED] open file with cell value as filename

Open File which path is in a cell

Bookmarks

Bookmarks

Posting Permissions