Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Dim strNewFolder As String Dim strSaveAs As String Const conBaseFolder As String = "G:\GROUPS1\Sponsor\" strNewFolder = conBaseFolder & Sheets("Sponsor").Range("D39").Value strSaveAs = strNewFolder & "\" & Sheets("Sponsor").Range("D39").Value & ".xlsm" If Len(Sheets("Sponsor").Range("D39").Value) > 0 Then If Len(Dir(strNewFolder, vbDirectory)) > 0 Then MsgBox "This folder already exists." Exit Sub Else MkDir strNewFolder ActiveWorkbook.SaveAs strSaveAs, FileFormat:=52 End If End If
|Update master page from other tabs in Excel 2007||8||19|
|Excel -- need lookup or match function||4||34|
|Vlookup for IP||3||34|
|What is the Difference between Standard Deviations and z-scores, calculated within Excel ?||3||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!