Open multiple files from a folder based on cell information?

Hello bshape1,

Provided your cells contain the full directory path and file name, this macro should work. One problem I see is with using UsedRange to find the last cell. This could cause your range to include lots of empty cells which will produce an error. You also declared totalrows as a String. You need a number for the loop to work. Also, you shouldn't define variables with names that are defined in VBA, like row in your code.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks for the reply.

I have used the above macro and it open the first one up. But I can't get it to open the others in the column.

I'm using a spreadsheet with the names of some files downloaded from a website. Then I'm using a formula ="S:\iMacros Program\iMacros\Downloads\Markback_"&A2&".xls" to get the path.

Name: Path:
Jim S:\iMacros Program\iMacros\Downloads\Jim.xls
James S:\iMacros Program\iMacros\Downloads\James.xls
John S:\iMacros Program\iMacros\Downloads\John.xls

I want the macro to open up all the spread sheets in the column from Jim to John. I can't use open whole folder because the names change each day and the files don't get deleted.

Again thanks for any help you can give.

Hi
you can try these codes if col A has the filepath with filename

Please Login or Register  to view this content.

Ravi

Hi,

Thanks for all your help. Had to make one adjustment to the above code for it to work. Here is the finished code:

Please Login or Register  to view this content.

Thanks

B

Can a moderater to mark this solved?

Hi
Instead of activating the sheet, you can modify the code as follows

Please Login or Register  to view this content.

Ravi