Hi,
I'm trying to save the file to the correct folder. The folder is located on the "Folder Name/MM-YYYY" I would like the code to be able to dynamically select the current month's folder when they try to save the file.
Please Login or Register to view this content.
Last edited by Leith Ross; 07-16-2013 at 12:34 PM.
Hi, jksung5295,
as you are working with Strings you should use the ampersand for concatenating strings.
Give this a try:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Awesome, that does what it is suppose to.
One more things, if the folder is not already created, is there a way to create the folder and then open that new folder?
Hi, jksung5295,
like this:
Ciao,Please Login or Register to view this content.
Holger
Len(Dir(strPath, 16)) = 0
what is this function doing? How is that checking to see if the directory is available?
Hi, jksung5295,
it will check the folder and return a value of 0 if the folder does not exist while it shoul dreturn a value greater than 0 if the folder is already present. From what I noticed in your code I noticed there is no root in the string you´re bukdling so you might run into trouble using the code. If you´re working on a machine with a mapped drive maybe try instead
Ciao,Please Login or Register to view this content.
Holger
Thank you so much for your help. I was able to get your first code to work by modifying the address a little bit. Thanks bunch for your help! Works as advertised
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks