I'm showing an excel file in a WebBrowser control on my form, but it doesn't show any toolbars. The customers wants the ability to make changes in the control and save them, hence the need to show the standard toolbars.
I've tried many different things including:
For Each cb As CommandBar In xlApp.CommandBars
cb.Visible = True
Next
'and
[Code]....
how I can get toolbars to show in the WebBrowser control?
what I want to achive is to have a centralized control of my data-forms from my toolbars (toolstrip), like navigating (PREV-NEXT), SAVE, DELETE, CANCLE and so on instead of having it in every form. it worked beautifully in my VB6 projects. below are the codes i did in .NET and it don't seem to work and I guessed it about my use of late binding in .NET.
This is what I have done that don't seem to work. In my project module, frm is declared Public as form object Public frm as system.windows.form().form
Im my childforms i want as soon as the forms are load, activated or have focus, should instantiate or create the form object in my frm. [Code] while in my menu or main form (parent form) with toolstrip buttons, this actually where all individual forms are called. [Code]
and it's flagging an error there:
frm.CloseForm is not a member of System.Windows.Forms().Form
and I must say here that I declared all the subs im calling in the childforms PUBLIC, and of-course frm being a late binding type may not have all the Public Method on it.
I wish to add a toolbar that looks like the one in windows explorer to my windows application in my visual basic 2005 application. Although I have currently deployed the default 'toolstrip' that is avilable among the controls but I don't understand how should i change the appearance of the toolstrip from office 2003 to the one present in windows explorer.Please provide a solution to the above problem.
View 4 RepliesI want to use icon files that reside outside of Excel on my Excel toolbars for macro buttons I have created (I don't want to use the customizing function within Excel, but rather, icons that have already been created). In some prior life, I have done this and have some neat-looking icons on the Excel that resides on my desktop. I don't know how I did it, but I know it's doable!
Alternatively, if someone could tell me how to copy over the customized Excel setup, that would work too. I tried copying over my "Book 1" file, but got a message about macro security and digital certificates.
How would i set a toolbar on a form much like the ones a word document?
View 3 RepliesI'm trying to show a Windows Form from a DLL file - it's added to the application's refrences But I can't call the Windows Form from the DLL, I tried to make a function that shows the form but when I try to call that function in my application it says: Reference to a non-shared member requires an object reference How can I show the form? I'm tried to use this method: (it's in the DLL's form)
Public Sub Open()
Dim Instance As Windows.Forms.Control = Me
Instance.Show()
End Sub
I have a autocomplete dropdownlist(ddl) in my app. When ever I click on the ddl and start typing to find the item I am looking for in the ddl. The ddl is expanded to show all the orders when typing. After I press the enter key to go out and get the order information for that order the Order number in the ddl is missing but here is the weird part. When I don't have the ddl expanded but still have focus on the ddl. When I find the order I need and press enter. The order number is showing in the ddl as the selected one after it has loaded up the order information.
View 6 RepliesI have the code which checks if there is a selected tab
Private Function GetBrowser() As WebBrowser
If TabControl1.SelectedTab IsNot Nothing Then
For Each c As Control In TabControl1.SelectedTab.Controls
If TypeOf (c) Is WebBrowser Then
Return c
[Code]...
I am trying to show my excel chart in visual basic listbox and it does not work. I have added the reference of microsoft.office.interop.excel in my code i have put the range of column "A" and i do not know how to change the range to where the chart is in the excel.
Here is my code!
[Code]....
I have attached the excel file screen shot if that can help in any way...So basically When i click on the button in VB than it should show me the excel chart. My code just shows me the column "A" which shows me the "data" column only from the excel file.
My Windows Forms app collects data from user input and mathematical calculation and outputs a set of results to an Excel spreadsheet.
Here's my code (for convenience, I've included only the code that seems relevant to the problem):
Dim exc As New Excel.Application
Dim book As Excel.Workbook
Dim sheet As Excel.Worksheet
[Code]....
I am trying to create double and number format cells in excel using NPOI library. I used code like Dim cell As HSSFCell = row.CreateCell(j) cell.SetCellValue(Double.Parse(dr(col).ToString)) In excel numbers are aligning right but when I check format it is showing in "General" then I changed my code to like below
[Code]...
a program and i need to have a button put a file into a folder, i know how the button works i already have it doing some other stuff. i just don't know the code to copy and past it to a folder.
View 1 RepliesWhere in VS2010 can I find a horizontal separator control, as can be found in Outlook settings (screenshots below)?[URL]..
View 3 RepliesWhatever project I'm making, I always encounter a problem with a Windows Forms Timer control, I guess I just make a little mistake somewhere... So I thought I'd post it here and hopefully someone here can explain what I'm doing wrong.
[Code]....
I may be the only person still automating excel this way and I am looking at doing it in ways that better handle COM objects and such, but for now I just importMicrosoft.Office.Interop.Excel and go for it. Something that gave me a lot of grief at first was hanging excel.exe processes, but there are tons of resources online for fixing that. At this point I am pretty confident in my abilities to handle it.One thing I did notice and was wondering about is how does closing a windows forms application interact with excel.exe running in the background and likely more specifically the garbage collector. I have written quite a few excel automation projects and noticed that after I run my program .exe and it has completed there is an excel.exe process that hangs on until I close the pop up window from the windows forms application. Why is that happening?
View 1 Repliesis it possible to add images to listbox control of windows forms..
if I do it anyhow using items.add method one item at a time then how to add items valuemember to items ..
I need ability to display content in Hex View, like this from WinHex
Offset 0 1 2 3 4 5 6 7 8 9 A B C D E F
00000000 EF BB BF 0D 0A 4D 69 63 72 6F 73 6F 66 74 20 56 ..Microsoft V
00000010 69 73 75 61 6C 20 53 74 75 64 69 6F 20 53 6F 6C isual Studio Sol
[code]....
I have to design a custom "log grid" control to use in another of my projects.Up front, I am new to vb.net 2008. I have used VB6 for years and I am trying to learn how to resove the differences as I go. But I need help.
This log grid contains 96 columns and 4 rows.I tried using the TableLayoutPanel and a Panel per cell but found the control to slow to paint. That's 384 discreet controls.I am now trying a usercontrol with a panel and GDI+ to create the grid. I've created a collection for the columns and a collection for the rows. So far so good. My mouse clicks raise the correct events per cell.
I now need to indicate which column the mouse is over. This is the problem. The column must be highlighted by a vertical bar from the top of the column to the bottom. It must also be transparent. I need to see the gridlines under the highlight. I've tried using region using the following code. (myRegion is declared Private MyRegion as Region at module level for persistance)
[Code]...
I can't get this to work get a funny icon in the top left corner of the are where the user control is suppose to appear, here is my html markup.[code]
View 4 RepliesI have several pictureboxes in my form with names as "stop0", "stop1", "stop2" ... upto a the number of checked items in my checklistbox. My aim is to use a for-next function so that the program should use for all these pictureboxes a specific image. here is the code I made so far:
Dim a As String = selectedbutton.Replace(" ", "_") & "_"
Dim c As String = ""
For n = 0 To chklstStops.CheckedItems.Count
[Code]......
I have a main form that contains a vertical SplitContainer.Inside the SplitContainer's left panel, I have a TreeView control.Inside the SplitContainer's right panel, I have another SplitContainer (this one horizontal). This container is fixed, with headings above the split and a Panel control below it.I dynamically load my own user controls into the Panel control whenever the tree view changes.
Most of the user controls that are dynamically loaded have a DataGridView that should receive focus when the control is initialized. Sometimes this grid is on the UserControl surface directly; sometimes it's in a GroupBox; etc.What is the best way to programmatically set focus on the DataGridView control, given that it may placed within a variable number of control containers? I've tried the obvious - .Select, .Focus, .ActiveControl, etc. None of these seem to work - the TreeView item that I selected is still highlighted, and even though a record is selected in the DataGridView, it doesn't have focus.
Here's the code where I add the user control within the main form:
Private Sub LoadRightPanel(ByVal section As String, ByVal moduleName As String)
Heading.Text = String.Empty
SuspendLayout()
RightPanel.Controls.Clear()
[code]....
I've been working for several days on a GUI where a lot of individual data elements need to be displayed side-by-side and wrap to the next line when they overflow; the goal is to not have to explicitly design an individual 'row' element with a set number of elements for this purpose. The FlowLayoutPanel seems great, except...
I need to be able to determine how many elements are on each line (dividing the width of the control by a predetermined value indicating width of child controls does not work); I need to be able to determine how many elements will be on each line (I may need to put 4 elements on line 1, then auto-wrap, then 8 elements on line 2, then auto-wrap, then as many elements as can fit on line 3 before autowrap, then 16 elements on line 4, etc); and finally I'd really like to put a 'line header' at the left margin and a 'line footer' at the right margin, where for example the line header contains a line number and the line footer contains the number of elements on that line.
In my project i added a User Control so that i can reuse in different Windows forms.I designed and coded the UserControl1 according to my need and now i want to use it in Form2 but i cant understand how to do it?
View 2 RepliesThe leave event fires twice in this example. Tab order for the form controls is set to combobox1, button1, button3 Private Sub ComboBox1_Leave(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.Leave
[Code]...
if I enter 'A' in the combobox1 then combobox1 leave event will fire twice any other entry is Ok since the next control to get focus is button2 (in the normal tab order).It seems that if I try to skip the next control (based on the tab order set for the form), the leave event fires twice.
I can't seem to find a way to use the IE9 rendering engine in the WebBrowser control, instead of the IE7 rendering engine, using Visual Studio 2010 and Windows Forms.
View 2 RepliesI am trying to read values from textbox controls and combobox controls on a form. Reading the values from textbox controls is working fine but I cannot read from the 3 combo boxes. Here is some simplified code of what I am trying to do.
[Code]....
I got an error that i cant convert string to System.Windows.Forms.Control and i was wondering how could i do it this is the code that contains error:
If ResultRichTextBox.Contains("Text") Then
I have a program that I am creating in a windows form to track information about computers that I build for each project I do. The way I have my form layout is two buttons on the top of the form(1 for adding a computer and the 2nd to remove a computer) I then have a Tab window where when I want to add a computer I use the "Add button" click event to create a new tab and add a user control "Computer" that I created that contains all of the default fields that I desire (i.e. serial numbers os type, product key etc.) The "Computer" user control also contains two buttons (1 for adding a PC Card and the 2nd to remove a PC Card) The PC Card is another user control that I have created that has all of the desired fields I require for PC Cards. I am able to add new computers with no problem and name the tab
Dim b As New Computer
Dim x As String = Me.TabEquip.TabCount - 2
Dim tab As New TabPage("Computer" + x)
[code].....
I am using Visual Basic Express 2005. I am opening the startup form of my application in "Maximized" view. In the form designer, I am setting the anchor properties of the various controls that I have on the form so that they are located where I want them to be located when the Form loads.
I was wondering, if there was a way such that the form in my designer would be of the same size as the Maximized form? As of now I am dragging and resizing the edges of the Form in the Designer view to make it bigger..
In C# Windows Forms, a user control's InitializeComponent is called from the form's/control's constructor. When I create same scenario in VB.NET I don't get a constructor, and I can't locate a place where InitializeComponent is called.I need to call my code between InitializeComponent and when the control's Load event is raised, preferably still in the control's constructor. How do I do this in VB.NET?
View 2 Replies