I am creating an Excel Add-In using Visual Studio 2010. My intention was to add a context menu to a cell and perform some action on the selected cell or cells. Here is the code I have got as of now
[Code]...
I am creating an Excel Add-In using Visual Studio 2010. I would like to run some code when users clicks a combination of keys.Here is the code I have got
Public Class CC
Private Sub ThisAddIn_Startup() Handles Me.Startup
EnableShortCut()
End Sub
Sub A1()
[Code]...
The Add-In when installed shows an error on clicking the short cuts. It says the specific macro cannot be found.The code under the Sub EnableShortCut() works well when it is in an excel vba module. The same won't work when it is added to an Excel Add-In created with Visual Studio.
I 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.
I decided to to convert my excel macro in a exe file using visual studio 2010. In excel macro method find is present like this:
[Code]...
I have a blank form and when the use right clicks on the form, they get a context menu with any number of names in the menu. This changes depending on the situation. I can get the context menu to add/remove the list of names but when I click on one of the choices and it goes to my routine (from addhandler) I can't find the property that tells me what they clicked on...
[Code]...
how can I set custom context menu location in visual basic 2010:
View 1 RepliesI created a VB.Net program in Visual Studio 2010 Pro. Everything runs fine in debug mode on my developement machine. I'm using setup builder installation and cryptolicensing for the license.dll. I have checked the setup program and all the files are installed on the test pc as required. The program was developed on the 4.0 client Framework. The problem is when I install the program on the test computer it will not open or run. No indication of why no messages, nothing. Can anyone steer me where to begin to find out why this is happening.
View 3 Repliesam trying to store and retrieve data from a closed excel worksheet while in a form created in vba studio express 2008?
View 3 RepliesI have one tool which we developed on visual studio 2010. there are basically two parts of my project, one is UI part which i wrote in VB and algorithm part which is in C++ on back end. When we compile C++ part it creates a .dll which is used by my front end VB program.
Now my problem is little weird since i am compiling and deploying this tool on windows xp machine but some of the users are using windows 7 64 bit machines and after running the program for about 5-10 minutes, it crashes on windows 7 with following error
Not enough storage is available to process this command and when i view details of that error, i get the following description.
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ComponentModel.
************** Loaded Assemblies **************
mscorlib
[Code].....
i am completely clue less for this error since this program works fine on xp but doesn't work on windows 7.
I can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 RepliesI am trying to figure out how to add a theme to my excel worksheet before saving it. I have found this code to change the cell color but have yet to find anything to change to a pre-default excel table format (the Table style light 2 theme)
[Code]...
How can i just select all the cells and place that Table style light 2 onto them all using VB.net?
I am trying to delete more than one column in my excel sheet.
For Each lvi In ListView1.Items
If lvi.Checked = True Then
arrayLetters = lvi.SubItems(1).Text & ":" & lvi.SubItems(1).Text & "," & arrayLetters
[code]....
How do you view the code from a .exe application file that was created using Visual Studio?There are several applications of which codes I want to see to understand how the application was created to increase my understanding of VB.
View 4 Repliesim currently doing my special project in software development
[Code]...
I create some files in VB.net from a master file but when I try to open the newly created file, Excel starts and nothing is displayed, you can see the outline of Excel and it's menus and nothing else. You can't do anything with excel except close the entire application. [Code] It is upon trying to re-open where it fails, outside of the VBE. I have not had a problem like this using VB6 before, so I am assuming I am doing or not doing something.
View 3 RepliesI created a vb.net RTD server as explained in the link below in vb 2008 express. [URL]. But this link gives no indication of how to register the dll on another machine. I tried to register the dll using regasm, but it still doesn't work. (I keep getting #N/A s).
View 1 RepliesI am trying to retrieve an excel chart (created out of .net), which i have earlier copied to the clipboard.As long as I work with type bitmap I can copy/retrieve it as follows:
Code:' copy to clipboard (in .net)charts.CopyPicture(Office.XlPictureAppearance.xlScreen, Office.XlCopyPictureFormat.xlBitmap)
' retrieve it againimgImage=Clipboard.GetDataObject.GetData(DataFormats.Bitmap)
Unfortunately, the quality of the bitmap is rather bad, thus I would like to copy it as a Metafile. The copying works, but the retrieving will only return Nothing.
Code:' copy to clipboard (in .net)charts.CopyPicture(Office.XlPictureAppearance.xlScreen, Office.XlCopyPictureFormat.xlPicture)
' retrieve it againimgImage=Clipboard.GetDataObject.GetData(DataFormats.MetaFilePict) ' returns Nothing!
I have checked if the object is available in the clipboard using GetDataPresent and it shows that there is a metafile available. Still, it returns nothing.On a side note: Is there a way to avoid using the clipboard? After all I am creating the charts in .NET and I need them there as well. Could I access the image of the chartobject directly?
The idea is that I have certain values stored in textboxes/listboxes and thus can I store the information in a spread sheet. And if I change the value in the spreadsheet can it also change the value in the application? I had one idea which was to make both store data in a txt file and read from that, but I'm not quite sure how to do that either.
View 1 RepliesI have 2 blocks of code, if someone could help me put them together I would get the functionality I am looking for. The first block of code downloads a gridview to excel using the download dialog I am looking for:
Public Overloads Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
' Verifies that the control is rendered
End Sub
Private Sub ExportToExcel(ByVal filename As String, ByVal gv As GridView, ByVal numOfCol As Integer)
Response.Clear()
[Code]...
I have code for a user created button that gets placed on a custom ribbon control, within a custom drop-down menu.[code]...
View 2 Replieshere is a copy of my current code. Am trying to open an existing Excel spreadsheet then retrieve the old balance data refigure the new balance and store new data into the spreadsheet. Am I on the right tracK, or way out in left field?
Private
oWB.SaveAs(
"Checkbook.xlsx") Nothing
oWB.Close()
[Code].....
[Code]...
overcome the ActiveX error Do I need to add a referrence? If not "Registered" how to do it?
I have a program that creates excel and word documents from another main Excel workbook. Essentially it opens excel checks data, posts data to appropriate forms. It then saves them as (number from main excel) & date/time stamp and corresponding extension. I want to be able to list the created documents according to the number from the main excel workbook.
[Code]...
In the following code I open several Excel workbooks from within the VS 2010 .IDE. I want to Try the open workbook code, then Catch exceptions using a dialogbox as a form created programmatically at run-time. The exception handler works, but the dialog box does not display in front of the workbook. So, the user can't respond to the modal form. If at that point the Excel workbook is shrunk manually to expose the dialogBox which is then dismissed, Excel pops up a "Save Changes?" alert and the VB code does not resume the Sub at the Me.Focus() line
When the workbook Is open Excel is the active application. I think this is why the dialog box is not in front, and I don't know how to solve the problem programmatically.[code]...
I recently installed WSP Builder on a machine with Visual Studio 2008 already installed.Quite expectedly, the WSP Builder sub-menu appeared (and still appears) under the Visual Studio 2008 Tools menu.Having then installed Visual Studio 2010 Professional and installed WSP Builder a second time, I can not seem to find the WSP Builder sub-menu anywhere under any of the Visual Studio 2010 menus.Can anyone throw some light on this "missing menu" problem?
View 2 RepliesI am populating a listbox with a large list. The user then has the option of choosing multiple items from this list. I then want to perfrom a few actions on only the selected items.I cant figure out how to only perform the actions on only the highlighted selections.
'I have tried all combinations of
For each Listbx.SelectedItems.ToString in ListBx.Items.ToString
For each Listbx.SelectedItem in Listbx.Items
'etc, etc
''Performing actions here but it is still doing it with all entries
Next
Is it possible to create a custom start menu shortcut link?
The only possibilities I see in the setup project are shortcuts to folders or primary output.
Update:
What I ended up doing is creating a custom action on commit that dynamically creates the link using Windows Scripting Host. Then on uninstall, removing the link.
I have created a SELECT FROM WHERE query to perform a search here is my code:
SELECT EmployeeID, DepartmentID, Forename, Surname, Role, Email, Telephone, Extension, Mobile, Photo FROM Employees
WHERE (Forename = ? or ? = '') and (Surname = ? or ? = '') and (Role = ? or ? = '')
I have then put the folllowing code to rung the query within my form:
Me.EmployeesTableAdapter.FillByName(Me.myDataSet.Employees, Me.ForenameTextBox.Text, Me.ForenameTextBox.Text, Me.SurnameTextBox.Text, Me.SurnameTextBox.Text, Me.RoleTextBox.Text, Me.RoleTextBox.Text)
When i search by forename or surname it works fine but when i search by role i get this error..oledbException occured No value given for one or more required parameters.
Is it possible to be present a context menu when an item, any item, is right clicked in the ListView control? - If so, how?
View 5 RepliesHow does one get the context menu to appear when right clicking a "custom" windows title bar? I want the default context menu (the one that appears when clicking a forms caption bar) to show when clicking a control on a form... generally i want to make my own title bar (caption bar) for a form...the code that fails is "formTitleContext"also any suggestions to writing more concise code for this task will be greatly
View 4 Replies