Get a dynamic Folder Location?

In the attached file there is a button at the top of the MasterCopy sheet tab called "Create .xlsx From Selected for BEC" that saves selection (from column C) as an Excel .xlsx file to a specified location that is determined by the green button at the top of the sheet.

It saves the file but, how would I also save whatever the location is to a variable too?  The user will give it a filename and the file saves, however I need that complete folder path and filename.xlsx to be used in another procedure in SAP.  How would I get that?  I need to populate a field in SAP with that location.  Please advise and thanks.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


I am not entirely sure what you are wanting here, but I have taken a guess, and attached an updated version of the file that now includes a new worksheet I created called "Example_FileName_Save".

The path is placed into A1, the filename into A2, and A3 concatenates the two together if you need a single string.

How you would get that into SAP is another question entirely - you'd have to know SAP for that of course.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RWayneHAuthor Commented:
This looks like it will work...  I will do some testing on this and let you know.  Thanks!
RWayneHAuthor Commented:
Yup it worked and testing proved ok... Sorry for the delay in reply.  Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.