$$Excel-Macros$$ SAN FRANCISCO EXCEL VBA PROGRAMMER/DEVELOPER

2013-01-15 Thread TJ
I am reaching out with the hopes of networking with VBA Excel programmers in the San Fran area.If you know of anyone looking for an opportunity to work on a project for a corporation please let me know. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

$$Excel-Macros$$ VBA EXCEL PROGRAMMER/DEVELOPER SAN FRANCISCO

2013-01-15 Thread TJ
I am looking to get in touch with someone in the San Francisco Bay area. I am seeking a San Francisco Excel VBA Guru, I have a few questions and would love for some one to message me. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use conc

$$Excel-Macros$$ Re: Format Shape Style Dialog in XL2007, 2010

2012-07-28 Thread TJ
Maybe this will help? http://peltiertech.com/WordPress/programming-excel-2007-2010-autoshapes-with-vba/ On Friday, July 20, 2012 3:56:22 PM UTC-5, debdarshan wrote: > hey! good work... > > i have a question > > How to display the > > *Format > Shape Style Gallery* > ** > **thro

$$Excel-Macros$$ Drawing Shapes with VBA

2012-07-28 Thread TJ
This is my first time to atempt anyting like this but would like to create a Vessel Calendar that will take a set of values from a table and then draw pentagons on a worksheet to represent the vessels on a calendar. The end Calendar will look something like this, which we do manual now. Also a

$$Excel-Macros$$ Re: Join Sql statement in VB using ADODB

2012-06-23 Thread TJ
Sql & vbLf & "VV_VESSEL_VISIT.ETA, VV_VESSEL_VISIT.ETD from VV_VESSEL_VISIT" strSql = strSql & vbLf & "join" strSql = strSql & vbLf & "VESSEL on VV_VESSEL_VISIT.VESSEL_ID=VESSEL.ID" rs.Open strSql, cn Cells(6, 6).CopyFromRecordset rs End Sub On Fr

$$Excel-Macros$$ Join Sql statement in VB using ADODB

2012-06-22 Thread TJ
Hello, Super new to thsi world but trying to put something together that will execute a simple SQL statement against on of our Oracle Databases and return the results. The Code for the Macro is below but I am getting "Data Type is not Supported". Anyone help with that. Also, another questio