Creating Dynamic Folders/WorkBook from a Sheet with Dynamic Path.

Dear Pike,

Honestly I am no good in VBA its just that I can understan certain codes..
I would appreciate if you tell me where do I put these codess like I tried putting all of this in the Module and got an error..

Missing FOr..

SO would appreciate if you could add a File or explain where I put the code...

Warm Regards
e4excel

Dear Pike,

I think I am not geting it right..
Still getting an error..

So I am attaching my sheet, please make corrections wherever necessary and advise me on the same and also please also upload the corrected file ..

As I think this would be the last leg of this File..

Warm Regards
e4excel

Thanks a lot PIke it works really well, but just had to ask you a few questions regarding the Function GetFolderName..

If I am not mistaken the GetFolderName and the GetPath function are to counter the WorkSheet formulas

Please Login or Register  to view this content.

Please Login or Register  to view this content.

which are volatile in nature..

Right..

I liked the idea of getting a Screen to decide the FOlder Path to store the New WorkBook however can we just have it fixed as it needs to be store at the same place where the "MOving Data XXXX.xlsm" is stored..sp we can freeze it to that..

Thanks a lot for giving an idea on the HIGHLIGHTING portion as I was not aware of that, that would be helpful in future when doing anything in VBA..

Thanks a lot..Pike God Bless..just advise on freezing the path..

Warm Regards
e4excel.

Wow Pike the last code was the most impressive for me as it was more simple to understand types ..

Thanks a lot for such a code and it works very well after I just changed the ".xlsm" to ".xls"...

I think this is good good for me but just incase if you want to check as why I got an error when it was ".xlsm"..

I got the following error

Run-time error '1004':

This extension can not be used with the Seleceted file type. Change the file extension in the File name text box or select a different file type by changing the Save As type..


That was for FYI..

SO thanks once again for all your hrlp..

God bless..!

War regards
e4excel

Dear Pike,

I have marked the Thread as SOLVED however would appreciate if you could just let me know as to why Im geting an error when its not changed to "xlsm" and even when its changed to ".xls" while closing the newly generated file it gives an indiacation of a difference in format,

Warm Regards
e4excel

Dear Pike,

I am getting an error in the following line:

Please Login or Register  to view this content.

ANd after changing the above to ".xls" I get an error and closing the new WorkBook..

as follows;=

The file you are trying to open is in a different format than specified by the file extension.
Verify that the file is not corrupted and is from a trusted source before opening the file.
Do you want to open the file now?

E4excel

Thanks for replying Pike,,
Will get back after testing...

Regards
e4excel

Thanks a lot Pike for the link and all your help..
SO the additional code's not required..
And finally I conclude that its over now..
I just realised that the saved file is 97-2003 so good for me..then!

Thanks a zillion for staying put till the end..

Warm Regards
e4excel