<![CDATA[
<P>완전 초보인데... 일의 반복작업 좀 쉽게 해볼려고 하는데.. 고수님들 함 봐주세요</P>
<P> </P>
<P>작업순서는 이렇습니다.</P>
<P>1.엑셀에 추가기능 넣기</P>
<P>2.추가기능에서 dss파일 오픈해서 불러오기</P>
<P>3.여기서 부터 반복작업....</P>
<P> "5"시트부터 추가기능>store> regular time series 선택하여 실행</P>
<P> 팝업창 2개뜨는거 ok실행</P>
<P> "10"시트에서 같은작업</P>
<P> "15"시트에서도~1440 시트까지</P>
<P> </P>
<P> </P>
<P>3번 이후로만 좀 짜주세요....</P>
<P> </P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><img src="https://t1.daumcdn.net/cfile/cafe/234D4C4A5141CA5C08" class="txc-image" style="FLOAT: none; CLEAR: none" actualwidth="759" border="0" hspace="1" vspace="1" width="759" id="A_234D4C4A5141CA5C089426"/></P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><img src="https://t1.daumcdn.net/cfile/cafe/184A814A5141CA5D0C" class="txc-image" style="FLOAT: none; CLEAR: none" actualwidth="725" border="0" hspace="1" vspace="1" width="725" id="A_184A814A5141CA5D0C9C99"/></P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><img src="https://t1.daumcdn.net/cfile/cafe/1274CC505141CA751F" class="txc-image" style="FLOAT: none; CLEAR: none" actualwidth="463" border="0" hspace="1" vspace="1" width="463" id="A_1274CC505141CA751F26D8"/></P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><img src="https://t1.daumcdn.net/cfile/cafe/1370BD505141CA7526" class="txc-image" style="FLOAT: none; CLEAR: none" actualwidth="397" border="0" hspace="1" vspace="1" width="397" id="A_1370BD505141CA752671F9"/></P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><a href="javascript:checkVirus('grpid%3Dt62Z%26fldid%3DCxqT%26dataid%3D842%26fileid%3D5%26regdt%3D20130314220537&url=http%3A%2F%2Fcfile256.uf.daum.net%2Fattach%2F193A114B5141CAB5181563')"><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_etc_s.gif?rv=1.0.1" border="0" alt="첨부파일" class="vam"/> DSSEXCEL.xla</a></P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><a href='javascript:fileFilterViewer("http://cfile277.uf.daum.net/attach/2745E34B5141CAB605673C", "/cfile277/27/45E34B5141CAB605673C", "DssExcelAddinManualV.3.pdf", "grpid%3Dt62Z%26fldid%3DCxqT%26dataid%3D842%26fileid%3D6%26regdt%3D20130314220537&url=http%3A%2F%2Fcfile277.uf.daum.net%2Fattach%2F2745E34B5141CAB605673C")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_pdf_s.gif?rv=1.0.1" border="0" alt="첨부파일" class="vam"/> DssExcelAddinManualV.3.pdf</a></P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><a href="javascript:checkVirus('grpid%3Dt62Z%26fldid%3DCxqT%26dataid%3D842%26fileid%3D7%26regdt%3D20130314220537&url=http%3A%2F%2Fcfile269.uf.daum.net%2Fattach%2F1148084B5141CAB7015744')"><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_etc_s.gif?rv=1.0.1" border="0" alt="첨부파일" class="vam"/> hlib42.dll</a></P>
<P style="TEXT-ALIGN: center"> </P>
<P style="TEXT-ALIGN: center"><a href='javascript:fileFilterViewer("http://cfile268.uf.daum.net/attach/203E344B5141CACF128B8C", "/cfile268/20/3E344B5141CACF128B8C", "0_HMS용 DSS입력양식(5분용).xls", "grpid%3Dt62Z%26fldid%3DCxqT%26dataid%3D842%26fileid%3D8%26regdt%3D20130314220537&url=http%3A%2F%2Fcfile268.uf.daum.net%2Fattach%2F203E344B5141CACF128B8C")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_xls_s.gif?rv=1.0.1" border="0" alt="첨부파일" class="vam"/> 0_HMS용 DSS입력양식(5분용).xls</a></P>
<P style="TEXT-ALIGN: center"></P>
<!-- -->
]]>
카페 게시글
질의 & 답변 (VBA)
엑셀에서 추가기능으로 추가된 메뉴를 sheets별도 돌릴 수 있을까요?
다음검색
첫댓글 Sub 자동입력()
'
' 입력 매크로 ctrl+m
'
Dim i As Integer
Dim st As String
For i = 5 To 1440 Step 5
st = Format(i)
Sheets(st).Select
Range("A1:C237").Select
With Application
.SendKeys ("%{x}")
.SendKeys ("%{s}")
.SendKeys ("%{r}")
.SendKeys "{Enter}"
.SendKeys "{Enter}"
End With
PauseTime = 1
Next
End Sub
이런생각으로 시작했는데 간단하게 안되는건가요?