Recent Posts

Cajun Dictionary

Westwego

• Guests: 32
• Hidden: 0
• Users: 0

There aren't any users online.

31

MS Excel / Copy from one workbook and paste to another. (VBA)

« Last post by WestwegoMan on Jan 23, 2015, 5:04 PM »

To copy from one workbook and paste to another:

Code: [Select]

Windows("workbook1.xls").Activate
Sheets("Sheet4").Select
Range("A1:D10").Select
Selection.Copy
Windows("workbook2.xls").Activate
Sheets("Sheet4").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _


32

MS Excel / Protect and unprotect a sheet. (VBA)

« Last post by WestwegoMan on Jan 23, 2015, 5:03 PM »

To protect using a macro:

Code: [Select]

Worksheets("Sheet1").Protect Password:=""Note: you can put a password in the parentheses.

To unprotect:

Code: [Select]

Worksheets("Sheet1").Unprotect Password:=""Note: you can put a password in the parentheses.

33

MS Excel / Save and close a workbook. (VBA)

« Last post by WestwegoMan on Jan 23, 2015, 5:02 PM »

Code: [Select]

Sub CloseExcel()
ActiveWorkbook.Save
Application.Quit
End Sub

34

MS Excel / Mark current date and time in a specific cell. (VBA)

« Last post by WestwegoMan on Jan 23, 2015, 5:01 PM »

This macro will mark the current time from the PC into cell "I2"

Code: [Select]

Workbooks("Test.xls").Sheets("Main").Cells(2, "I") = Date & "  " & Time

35

My Blog / Moreauville to ban Pits and Rots

« Last post by WestwegoMan on Jan 23, 2015, 12:55 AM »

Note: Originally posted on old site Nov. 24, 2014

My email in response to the ordinance to ban pitbulls and rottweilers in the Village of Moreauville, La.

To Alderman Penn Lemoine and anyone else it may concern,

While I may not live in the village of Moreauville, La, I think it is quite absurd to place in effect, an ordinance to ban these breeds. While I also do not own, and may never own one of the said breeds, it is absolutely absurd to take away the rights of your residents by placing this ban into effect.

You and your colleagues need to come to your senses. There is one particular dog in your town (Zeus) that persuades me to write this email. Could you step down off your throne for a minute and think of the trauma this will cause the child that owns this dog. Your enactment of this ordinance, in my opinion, might as well be considered an abuse of power and title you all as a bully. While you may have the right and be able to legally pass this ordinance, it doesn’t mean that you have to. You and your colleagues that voted to pass this should be run out of your village.

Your ordinance states anyone with a pit bull or rottweiler must get rid of it by Dec. 1 or the village will take it for “disposition.” More absurdity!! I think each and every one of you involved with this should be ashamed of yourselves.

The residents that complain of these breeds are just as guilty as you. While I don’t really believe there is a problem with these breeds roaming the streets of your village, wouldn’t a leash ordinance be a smarter idea. These are tax paying residents and you are taking away their rights to satisfy a few other residents. Why? Is this the way you assure votes when re-election comes around?

Update: On 11/25/14 the village of Moreauville reversed it’s decision on the ban. Read about the update here.