Taking path name from another excel sheet

Hi
I need help in these. I have attached an excel file which enables to import sheets and other stuff(Thanks to tigeravatar) What I would like to do now is assume that there is a new sheet called the path name with the path in the range (A1). So whatever is in the range A1 would be the path name, thus the person would not need to change it through the coding. Please help! Thanks

Hello,

I think that you can just replace [in macro btn_ImportSheets_Click()]:

Const strFldrPath As String = "H:\Excel Testing\"
'with 2 new lines
'
dim strFldrPath As String
strFldrPath = sheets("Path Name").cells(1,1).value 'get path name from worksheet "Path Name"; You should change formatting into "text" in "Path Name" at Range A1 and type without double quote (only H:\Excel Testing\)

and in place where worksheets are delated you have to secure your path sheet so please consider to change one more line:

'now 
If ws.Name <> "SheetList" Then
' replace into:
If ws.Name <> "SheetList" and ws.Name <> "Path Name" Then

Best Regards
maczaq

Sorry, I don;t quiet understand the first part. How to change the "path name" into a text?

the cell contain path should be formatting as "text"

maczaq