Thanks Sbarro79 for the help but did not work for me. I followed what the link says and installed the mscomct2.ocx /.inf to my system32 directory and back to Excel in the Tools / references I dont see anything similar to Microsoft MonthView Control 6 (SP6) or similar. Date and Time Picker & Monthview controls are not included as a standard since Excel 2010 (additionally there are some known issues). So the additional controls are buggy (downloadstep by stepMicrosoft Date and Time Picker Control 6.0 (SP6) Microsoft MonthView Control 6.0 (SP6).

Ed has three computers at work. One has Excel 2010 with the Date Picker tool but the other two, one with Excel 2010 and one with Excel 2013, do not have this tool available. He wonders how he can load this tool into Excel 2010 and Excel 2013.

According to reports from Microsoft, the traditional date picker tool (called MSCAL.OCX) was shipped with Office 2007, but is not included in later versions of Office. In Office 2010 they have replaced the date picker with an updated version in the Active-X library, called MSCOMCT2.OCX.

You can tell if you already have the new date picker installed by following these steps:

1. Display the Developer tab of the ribbon.
2. Click the Insert tool. Excel displays a palette of tools you can insert in your worksheet.
3. In the ActiveX Controls section of the palette, click the More Controls option. (It is the very bottom-right tool.) Excel displays the More Controls dialog box.
4. Scroll through the dialog box until you find the Microsoft Date and Time Picker tool. Select it.
5. Click OK.

If the tool doesn't show up in the More Controls dialog box, then it has not been installed on your system. If you are using a 64-bit version of Office, then you won't be able to install the control. The reason is because MSCOMCT2.OCX works only on 32-bit systems. (In fact, none of the ActiveX controls work in 64-bit Office. When Microsoft actually comes out with versions of the controls that do work with 64-bit Office, they will likely have different names, a move sure to complicate the life of VBA programmers who rely on the controls.

If you are running a 32-bit version of Office, then you can try to copy the MSCOMCT2.OCX control from a like system and register it with Windows. (Before copying it, do a Windows search to see if the file is actually on your system. If it is, skip copying and just try to register it.)

Need for speed most wanted 2005 save game bully. How you register the control depends on the version of Windows you are using and whether you are using a 32-bit or 64-bit version of the operating system. (Don't confuse the number of bits in the operating system with the number of bits in your copy of Office; they are two different things.) A good overview of how to register the control can be found here:

Create Instance Of Microsoft Windows Journal

1) When using the command below, how can I determine what the 'XYZ' component could be. I see plenty of examples of it being used to start a MS Word session or Powerpoint but I'd really like to see a definitive list.
At the moment, I'm not even sure what to type into Google that describes this part of the command's argument.
Set target = CreateObject('XYZ.Application')
2) I'm just a frightened noob on this site and I tried to follow the advice on bumping my previous post on this subject, having altered my plea. All I got was a telling-off for being a double-poster and my old old thread sat where it was despite my 'Bump' command. Do you have to have at least one reply before your thread moves?

Missing Microsoft Forms 2.0 Object Library

i'm using a user form and i have the microsoft forms 2.0 Object Library checked. i have sent to another user, and i can't compile, when i took at this vba tools reference, microsoft forms 2.0 Object Library checked is missing (and not available in the drop down)..?

Excel 2010 :: 32bit - Microsoft Date And Time Picker Control 6.0 Missing

I am trying to add a calendar picker to Excel 2010. Everything I read online says that it is possible, you just need to use the ActiveX control 'Microsoft Date and Time Picker Control 6.0', and that it should be listed under Developer Tab -> Insert -> More Controls ->.. But it's not listed.
I also tried downloading the Microsoft Windows Common Controls-2 6.0, but when I tried to add it to Excel using 'Register Custom..', it says 'Cannot register this control'.
Why this control is missing? and I can't add it?

Excel 2010 :: Microsoft Date And Time Picker Control Not Appearing On Controls List

I was trying to use this guide to add a date picker in:
microsoft-monthview-control-6-0-excel-2007-missing.html
and noticed that the date picker does not appear in my active x controls list.
I am definitely on Excel 2010 so it should be there right?

Excel 2007 :: VBA - Additional Controls Dialog Box MISSING?

Additional Controls Dialog Box refuses to display
I have a problem trying to add additional controls to the Controls toolbox
The two methods I've tried
1. Right click on the controls toolbox , click Additional controls
2. Menu, Tools, Additional controls
Neither of the above produce a dialog box containing the list of additional controls to choose from.
I am running Excel 2007

Compare Two Columns, If Missing Insert Missing Data

I have two columns which i want to compare, they contain text data such as A123.
what I'd like is if its in column A and not in Column B then add to bottom of column A.
Once its in column A i can do the vlookup's to draw the other data, costs etc, over but don't know how to identify, and add, the missing codes to the list.

Controlling Non-Microsoft Applications With VBA

How can I control non-Microsoft applications using VBA? For example, how can I open a pdf file, print it and then close Acrobat Reader?

RTF- How To Convert A Microsoft Word

Does anyone know how to convert a Microsoft Word .RTF file into a Microsoft Excel file? I have tried everything I know and I have no success other than getting everything crammed into column A in excel.

Microsoft Rich Text Box Registration

I'm trying to insert a Microsoft Rich Text Box control (RICHTX32.OCX) on an Excel user form. It does it once, but on the second time Excel uninstalls it and posts a 'The subject is not trusted for the specified action.' My security level is low and I have checked the Trust all installed add-ins and templates.

To Convert Microsoft Word Data Into

I am currently working on a project, and basically I want to convert Microsoft word data into excel. Is there a way excel can read specific fields of data from word?
For example, search for a field called a particular name and a corresponding value amongst several data held within Microsoft word pages?

Build A List To Put Into Microsoft Access

I am trying to build a list to put into Microsoft access
Cell A1 has '
Cell B1 has 8W###
Cell C1 has ' Or
I want a formula that makes D1 '8W### Or '. edit: I got it =(A1) & (B1) & (C1)
I kept trying to use ' and it would work.

Returning Data From Microsoft Query

I have a query which is giving me some trouble when returning the data from ms query. The query was written in mysql query browser and returns 2 columns of data - a date and a number. MS Query correctly processes the query but when the data is returned to excel only the second column is returned. Here is the query:
SELECT
(SELECT
max(l.the_date)
FROM
nc_view_date_functions AS l
WHERE
l.week_of_year = d.week_of_year
AND l.yyyy = d.yyyy
) AS week_end_date,
count(r.consent_id) AS weekly_count
FROM
rg_resource_consents AS r
INNER JOIN nc_view_date_functions AS d
ON r.application_date = d.the_date
GROUP BY
d.yyyy, d.week_of_year;

Column Sequencing Using Microsoft Query?

I used the Get External Data function within Excel and the query returned the fields in alphabetical order. I went back into the query and rearranged the fields into a more logical order, but when refreshed the query continues to return the fields to Excel in the original alphabetical order.
Am I missing something, or do you only get one shot at the order of the fields being returned?

Microsoft Query Multiple Parameters

I would like to have set of data as Parameter if possible.
Example: In Microsoft Queries I have two data sets. In first one shows let's say Item Number, and second one I should have table with components of all Item numbers listed in first table.
So first table I set one Parameter (?) and i get like 8 results. I would like that second table takes those 8 results (sometimes more or less then 8) as parameter and shows data (components) for them.
If I set sign '?' I can only select one cell as parameter, is there any way I can select multiple cells as parameter and use it like SQL function IN ?
Code:
SELECT 1.ITMNR, 1.COMNR, 1.QTYPR
FROM 1.1.1 1
WHERE 1.ITMNR IN ?
And second table should look for results in first table under 1.COMNR and select it as 2.ITMNR
Code:
SELECT 2.ITMNR, 2.COMNR, 2.QTYPR
FROM 1.1.2 2
WHERE 2.ITMNR IN ?

Microsoft Visual Basic Error 400

My code here..
Sub ClearSheet()
Worksheets('Summary').Activate
If Range('CustInfo') = False Then
Range('ICompany, IPhone, IFax, IContact, ICell, IEmail, IAddress, IPOBox, ICity, IState, IZip').Select
Selection.ClearContents
Else
Range('IJobDescription').Select
Selection.ClearContents
End If
For I = 1 To 5
Range('Qty' & I).Select
Selection.ClearContents
Next
End Sub
keeps giving me an error 400. I have reinstalled xl just to see if it was related toan error I recieved earlier relating to VBE6.dll. This still works in another workbook but it doesn't work in this one. All I did was change the Range names and cleaned it up a bit.

Referencing Cells From Microsoft Query

I have a worksheet that pulls data from an ODBC datasource (import, External Data). The datasource is a SQL server 2005 database.
the query's sql is complex enough that it says it cannot be represented graphicly.
part of the WHERE clause fro my query specifies a date range for one of the date fields.
I am wondering if from within the SQL query in Microsoft Query I can reference the value of a cell. that way i coudl have the user enter his date range values in two specific cells.

How To Remove Microsoft Excel In Title Bar?

i don't like the '- Microsoft Excel' typed on the Title Bar. how would i be able to remove it?

Ssh rd rev04b jar iphone 4 64 bit. Download sshrdrev04b-iPhone4-RevA.jar from Mafia-download.com for all. File size 3694712 and last modified at 2014-10-13T01:36:28.000Z.

Microsoft Date And Time Picker

i have just discovered the Microsoft date and time picker. at the moment i have a text box on my userform into which i put the date.can i use code to transfer the date to the text box or do i use the date picker instead of the textbox. if i used the date picker what is the code for the date picker

Microsoft Date Picker And Applying To Database?

i built a form and in the date section i have a date picker and once i fill the form out i have a button that saves all the data on another sheet like a database, what do i need to do to make it were it adds the date to the database itll add all the other data but cant seem to figure out how to make the date display

Excel 2013 :: Delete Using Microsoft Query?

6 To The Power Of 0

Using Excel 2013. Is it possible to delete some records from Sheet1 if the records exist on Sheet2?
I tried several SQL variations in MSQuery but all come back with error messages.
I tried:
[Code]...

Returning Data From Microsoft Query To Excel?

I am trying to use queries I have been running in MS SQL Server Management Studio, to return data in Excel where it would display as pivot. Some queries I was able to use through Excel but few others are not returning anything.
I am doubting it has something to do with the query itself - but they are displaying results properly in MS Query, they are just not returning any data to Excel.

Changing Date Format In Microsoft Excel?

in the date fields excel only recognises some of them as date, so when I try to change the format of dates (mm/dd/yyyy to dd/mm/yyyy) it only changes some of them so I end up with some wrong dates.how I can make excel read them all as date?

Microsoft Excel Stopped Working Error

I have a Macro button in my Excel Spreadsheet, every time I close the spreadsheet it gives me this error 'Microsoft Excel Stopped Working' .
I have attached Spreadsheet to show example : Inventory List.xlsm‎

Microsoft Query - Return All Unless A Parameter Is Entered

I am querying a database in Microsoft Query and I have it set to pull in jobs that match a customers code in cell A1. I would like it so that if cell A1 is blank, it pulls in jobs for every customer.

Insert Microsoft Calculator Into Excel Sheet?

Can I insert the microsoft calculator into any excel sheet? I have it attached to my ribbon. But would find it much handier embedded into the sheet.

No Data Returned To Excel From Microsoft Query?

Im using a query to connect to a SQL server and return data into Excel. I can query and return the data in Microsoft Query editor but when I attempt to return the data to Excel in a table, it just says the name of the connection in cell A1. If I attempt to return it into a pivot table a get and 'Problems obtaining data' notification.

Microsoft Visual Basic :: Error In Loading DLL

Microsoft Monthview Control 6 0 Excel 2007 Missing Persons

i have a macro he was working good but now i got a box labeled 'Microsoft Visual Basic' saying 'Error in loading DLL' and the macro won't open. I can't figure out what I'm missing.

Macro: Open Workbook From Microsoft Project

I have discovered that I can write a macro in Microsoft project that opens Excel
ActivateMicrosoftApp(pjMicrosoftExcel)
but this call does not allow me to specify a file to open, it just opens an instance of Excel (or activates the open instance). What I ultimately want to do it to, from a Project macro, open a particular workbook and then execute a macro in that workbook.

Microsoft Query: Data Source .xls Files

Trying to work through tutorial on creating offline cube from an Excel file, A CompleteGuide to PivotTables: A Visual Approach, Cornell, ISBN 1-59059-432-0, pg 248. Steps I am taking:
1. Click on Data Menu
2. Import External Data
3. New Database Query
On Databases tab
4. Click on Excel Files*
5. Click on Browse Button
I migrate to the loction of the sample files I downloaded, but no files appear in the Browse Data Sources dialog window. Files of type drop down reveals only 'Data Sources' (w/o quotes). I browsed the folder with Windows Explorer. There are several Excel files in the folder as well as sample, .cub and .mdb files. I do have Excel 2007 installed on the PC as well, but working through the tutroail with Excel 2003.