I'm trying to use the System.Windows.Forms.MonthCalendar control within a VSTO Excel workbook. I want the MonthCalendar to pop up when I click a button in the ribbon, but so far I can't get the control to display at all.
Private Sub DeliveryDateFromCalendarButton_Click(ByVal sender As System.Object, ByVal e As Microsoft.Office.Tools.Ribbon.RibbonControlEventArgs) Handles DeliveryDateFromCalendarButton.Click
[Code].....
Anyone know of a way to see if the Excel window of a VSTO project is active/in focus?
I'm looking for an equivalent of System.Windows.Window.IsActive.
I would like have a progress bar like Outlook 2007. when you click on a link in a message. you can see a progress bar between the ribbon menu and reading pane in outlook 2007.
Is it possible to have the same progress in Excel 2007?
I'm creating an Addin, specifically to MS Project 2007. This Addin create a toolbar with a button that will allow user to export his project to excel sheet in MS Excel 2003 or 2007. My problem is create workbook with worksheet. I already made toolbar and added the button. My button can open Excel Application but i can't add workbook and worksheet.
Code:
<script type="text/javascript">
<!--
Imports Microsoft.Office.Interop
[Code]....
I'm sorry if this is in the wrong forum or has already been asked, but I'm having a problem creating what should be a relatively simple code for an Excel Project. Essentially, the code is supposed to check if a certain column has Y in it and then copy that entire row onto another sheet and then move on to check the rest of the original sheet. This version of the code seems to do everything but actually populate the cells with the information. Every other attempt I've made has ended with "Application-Based or Object Based Errors". I've worked on this code for a few days now and I just can't seem to get it right. What am I doing wrong?
Here's the code:
Sub PopulateNewSheet()
i = 2
Do While Worksheets("Main List").Cells(i, 2).Value <> 0
[CODE].................
I wrote this little AddIn sample to show you a performance issue and how to avoid it?It is just a parse of an excel workbook and runned in the main excel process (0) and a random thread created by the timer.
Public Class ThisAddIn
Dim a As System.Windows.Threading.Dispatcher = System.Windows.Threading.Dispatcher.CurrentDispatcher()
Dim t As New Threading.Thread(New Threading.ParameterizedThreadStart(AddressOf threadTest))
Dim tm As New System.Timers.Timer(20000)
[code].....
I am trying to save a ListObject from a .NET 3.5 Excel 2007 VSTO Workbook to a new sheet (done) and save that new sheet to a new workbook (done) without that workbook requiring the VSTO customization file (!!!!!).
Has anyone had any luck with this? The only way I've had any success is just saving as a CSV file but that's not exactly acceptable in this case. I'd rather not save to a CSV just to copy back to a XLS file.
worksheet.SaveAs(saveDialog.FileName, Excel.XlFileFormat.xlOpenXMLWorkbook)
I'm using a background worker to in an Excel VSTO application to throw up a progress dialog box with a status bar and a cancel button to escape from long running calculations. It's working really well, except for one issue. I'd like to use a Modal Dialog, so that the UI behind the dialog gets locked up, instead of a Modeless Dialog. If I use .ShowDialog() instead of .Show(), everything is great until you hit the Cancel button on the form. Following things in the debugger, the cancellation happens, it just takes somewhere in range of 30 seconds. If I use .Show() on my form, then the cancellation occurs immediately as it should.
[Code]...
explain the use of "imports" at the top of each module. i am stumbling through development of an excel app in vsto and learning as i go.
in my project references i have added references and imported namespaces of everything that looks relevant to excel and office. am i then to add "imports" to the top of each module where relevant.
[code...]
before i added the imports microsoft.office.interop.excel i had no access to xldirection method. what other import namespaces(????) are needed and in what modules?
i have a couple of books that i am referring to, but none seem to start at the beginning and explain what this imports does / is for.
I should first mention that i'm somewhat of a newbie in VB, i come from C++ (not visual)I want to make a Calendar that i will be able to populate with schedule of people and projects.Each day will have several records of person , project, hours and next to each record i would like to put Edit and Delete buttons.
and eventually i will need to calculate what each person did and so on. What i'm asking is should i do it in VB, or MS Access, or Excel ? and explain why.Should i make my own control? if so can someone send me links for tutorial of how to make a control. I found project in MS Access for a Event Calendar but that doesn't ..
I have a chart in Excel that I'd like to use a subtitle on. There is no SubTitle Property on the chart object, so I looked in the Excel User interface and found that you can only create a sub-title by using a text box. The text box looks like its associated with the chart, not the worksheet, so how would I access that text box from code?
View 1 Repliesusing the calendar from the webfor tools, NOT CALENDAR EXTENDER, and my question is, is there a way to add text to a specific day of the calendar, for example, that i want to click on the number where its shows 29 of the month december, then it shows me a texbox or anything that takes data from my, and i type anything in there, like an event or something, then i click on a button to save my entry, and next time i visit my page i see that day that i clicked on changed its color and shows my text when i hoover the mouse on top of it,
View 7 RepliesHow we can create a form with border like calendar border. I changed ControlBox to False and Text to vbnullstring. but only when FormBorderStyle is Sizable or SizableToolWindow form border apears. This form is sizable. Is there any way to create forms with this border but not sizable? I want to create form like this:[URL]
View 6 RepliesMy mailbox regularly gets emails from people wanting to promote their events. Usually the subject line looks like this:
fwd: come to *TMC* meeting this weekend, <5/19/2012 @ 1300 >
I need a script to read the date, then make an appointment on my outlook calendar, using that date, time and term (TMC) as the meeting title. So it should make an appointment on 5/19/2012 at 1pm, called "TMC meeting"All appointments are 2 hours by default.I used The identifiers "*" and "<>" as an example, and can be changed to be whatever, what is important is that the meeting gets on my calendar with the correct title.
im trying to create a .dll called PDTKey.dll (for example) that will hold all of my applications Product Keys..and when the user inserts a Product key into the main application..it searchs in PDTKey.dll to see if the Poduct key specified is there..
View 13 RepliesI'm developing a finance software and I want the user to enter a bill and pick the due date via month calendar. I getting it to work was the easy part, but now I only want one month calendar, for each time a user enters in a bill and picks a date.every time the user goes to pick a due date I have to call one of the several I have on screen.Here is my code that I have so far:Add due date button:
Me
The month calender:
Me
.TxtDueDate3.Text = MonthCalendar3.SelectionRange.Start.Date.ToShortDateString()Me.TxtDueDate3.Text
= MonthCalendar3.SelectionRange.End.Date.ToShortDateString()[code].....
I have a pretty large project built in vb.net under VS 2008. This project is heavy using SQL.
There is one part of the project, that I need to make a smaller project. So I am taking 6 forms out of 23 and adding them into this new project. Instead of adding the data set, I built a new one. With a different name. But it's connect to the same database.
First of all, is this a good way to make a sub-project, or is there a better way.
Secondly, I am running into a problem where my table adapters are not members of dataset. I get this error in the design code. I know it's not a good idea to manually change this code.
create a COM dll in Visual Basic. [URL]I now want to use this dll in a C++ project. I used OLE/COM Viewer to create an .idl file as is described in the second half this tutorial.[URL]I compiled the .idl with the midl compiler and included the .h file that was created in my c++ project.Here is my Visual Basic Code
<ComClass(MyComClass.ClassId, MyComClass.InterfaceId, MyComClass.EventsId)> _
Public Class MyComClass
#Region "COM GUIDs"
[code]....
I receive the following errors when I compile my c++ project
error LNK2001: unresolved external symbol _CLSID_MyComClass
error LNK2001: unresolved external symbol IID_MyComClass
I've been assigned to start a new Logging Project from zero in VB.NET.The final exit of the main project is information organized in paragraphs like this:
[code]...
Every paragraph correspond to a database connection. Every connection is made with an entire diferent database.i need my logging project to save everything the user does, so the logging exit would be like the system exit but with exceptions and other important information like this: Paragraph's title 1 Paragraph's content 1.Paragraph's title 2 User wasn't able to see this information because an exception ocurred: System.WhateverException:couldn't connect to WCF.as you can see the exit is the same but i need to create a detail log because the information is delicate and the DBA needs to now wich user did what and what was the response of the system. Also i need it to be and independant project so i can re-use it in another projects. Seeing the final exit of both the main project and the logging project, what would you recommend me to use for logging in .NET?
i'm currently working on building a program that will take a MS Access database system produced by my company and create a VB.Net project with all the forms in it (obviously the code should be manually done, but to save time the forms and controls can be produced automatically).I have tried Googling and seem not to be able to find anything about this (which probably means I wasn't searching with the right keywords), I was wondering whether anyone knows any good resources on how to create the VB.Net project programmatically as I already know how to do all the access stuff.
View 1 RepliesI am building an error log in a VB project. Is there a way to extract: 1) the name of the sub that a sub routine fails on? 2) what line of code a sub routine fails on? 3) what other items can I extract that are meaningful?
View 2 RepliesI'm studying visual basic and wanted to know where I place my code in the new project which looks like this below:
Public
Class Form1
Private
Sub Form1_Load(ByVal sender
[CODE]...
I'm creating variables.
I am working on a project that has some events already created and working. One of these events is called SelectedIndexChanged Event. I am using it for one of my Subs in my frmNewInspection Class, and I am trying to use it for a second Sub and it says that "Event SelectedIndexChanged Cannot Be Found".
The event is created here in a class called LabelComoBox
Private Sub tctlInspection_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles tctlInspection.SelectedIndexChanged
'MsgBox("Index: " & tctlInspection.SelectedIndex.ToString)
[Code] .....
So, I fired up my old laptop while my current app was running and tried to start a new project.
As soon as the form comes up, I see this instead of the normal windows form.
Code:
at Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str)
at Microsoft.Win32.RegistryKey.GetValueNames()
at Microsoft.VisualStudio.Shell.Design.WindowPaneProviderService.AppendWindowPanes(RegistryKey parentKey, ArrayList windowPanes)
[Code]...
no forms can be seen when creating a new project.. i am going to choose a window form but there are no forms to choose.
View 12 Repliesi am trying to create a simple program in vb.net but i cant start because there are no items found.. no forms are found am i missing some libraries or i installed it the wrong way?
View 22 Repliesi am a student of b-tech i want a ppt for my mini project i.e. web browser using vb.net .
View 4 Repliesi am trying to run the following code :
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
[code].....
I was having problems creating a DLL and using it in my Excel application. Here's what I've found which has worked for me immensely: [URL]
View 1 RepliesGiven the following code and link to SkyDrive VS2010 project, how would I create this vb.net project and access it in my c# application?
//the following c# project reference to function in vb.net is not working
string retval = ConvertUTF8_toASCII.UTF8_toASCII(stirngToConvert);
