Ricardo da Paz ricdeez

ricdeez / ruby_MSschedule_generator

Created August 4, 2014 09:54

Generate MSProject Schedule from YAML

	#!/usr/bin/ruby
	%w( yaml pp win32ole ).each { \|dep\| require dep }

	class WIN32OLE
	def self.get_project
	begin
	connect('MSProject.Application')
	rescue WIN32OLERuntimeError => e
	new('MSProject.Application')
	end

ricdeez / AddsIDtoTableInSelection.vba

Created September 20, 2015 21:02

Adds IDs to MS Word Table in Selection

	Public Sub test()

	Dim tbl As Word.Table
	Dim c As Long
	Dim n As Long

	Set tbl = Word.Selection.Tables(1)

	c = 0
	For n = 1 To tbl.Rows.Count

ricdeez / VBA Copy Selection

Created July 19, 2016 07:49


	Public Sub DoIt()
	Dim rge As Excel.Range
	Dim my_row As Long

	Set rge = Application.Selection
	rge.Copy


	my_row = rge.Row

ricdeez / VBA Add Hyperlinks

Created July 25, 2016 03:42

	Sub Macro3()

	Dim sht As Excel.Worksheet
	Dim rge As Excel.Range
	Dim switch As String

	Set sht = Excel.Worksheets("SUMMARY")

	lastRow = sht.Range("B65536").End(xlUp).Row

ricdeez / gist:fff680ba40ae21693d2f4b2cfbf519dc

Created October 11, 2016 03:18

Center Widget in tkinter

http://effbot.org/tkinterbook/place.htm

ricdeez / pad.py

Created December 7, 2016 08:13

Padding pipe delimited text for inclusion in an ascii file nicelly formatted