Textbox.text to .getfolder(filename)

**ozan** · 11-09-2012, 07:24 AM

Hi,

makro2 is my folders name.

i want to replace the folders' name every time when i write a folder name (only folder name / the folders will be inside the same path) in a textbox on the sheet.

For example: If i write Nov-12 to textbox the red lighted part will be Nov-12, if I write Oct-12 to textbox the redlighted part will be Oct-12, and it goes on. With that name path name (filepath) will change when i change folder name in textbox.

However, if the textbox is empty and and anyone clicks on the button, macro will not exceute anything, and a msgbox will appear ('You have to enter a file name'

My whole code are in module1 and i think i need a textbox in Activex controls? Can you help me with the codes and processes?

And

Regards,

Ozan.

Please Login or Register  to view this content.

The workbook is attached.
My whole codes are:

Please Login or Register  to view this content.

**davesexcel** · 11-09-2012, 09:46 AM

You can populate a combobox from a specific folder, then select the workbook from the combobox to open.

Right click on the sheet tab to view the codes

**ozan** · 11-09-2012, 10:11 AM

Dave hi, thanks for your response.

Maybe i couldn' t define my problem. Imagine there are 20 different folder in "C:\Users\ozzy\Desktop\Sales" and every month folder numbers increase step by step. (in october if there are 20 folder, in november 21, december 22)

Please Login or Register  to view this content.

XX is the final folder name that contains the reference workbooks. And with a textbox when i write different name, so the reference folder changes. (after a button click.)

But, while textbox is empty and and anyone clicks on the button, macro will not execute anything (won't allow any procedure, and a msgbox will appear ('You have to enter a file name first')

My workbook is attached in the post.

Thanks again,

Regards,

Ozan.

**JosephP** · 11-09-2012, 10:16 AM

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

**Norie** · 11-09-2012, 10:17 AM

You can add the value from the textbox like this.

Please Login or Register  to view this content.

**ozan** · 11-09-2012, 10:37 AM

In an other forum, i asked for the same question with a similar name (maybe because i didn' t know about crossposting.)

The important reason was i got some answer, bot unfortunately didnt help my problem. The other post is in here and if it' s solved i' ll mark it as solved.

Thanks,

http://www.mrexcel.com/forum/excel-q...lder-path.html