Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a folder using macro...
I have a macro that brings up an Input Box which takes a filename (fnames$) and saves an excel sheet as that filename, I need this to create a folder first then save itself in the folder. The folder name would be the same as strProjectNumber... bk.SaveAs FileName:="C:\LOA\" & strProjectNumber & "\" & fnames$ OK, well obviously the above doesn't work but I am trying to get it to save as C:\LOA\ = Then a new folder based on the strProjectName = Then the filename fnames$ (previously entered from an Input Box (No help needed with this)) Anyone help? -- ChrisMattock ------------------------------------------------------------------------ ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912 View this thread: http://www.excelforum.com/showthread...hreadid=545527 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro creating folder and files automatically, without permission. | Excel Discussion (Misc queries) | |||
Creating a new folder | Excel Programming | |||
Creating Folder Folder in My Documents VBA - HELP | Excel Programming | |||
Macro for creating folder | Excel Programming | |||
creating folder | Excel Programming |