To have flexibility to open workbook file on a specific drive\subfolder.

Hi Expert,

I was new on VB scrip, my understanding on the below function use are not that good.

I have one excel file (A) that has macro button to open up another excel file (B) at the same subfolder location with the below function.

========================

Please Login or Register  to view this content.

==================================

Query 1 : What does it mean on "Const MY_DOCUMENTS = &H5&" ?
Query 2 : is that possible to change the path to be more specific as fixed it at c drive\ subfolder? What changes i should make on the function above?
Query 3 : is that possble to change the path to flexible where user paste the folder at desktop or other drive on above statement?
Query 4 : I keep having problem on running above function which doesn't recognised the excel file (B) to be open. How do I refresh the path variable?

query 5 : For excel file A & B are sitting at the same subfolder, how do i get the macro button to automatic call search file from the same subfolder and with the filename as "Quotation Form.xls"

hope to hear the expert.

Thanks

Regards,
Anney Png

anneypng, 2 things...

1st, please use code tags on your code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here. as you are new to the forum, i have done it for you this time, but please remember to use them in future

2nd. showing us a picture of your file/problem, may just get you a picture back, shoing you how it was fixed. please upload a sample of your workbook, showing examples of your data, what your expected outcome is, and how you would arrive at that.

thx