Hi All
This might be basic but is it possible to save a file into a folder within a folder within a folder based on Cell values.
What I want to do is save as the following:
Save Worksheet Name in Folder ActiveSheet.Range("E6") within Folder ActiveSheet.Range("E5")
To get you started.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
hi bakerman2
What I have is the following code giving a 1004 runtime error.
Please Login or Register to view this content.
Make sure of the path
Can you mention what the values are in the cells mentioned in the code? I think the problem is related to the path as I tested the code and it works well for mePlease Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi YasserKhalil
Thanks for input. Values are as follows:
D5 = "Week"
E5 = "1"
E6 = "July 2016"
Try not to type directly "July 2016" in E6 .. Try typing it but put apostrophe before the string (to deal with it as text)
In E6 type
Please Login or Register to view this content.
Tried .... To no avail. The cell is populated from a textbox
Hi All
I have tried changing the cell values to almost anything and still get error code
Can you upload sample workbook?
Here you go
Test this.
Please Login or Register to view this content.
Last edited by bakerman2; 07-24-2016 at 05:56 AM.
bakerman2...
That works like a charm.....What, how.
You're welcome and thanks for the rep points.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks