vba coding

[dibyendu]

Dear sir,
I want auto save(backup) and update my data(every time when I write some thing) of my excel through VBA CODING in different excel located in different location and folder FOR EXAMPLE save my data to excel name "storage" located in D drive in new folder.(exactly to my original data ) Kindly help me out of the problem. The excel to be copied is attached here


Thank you sir

															SYMPTOMs															ACTIVITY		5. Worksheet 2 - Scoring Criteria for Condition	6. Work Sheet 3 - Scoring Metabolic Stress
SL.NO.	DATE (B3)	NAME (B4)	REG.NO (M3)	AGE (M4)	HEIGHT (C10)	SEX (P3)	BMI(P4)	CW (G9)Kgs	1MW (G12)	6MW (G13)	FI (T14)	All relevant diagnoses (E94)	STAGE (E95)	TREATMENT (B98)	SYM.3.1 (A20)	SYM.3.2(A21)	SYM.3.3(A22)	SYM.3.4(A23)	SYM.3.5(A24)	SYM.3.6(A25)	SYM.3.7(A26)	SYM.3.8(A27)	SYM.3.9(A28)	SYM.3.10(A29)	SYM.3.11(A30)	SYM.3.12(A31)	SYM.3.13(A32)	SYM.3.14(A33)	SYM.3.15(A34)	AC.4.1(K20)	AC.4.2(K21)	AC.4.3(K22)	AC.4.4(K23)	AC.4.5(K24)	% Wt.Loss (L49)	SCC.2.1 (K42)	SCC.2.2 (K43)	SCC.2.3 (K44)	SCC.2.4 (K45)	SCC.2.5 (K46)	SCC.2.6 (K47)	SCC.2.7 (K48)	no fever (E58)	no fever (E59)	no steroids (E60)	>99 and <101 (H58)	<72 hrs (H59)	low dose (<10mg prednisone equivalents/day) (E60)	>101 and <102 (K58)	72 hrs (K59)	moderate dose (>10 and <30mg prednisone equivalents/day) (K60)	>102 (N58)	> 72 hrs(N59)	high dose steroid ( >30mg prednisone equivalents/day) (N60)	PE (S80)	PG-SGA RATING (K90)	TOTAL PG-SGA SCORE (N97)
1	14/06/2015	S15	0	50	157	M	25.15	62	65	0	unchanged	LY	0	CT	YES	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	YES	0	0	0	2	YES	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	A	6
2	18/04/2015	S16	0	67	152	M	14.72	34	35	0	less than usual	OC	0	SUR+CT	0	0	YES	YES	0	0	0	0	0	0	YES	0	0	0	Depression	0	0	YES	0	0	1	YES	0	0	0	0	YES	0	0	0	0	0	0	0	0	0	0	0	0	0	2	C	14
3	18/04/2015	S17	0	59	163	M	14.68	39	40	0	less than usual	OE	0	CT	0	YES	YES	0	0	0	0	0	0	0	0	0	0	0	Depression	0	0	YES	0	0	1	YES	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	14
4	18/04/2015	S18	0	28	154	M	17.29	41	40	0	less than usual	OC	0	SUR+CT	0	0	YES	0	0	YES	0	0	0	0	0	0	0	0	Depression	0	0	YES	0	0	0	YES	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	B	9
5	14/06/2015	madam	12345/12	44	160	F	21.48	55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0
6	14/06/2015	sample	12345/12	44	160	F	21.48	55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0
7	14/06/2015	test	12345/12	44	160	F	21.48	55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0
8	14/06/2015	LAST	12345/12	44	160	F	21.48	55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0
9	14/06/2015	BIG	12345/12	44	160	F	21.48	55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0
10	14/06/2015	LOOK	12345/12	44	160	F	21.48	55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0
11	14/06/2015	END	12345/12	44	160	F	21.48	55	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0
12	16/06/2015	DNA	0	0	0	0	#DIV/0!	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Review	0	0

<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col span="8"><col span="6"><col span="5"><col><col span="7"><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Smitty]

Welcome to the Board!

I'd start by recording a macro performing a SaveAs, which will give you the correct file path.

Then you can change it to SaveCopyAs in VBA and call it from a Change event, or just assign the code to a button. To give you some Change event code we'd need to know when it should be triggered. That is changing what range should do it?

 

[My Aswer Is This]

There are a lot of things the macro recorder cannot do, but you can get a lot of code from a recording session that you can use in code you want to write yourself.
Want to know how to write code to scroll. Just run a macro and then copy the scroll code:
ActiveWindow.LargeScroll Down:=-1
ActiveWindow.SmallScroll Down:=73

 

[dibyendu]

Welcome to the Board!

I'd start by recording a macro performing a SaveAs, which will give you the correct file path.

Then you can change it to SaveCopyAs in VBA and call it from a Change event, or just assign the code to a button. To give you some Change event code we'd need to know when it should be triggered. That is changing what range should do it?

It should triggered as soon as a new subject's data is completed and should be updated automatically by pressing a button.And at the same time the file of the stored excel should not open automatically
Sir, if there is any option to post my excel here so that is becomes easy to understand
Thank you
Dibyendu Sharma

 

[Smitty]

Have you tried recording a macro?

 

[dibyendu]

I have done macro recording ... I have entered an entire subject data and some code has appeared in vba . and now I want to copy the entire subject's data into new ms excel situated in different location automatically...... how to do this please guide me...

Dibyendu Sharma

 

[Smitty]

and now I want to copy the entire subject's data into new ms excel situated in different location automatically...... how to do this please guide me...
Dibyendu Sharma

It sounds like you got the first part, so I'd record a macro copying the source data, then opening the destination workbook and pasting it.

Post back the resulting code when you're done.