Textbox contents as folder/filepath

Hi Guys,

I need a little help with the below code
The current code adds the contents of a textbox to the folderpath and pulls the file, But now i need the query to be in three parts:

1). A two part folder path consisting of:

a. (1st half ) "C:\Documents and Settings\carl.walker\My Documents\Reports\"
b. (2nd half) "Contents from textbox1"

2). The file name to pull from "textbox2"



Any help with this would be great.
Thanks in advance

Carl

Please Login or Register  to view this content.

Difficult to test with no sample workbook, but perhaps the below (or something like it) would do the trick:

Please Login or Register  to view this content.

BSB

Do you need to loop ?

Please Login or Register  to view this content.

BTW, variable declared as Const MUST be constant.

Hi Guys,

Thanks for your replies,

Hi Jindon,

Your code looks as if it should work but when i run it, it displays the MsgBox "No Serial number available", as if its not seeing textbox " TBM1Serial"?
Am I doing something wrong


Thanks
Carl

Please Login or Register  to view this content.

I though "FileName" would be a global variable, since you haven't assign within procedure.

If not, you need to add one line

Please Login or Register  to view this content.

But, yes, you still need to loop, because the user would enter just "g" or something...

Hi Jindon,

I done as you suggested but the msg box that appears, looks like its not adding the folder path from value "cmbDERS" to the string in order to find the file in that folder? also did i mention that the file is pdf?

Please Login or Register  to view this content.

regards
carl

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

And see how it goes...

Hi Jindon,

I'm away from home so will test it out on Friday when I get back.

Thanks again
Carl

Hi Jindon,

I tried with the altered line but still no joy unfortunately.....any ideas?

Please Login or Register  to view this content.

I need to see the real value of

Please Login or Register  to view this content.

Hi Jindon,

Value of cmbDERS is "a" which is the folder name

Value of FileName is "a123" which is the file name

I have attached a screen shot of the MsgBox that runs.

Thanks
Carl

Screen grab.jpg

And with file

I can not see your picture... something is wrong I guess.

Hope this works!

It is OK this time..

Can you also show me the mgsbox?

Please Login or Register  to view this content.

Hi,

I only get that one msgbox shown above, even if i remove folder "a" from the "reports" folder?

Carl

I mean

Please Login or Register  to view this content.

Hi,

I only get that one msgbox shown, even if i remove folder "a" from the "reports" folder?

Carl

ignore last message

Second screen grab

Can you just try this?

Please Login or Register  to view this content.

Nearly there now

I get the msgbox shown and if i click ok if retrieves the correct file, but if i delete folder "a" i just get a blank msgbox?

What do you mean by "delete folder "a"" ?

I was doing some error checking to see what would happen if folder "a" didn't exist and to see if msg "no such file" ran.

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hi Jindon,

I tried the following but it does the same thing?

Please Login or Register  to view this content.

What is "same thing"?

Sorry Jindon, I'm not explaining myself properly as usual

When the code runs, msgbox "." appears, and only when i click "ok" it retrieves the file.
What i need, is for it to retrieve the file without the msgbox appearing and need the msgbox to appear only if the folderpath does not exist.

We're pretty much there now, thanks for your help so far

Regards
Carl

You can delete unwanted msgbox, that was a msg for me to check....

Hi Jindon,

Yes of course, what am I thinking

Thanks for all your efforts with this, you've really helped me out

Regards
Carl