Programming

Error: Microsoft ODBC Driver Manager Data Source name not found
I was just watching the video here: http://www.youtube.com/rstcomputer#p/u/9/T1AyYM6QxnI Trying to follow the example but some of the text is fuzzy. I typed the following VBA into Excel: Sub Rectangle1_Click() Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset 'Drive code for Access con.Connect... 27 Feb 2010 16:35

Shift Roster on Excel, pls help
Who can help me to auto generate roster on excel, it is very complicate...pls help... 1) bill date (5, 7, 11, 14, 17, 21, 25 and end of month) need to 6 day 3 night, but if Saturday, Sunday or Public Holiday need to 2 day 2 night 2) non bill date only need to 6 day 2 night staff 3) non bill date if Saturday, Su... 16 Mar 2010 12:33

Import selected worksheet from another workbook
I'm stuck on the best way to prompt the user to open another workbook and select a worksheet to be copied into the file containing the macro. Ideally, I would hardcode the name of the target worksheet, leaving the user to just locate the right file. However, I need to include something that will also allow th... 27 Feb 2010 11:02

VBA forms in excel
I use forms for data input in excel. I have a for named test. I have 10 fields on the form named t1 thru t10. Currently when I open the form I get data from a sheet and put it in the field names using: test.t1.value=sheetname.range("H8"). using this method I have to create 10 lines of code to populate the te... 27 Feb 2010 09:55

Filter Column
Hi Friends, I want to filter data columnwise not row wise. eg. Stationey Purchased List Item Jan Feb March April May June Pen y y y y Pencil y y y Scale ... 27 Feb 2010 07:44

Object Heirarchy Chart
Is there a way thru which i can get Excel object & collection heirarchy. ... 27 Feb 2010 12:09

Right Click - Disable item
I put a "PasteValue" item on the right click which has a macro assigned to it. It works fine but is always enabled. But Excel knows when to enable or not the regular "Paste" item on the right click. How do work that same functionality so I will know to tell excel to have the PasteValue item I added to the ri... 27 Feb 2010 07:44

Copy Values From Wbk1, Outlook Them To Another PC, Paste Them Into Wbk2
WBK1 (shared) has a routine in it which opens WBK2, copies the value of WBK1-E3, pastes it into Next empty row col A-WBK2, goes back to WBK1, copies the value of WBK1-B2, pastes it into Next empty row col B- WBK2, etc, for 11 values – so that WBK2 ends up with a new row of 11 cell-values from WBK1. The routine the... 26 Feb 2010 20:55

Queries created by MS Query not in QueryTables collection
On my spreadsheet I have created a table using an MS Query query, creating the table via File/Return data to Excel. This creates a table in my worksheet and a connection that shows up in my existing connections dialog. I have no problems refreshing the table using the refresh button. However, in VBA this table... 26 Feb 2010 18:42

Macros in PERSONAL.XLS
Excel 2003; Windows XP OS. I have a series of macros in my PERSONAL.XLS workbook that create a number of different pivot tables. I can't set up to run automatically, as I must create the datatables daily and they are a different size each day. The macros must be executed in the order they were created or the... 27 Feb 2010 08:49