mapped driver macro option

http://www.excelforum.com/excel-prog...ml#post2036724

Hi

with help from the forum I finally completed a macro that would loop through selected workbooks in a folder and pull results to be shown in a new workbook.

This works fine by using a worksheet where the files are listed and in a1 of the worksheet, the path to the folder.

We have one workstation on the LAN with restricted access to the server, and therefore has mapped drives. Therefore the path to the folder containing the workbooks is different.

How could I instruct the macro when invoked - so in the case of that workstation - if the macro cannot find the files at the path stated in a1 of the workbook, it is to try a different location (The folder containing the workbooks is actually Drive:T)

Any help appreciated.

Hi Mudraker

I see how I can direct the macro to look at an alternative path - but - the problem I have is that the sheet which contains the list of workbooks has the path to these workbooks entered in cell a1 (see nigel1.xls)

would I have to create a nigel2.xls with the mapped driver details in it ??

Hi Leith

have noted your comment and ammended that section of macro. Where I have the problem is further into the macro

1. When the macro calls the wsheet "FILE LIST", the cell a1 contains the path to the other workbooks ie: "P:\My Documents\Trailer Files 2008\"


This would need the option of "V:\"

2. The created target workbook P:\My Documents\Trailer Files 2008\Fault Sheets\Fault File .xls

Would also need an option of V:\Fault Sheets\Fault File.xls

Any Help Appreciated

Rgds Nigel

Bump - no answer as yet

Same concept using DIR() as you did for the file.

Please Login or Register  to view this content.

Originally Posted by Kenneth Hobson

Same concept using DIR() as you did for the file.

Please Login or Register  to view this content.

Hi Kenneth, you have this line commented out. Just wanted to check if this was your intention.

Many thanks Nigel O'Gorman

Yes, I left it so that you could see what the value might be. You can delete it.

Comments can always be deleted but sometimes at the cost of knowing what your was doing at some point when you review your code in the future.

Obviously, there are other issues that might arise. e.g. Even the V:\ drive does not exist, the sheet does not exist, no value in A1, etc.

Originally Posted by Kenneth Hobson

Yes, I left it so that you could see what the value might be. You can delete it.

Comments can always be deleted but sometimes at the cost of knowing what your was doing at some point when you review your code in the future.

Obviously, there are other issues that might arise. e.g. Even the V:\ drive does not exist, the sheet does not exist, no value in A1, etc.

Kenneth
Thanks for reply, I will try to get working in the morning and post results,