Sg51
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 3 articles for 0.303 sec
M>][WN[N[N[N[N[N[N[N[N[K8MBV+8VVV^?-:[N[N[N[N][WO>][WO>^^^^^^ M^^^^^^][WO>][WO>][W=W=W=W=W=W=W=W=W=UL6Q;%%L;;;?/FM=W=W=W=W>] M[WO>][WO????????????>][WO>][WO>][N[N[N[N[N[N[N[N[NZV+8MBV-MM MOGS6N[N[N[N[O>][WO>][WOOOOOOOOOOOOO>][WO>][WO>]W=W=W=W=W=W=W M=W=W=;%%L6Q;&VVWSYK7=W=W=W=WO>][WO>][WWWWWWWWWWWWWO>][WO>][WO M>[N[N[N[N[N[N[N[N[NM``````````````````````````````&Z(04+%%*F` M&Y$```'@"0+___________\/WWUG     

Group: alt.oyp.sworp · Group Profile · Search for Sg51 in alt.oyp.sworp
Author: jimmy
Date: Jul 8, 2007 17:08

Hi, Cell C4 is a date format. The macro works well if I do not add the myNewFolder in. Upon adding it in (and include your comment whereby I should add "\"), I was given a runtime error 1004. Why is this so? Regards, Dolphin "kassie" wrote: I notice there is no \ between your folder name and file name? myFilnename="M:\RECONCILIATIONS\" & myNewFolder & "\" & myMonth &
Show full article (31.89Kb)
Hi, I wanted to have my macro to save my file into a new folder according to the month it was for (ie, a new folder will be created every month). My macro goes like this, but it can't seem to work: Dim myMonth As String Dim myNewFolder As String myMonth = Format(Range("c4"), "yymm") myNewFolder = Format(Range("c4"), "MMM") myFileName = "M:\RECONCILIATIONS\" & myNewFolder     

Group: microsoft.public.excel.misc · Group Profile · Search for Sg51 in microsoft.public.excel.misc
Author: Dolphin
Date: Dec 14, 2006 20:43

Show full article (1.34Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Sg51 in microsoft.public.excel.misc
Author: Dolphin
Date: Dec 14, 2006 19:31

Show full article (0.52Kb)