Hi there,

Please consider registering for an account. Registration is free, only takes a minute and will allow you to access members only boards. If you already have an account with us, then click here to log in.

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - WestwegoMan

Pages: 1 2 [3]
MS Excel / Macro to open specific workbook.
« on: Jan 23, 2015, 5:05 PM »
To open a specific workbook using a macro:

Code: [Select]
Workbooks.Open ("C:\path to book\test.xls")

MS Excel / Copy from one workbook and paste to another. (VBA)
« on: Jan 23, 2015, 5:04 PM »
To copy from one workbook and paste to another:

Code: [Select]
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _

MS Excel / Protect and unprotect a sheet. (VBA)
« 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.

MS Excel / Save and close a workbook. (VBA)
« on: Jan 23, 2015, 5:02 PM »
Code: [Select]
Sub CloseExcel()
End Sub

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

My Blog / Moreauville to ban Pits and Rots
« 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.

Pages: 1 2 [3]

The postings on this site are my own and do not necessarily reflect the views of Jefferson Parish,

fellow employees, members of the public, suppliers or people working on behalf of the parish.

SimplePortal 2.3.6 © 2008-2014, SimplePortal