Hi all,
I got a problem with using the result from Application.FileDialog (I wanna let the user to select a location to save) which is in the second procedure in a module. In my first procedure, I have to use the path that resulted from Application.FileDialog in the 2nd procedure.
What should the code look like in the first procedure to use the result from the second procedure?
Thanks
Last edited by lubbamkt; 05-11-2014 at 10:18 AM.
You can use the Application.GetSaveAsFilename and assign it to a module level variable
Then use that variable in the first macro
Simplified code example:
Please Login or Register to view this content.
Last edited by RudiS; 05-11-2014 at 06:24 AM.
Regards,
Rudi
Thanks RudiS,Originally Posted by RudiS
You can use the Application.GetSaveAsFilename and assign it to a module level variable
Then use that variable in the first macro
Simplified code example:
Please Login or Register to view this content.
What if I would like to use FileDialog instead of GetSaveAsFilename? Do i need to use Function instead of Sub to run FileDialog in order to use the result in another Sub procedure?
Change the first Sub into Function that returns the directory/path the user has selected.
You can then call the function from the second sub.
If you post the code for the first sub I'll show you what I mean.
If posting code please use code tags, see here.
Norie, Here you are, Thanks
Please Login or Register to view this content.
You already have a function, but it's not returning a value.
So you just need to add code to return the folder selected.
Please Login or Register to view this content.
Thank you NorieYou already have a function, but it's not returning a value.
So you just need to add code to return the folder selected.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks