It is very well written in books to use the classes, created in VS2010, in Excel. I want to create a control (a class with user interface) in VS2010 and use it in Excel 2007 or Excel 2010. Please suggest me any literature as a starting point.
View 2 Replies
Is it possible to preview an excel file in the printpreview control? if yes, please give me some guidelines.
View 5 RepliesI am trying to export data from textboxes to a blank newly created excel document on button click.
I'm simply taking the string data from textboxes and exporting/saving them to a excel document.
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 am trying to use a spreadsheet with VBA macros that I wrote in Excel 2007 in Excel 2010.When the macros run in 2010, I get the error message "Can't find project or library" on functions like UCase and Date.I've set the macro settings to "Enable all macros" and selected "Trust access to the VBA project object model."What do I need to do to get these macros to run in 2010?
View 2 RepliesI need to import a .csv file so that it formats it all nice-nice so I can easily get the information from a column or row, then I need to grab certain rows, then reorganize it and save it into a different Excel spreadsheet for the program to then use. The original .csv does not contain the information in a way that we need it to be.
What I found so far: I saw this code snippet online
'-----------------------------------------------------------------------
' CONVERT CSV FILE TO XLS AND PROCESS XLS ROWS AND COLUMNS
' Opens Excel, imports .cvs file into xls format
' Iterates xRows and xCols from xls format
[Code].....
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]...
Basics Details:
VS 2010
Making an Addin for Excel 2010
Win 7
Problem:I am not getting the cursor (4 arrowheads) for moving the form.I am using the Panel1_MouseHover to display the cursor. Right now if I choose any other cursor then it is working but the same cursor also displays when I hover the mouse over any other control. I want the cursor to show only in the areas of the Panel where there are no controls.How do I show Tooltips for the images? The play,stop,next, previous,playlist,Hideme(with the smiley),volume are all images and not buttons?
I have been able to associate a listview control with an imageview control to display images. There are a couple of things, I would like to do.
1> How do I display the image in the second column? 2> How do I increase the size of the image getting displayed? My images are all 48 x 48 (pixels), but they keep shrinking.
VB.NET
Option Explicit On
Imports System.IO
[code].....
I'm trying to make a program with transparent labels over pictureboxes and when I set the label Parent to the PictureBox the position of the label changes.
View 2 RepliesI am looking how to set events to a webrowser which is being created by the following:
[Code]...
i have my database in VB2010 and i want to push 2 tables from that database to MS Excel 2010. I came across [URL] but even after following the steps i'm getting an error: Type 'Excel.Application' is not defined.
Imports Microsoft.Office.Core
Imports Microsoft.Office.Interop.Excel
Imports System.Data
[Code].....
with VB.net 2010, i would like to export a text file (with ; separator and variable length lines) to excel 2010
View 3 RepliesIn my application, users can establish connections to one or more databases in order to pull in data, thus a read-only connection is sufficient. I use the following connection string syntax when connecting to an Excel 2010 database:
[Code]...
I'm trying to sort a range in excel 2007, copy it and export it to another workbook. I can get as far as selecting the range but, I get lost after that...I have searched a lot of threads but, just can't seem to find one that give me an exact answer.
View 4 RepliesI have a set of pictures about I want to apper within the Excell spreadsheet depending on cell value:i.e.If cell A1=1 I need picture 'X' to appear.I have few different pics I need to appear in the same place within the spreadsheet depending on cell value.Is that possible and how?
View 1 RepliesUpon my program startup, I need to see if an Excel 2003 file with a certain name is open and then control it (set a reference to it). Unfortunately, the path of the Excel file is not set; else I could just detect if that file was open. So I guess I need to somehow loop through all open instances of Excel; then once I set an Excel app reference to each instance I could loop through the workbook names... But how would one go about looping through open instances of Excel in VB.net 2008?
View 5 RepliesIf an excel document is opened inside a webbrowser control, and you try opening another excel document using a different instance of the same web-browser control, the previous opened excel (inside the web-browser) would not allow users to edit the excel workbook.
View 1 RepliesVB.Net 2010 program .exe on PC with Excel 2007 gives error when cannot find Excel version 14, which is Excel 2010 I have developed a program in VB.Net 2010 which reads from an Excel spreadsheet. It works fine in the IDE on my computer. I built an .msi and executed it on my computer. I get "Error: 53 - Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral,PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified."
The only version of Excel on my computer is 2007, which is version 12.0.6557.5000. The version the error says it needs, version 14, is actually the version of Excel 2010.I have put in MsgBox statements to find where the error occurs.
[Code]...
I have a spreadsheet in excel with three headers:
Project Name The name of a project i'm working on.
Requested Role The job title/profession of the project employee. (example: mechanic, manager, engineer)
The name of the employee.When i click on the Person's name i want another page or tab (specific to this person) to appear showing details about them such as their name, job title, how long they worked, what project they are doing... etc. (similar to a Facebook profile)
When i click on the project name i want another page or tab (specific to this project) to appear showing details about it such as the requirements, the deadline, who is currently working on it... etc.
Furthermore, i would like to set up two levels of access:For the specific pages i was thinking of using the tab control but i want it so that i can search through the list of projects or names, select one, and then it brings up the page about it.The levels of access is the least of my worries.
I am trying to use a webbrowser control to display an excel workbook inside a windows form. I checked out articles on Microsoft support and this is the code that I am trying out -->
Dim oDocument As Object
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles Button1.Click
[code]....
However, on run, the excel workbook opens up in an excel application instead of webbrowser control? I am using Visual Studio 2005 and IE 8?
I try to develop a automation-add-in for Excel which can get some data from our SQL DB. So i call my add from an Excel-cell.. like "=getThisFromDb()"... This works totally fine! But what if i want to write to another cell then just give a return value? I managed to get the running instance of excel. I can read from it. I can open a new document in it and write to it. ->> But can't write to the Worksheet that called me!!
View 2 RepliesI have an activex command button located within a worksheet. After pressing the button a couple of times to run VBA Code, the caption size uncontrollably expands larger than the size of the control. I have to go back into the design mode to adjust the size of the button to fix.
View 9 RepliesI am exporting an aspx repeater control to excel, but in addition to exporting the data in the repeater I am also getting all of the html code. I want only the data, what am I missing?
Heres the snippet of code.
Private Sub submitxcl(ByVal Sender As Object, ByVal E As EventArgs)
If Sender.ID = "xcelBtn" Then
Dim fName = "ChargeAndSavingsForReportingPeriod_" & Replace(Trim(frdt.Text), "/", "-") & "_Thru_" & Replace(Trim(todt.Text), "/", "-") & ".xls"
[code]....
I have two questions concerning navigation in a 'mutlipage' control embedded in a form layout in Excel:
(1) I would like to be able to automatically move from page_1 to page_2 through a closeout button click command on page_1 (i.e. when actions are complete on page 1, page 2 will open without needing to click on the tab). Is this achievable ?
(2) secondly, While realising it is a simple step to set up navigation to another Excel workbook, is it conveniently possible (from a button command in the multipage) to open another directory, e.g. MMC console
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?
I am currently building a tool which uses access as the backend and excel as the user interface (I am unable to change the applications).I would like to be able to use the listview option, howver I haven't a clue and searching on the internet is causing me a headache.
Basically what I would like to do is get the heading names from the table in access and populate the listview, later on I will what it to look at specifc data to populate the list view.
My connections is already open, I think I'm ok witht he sql, its just the other bits.
Background: (Office 2007 and XP Pro all Up to Data; Net Framework 3.5)Two data files are compared one to the other (in Access via VBA) to ascertain matches & non-matches. This aspect completed in Access because of Access's large datafile capacity
The matches and non-matches are passed to Excel via Offine Automation In short, I am attempting to ascertain the "Access-related" VB.NET References required in VB.Net Solution Explorer.
I have included snippets of the VBA code for examples of the Access objects.I would like some knowledge from an expert in Office Automation and VB.NET.
[Code]...
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
I want to make a program combined with excel. can some1 explain to me the basic commands or refer me
View 9 Replies
