Saving A Selection Of Excel And Counting How Many Times It I

[Morrissey]

Hi Everyone I've Got Yet Another Problem Which I Need Your Help With I Need The Macro Code For

When I Click A Button I Would Like Excel To

1. Copy And Paste A Selection I have Made (It's Called 'export1') On To Another Template I Have Made (C:IFSInvoice Template.Xlt)

2. Save That

3. When That Button Is Pressed Record How Many Times It Is Done (I Want 250 Times) And Have A Message Coming Up.

 

[Dinictus]

can`t you just fill a cell with value 0 and include a function to add 1 to that value everytime the export occurs.

Secondly include an evaluation of the cell value.When>250 let a msgbox appear.

?

 

[Morrissey]

Sorry I need the whole code how to do this I have no knowledge of VB

 

[Dinictus]

mm, welll. finding out is part of the sport In my oppinion.

 

[Morrissey]

yes well can someone who is willing to help me and doesn't believe in sport of learning VBA please help

 

[wichien]

I will suggest only the 3rd question
1. put this before doing Process
StartTime = Timer
2. Put This After doing Process
EndTime = Timer
3. put This in Module

Dim StartTime, EndTime As Date
MsgBox "Finish ! Using Time " & Format(EndTime - StartTime, "0") & " Second", vbExclamation + vbOKOnly, "Remark"

 

[Dinictus]

Run something like this in the same sub as your export macro.

Worksheets("sheet1").Range("a10").Value = a10 + 1

And then something like this: in another sub:

if a10.value >250 then
MsgBox "big boy, you did it 250 times!", vbExclamation, "big boy"
end if
This message was edited by Dinictus on 2002-03-21 03:39

 

[Audiojoe]

If only you could get a wav. file to say that instead of a message box eh? You'd be the envy of the office
This message was edited by Audiojoe on 2002-03-21 03:17

 

[Dinictus]

Tell `em audiojoe,

Tell `em how you do that!

 

[Audiojoe]

http://www.mrexcel.com/board/viewtopic.php?topic=2738&forum=2

Take that and party!