2,270 Topics
Hi, I was trying to open "TIPS FOR FINDING CLIPS" and this message appeared:- "THE FEATURE YOU ARE TRYING TO USE IS ON A NETWORK THAT IS UNAVAILABLE. CLICK OKAY TO TRY AGAIN OR ENTER AN ALTERNATE PATH TO A FOLDER CONTAINING THE INSTALLATION PACKAGE, 'PRO11.MSI' IN THE BOX BELOW". …
Hi! I try to open an existing excel file and have included namespaces and libraries as well but the highlighted words show errors. Please help. [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Excel; using Microsoft.Office.Interop.Excel; namespace excel { public partial …
Hi! I want to read data from worksheet of one excel workbook and display it in the sheet of other. My code doesn't read the data, means it doesn't display it either. I tried a lot writing different pieces of code but it didn't work. Following are the lines. Please …
I am exporting data to excel but inserting rows is very slow about 2 seconds per row pls help using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.SqlClient; using System.IO; using Microsoft.Office.Interop.Excel; namespace Dashboard { public partial class Form1 …
[code]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.SqlClient; using System.IO; using Microsoft.Office.Interop.Excel; using System.Reflection; namespace Dashboard { public partial class Form1 : Form { public OleDbConnection con,con1; public OleDbCommand cmd,cmd1; public OleDbDataReader dr; public OleDbDataAdapter db; public string …
Hello everyone! I need to anticipate that I am very new to the Microsoft developing world, therefore I am not confident with Visual Studio. I need to write an application for a windows server that works with excel. Looking on the web I found that the best method would be …
previously i had microsoft office 2007 in my pc. Then i tried the trail version of office 2010. Recently i uninstalled this trail version in order to retrieve office'07. But i lost both the offices and don' have any office in my pc now.Please help me.Can i retrieve the office …
When i download and install SP1 for Office professional Academic, it shows this file is unsafe and will not be downloaded. I want to konw why i can not download and intall sp1.
hi, i'm using an excel add-in which creates protected sheets where i can select options in different controls (like listboxes). I need to have a process run at intervals but this option is not included in the add-in. The process is initiated by selecting "Starts" from a listbox. Is there …
is it possible to install office2003 & office2007 at the same computer without any clashing .and how should i open excel 2007 file in excel 2003 .Kindly let me know the idea .any help would be highly appreciated.
Is it possible? Currently, I am inserting data to a CSV file using PHP via the fputcsv() function. When opened in Excel, it works fine. The problem is that all the columns are of the default size. Is there a way to autofit the column width and possibly modify the …
hi, i'm using winwedge to link up a balance to a computer, in order to gather the readings into an excel sheet. i've writen the code that starts winwedge at the press of a button, and created the macro that is supposed to request readings and send them to the …
Hey, I need new chart designs for Excel 2010 - Where I can download them for free? Does Microsoft offer free templates that can be used for Excel 2010? My line graphs almost look like [URL="http://www.daniweb.com/hardware-and-software/microsoft-windows/windows-software/92"]these ones[/URL]. I would like to create them in a more clear way... Any ideas?
hi i need to make an excel macro that handles serial communication and takes data from two lab balances. I've looked around and found that i can use xmcommcrc or winwedge (others too but these i'm experimenting with). The result should be that data would be recorded live into an …
hi i'm making an excel worksheet that will generate some random numbers. i used this formula: =RAND()*(High-Low)+Low, to generate a number between 0 and some other value and then subtract that from another number. Like this i obtain random variations around a value(just lower than the original). However, i need …
[CODE][TEX] I want to make a manu bar that is same as the menu Bar present in Microsoft office 2007. How is it possible? Thanks for the help!:) [/TEX][/CODE]
I cannot keep trying to solve this...It will eventually do me in. So I found you on google. I hope someone can help. I need a vba code for the attached excel 2010 file Once i have a vba code, i can then adjust it for further vba challenges. Thanks …
Hi, im looking for some advice/guidance with regard to visual basic. Im and final year engineering student and my project requires me to make a graphical user inter phase to teach aerodynamics. I need to find out how to link the programme i design through VB with excel. Then the …
I am building an excel address parser. Column B = streetnumber Column C = UnitNumber Column B is my streetNumber and What I need it to do is anytime it finds a letter attached to the number it needs to move it from column b to column C. So if …
A program I wrote calculates ratings for the winner and loser of a sporting event. As new results are added the ratings are updated, ie from Pre to Post. It works fine. I also need a version in Excel but I have a problem. Example of the problem: John’s Post …
is there any way to copy address book from one user to another user Ms Outlook ? .Kindly let me know the idea.it is very much effort to make hundreds of email id in New Distributin List/Contacts.
I have the code to parse data to a Datagridview and then export that into an excel spreadsheet. How can I export the headers of the datagridview? [CODE] var bs3 = new BindingSource { DataSource = query }; dataGridView1.AutoGenerateColumns = true; dataGridView1.AutoSize = true; dataGridView1.DataSource = bs3; } } private …
I am trying to attach an XML Schema to a document as mentioned here: [url]http://www.tech-recipes.com/rx/2099/word_2007_attach_xml_schema/[/url] However I am having trouble attaching the schema(s) in question. I am wondering if anyone can shed light into possible reasons this is happening. The XML Schemas I am trying to attach are these: [url]http://www.ddialliance.org/Specification/DDI-Lifecycle/3.1/XMLSchema/[/url] …
[B][COLOR="Green"]Hello, I am writing a PhD thesis and require some help numbering my figures and tables. I use Word 2003 and would like Word to restart numbering of my figures and tables after each chapter (NOTafter each section). For example, captions of figures/tables in Chapter 1 should read Figure/Table 1.1, …
I am trying to export a datagridview ti excel, but i get an error I do not quite understand. I have made two click-events using two buttons looking like this: [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cnn As SqlConnection Dim sql As …
Very new to writing macros, trying to impress the boss with a project, but I am stuck with a code. I can hide the rows when the checkbox is selected, but the other checkboxes are still visible. Is there a way to hide other checkboxes as well. My current code: …
I have a project where I need to retrieve data from MS SQL Server and format it into an Excel Spreadsheet. I am using the OfficePartner component to try and make this easier, but I'm having a hard time figuring out how to get the VB help and Excel Object …
Hi so i'm working on a project in c#. I have hundreds of xml files and I need to extract 6 values from each of the xml files and somehow display them on an excel datasheet. Here is an example of the xml file: [code] <XAxisCalib> <Max>288.93</Max> <Min>-48.08</Min> <MaxS>200</MaxS> <DfTHt>0</DfTHt> …
hi friends , i have set the signature for my all the outgoing emails .but when i tried to send any email .picture is not comming in proper way .it comes in cross format .Kindly let me know the idea .any help would be highly appreciated .
hi.. i just made two function related to excel . 1. Merging all sheet of excel as tables in single Dataset 2. Exporting a dataset to Excel File .(all the tables of dataset as sheets) i just wanted to share.. i hope it becomes helpful to you. ps: Dont forget …
Hi, I´ve got following code for a office 2010 like tabcontrol in .NET 4.0 [CODE]<ResourceDictionary xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"> <ControlTemplate x:Key="OfficeTabControl" TargetType="{x:Type TabControl}"> <ControlTemplate.Resources> <Style TargetType="{x:Type TabItem}"> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type TabItem}"> <Grid SnapsToDevicePixels="True"> <VisualStateManager.VisualStateGroups> <VisualStateGroup Name="CommonStates"> <VisualState Name="MouseOver"> <Storyboard> <DoubleAnimation Storyboard.TargetName="hoverShape" Storyboard.TargetProperty="Opacity" To="1" Duration="0:0:.1"/> </Storyboard> </VisualState> <VisualState Name="Normal"> <Storyboard> <DoubleAnimation …
So at work I had to keep recreating these summaries. Was a very tedious process so when I had some downtime I was able to create a little program in Excel that would spit out a days worth of work in 5mins. Now that I have that working, I am …
Hi, I am using excel to load a userform that will run a macro to perform processing on excel sheets. I have set the userform to load when you double click the macro-enabled excel sheet. Everything works fine except I can briefly see worksheets before the userform appears. How do …
hi friends, i simple want when any new emails come .from at specific email id .then it needs to go on specific folder on the basis of subject .so can you suggest me ?.how should i do it using rules and alert .and together with this i have already set …
Hi All, I have a section of my site that allows users to upload and download files. For security issues, We use a com object to take the file as a binary stream and store it on our network off of the web server (under a different randomly generated file …
Hello i have problem in my software, i want to read file excel and compare data. If i use file excel with small size it run succesfully, but if i use large file i have fault. Please some body help me
I've been following the tussle between Google and Microsoft this week with a mixture of amusement and amazement. If you haven't been following along at home, Microsoft took a dip into the cloud with the release Office 2010 Online this past week. Meanwhile, Google, feeling a wee bit threatened by …
Hi guys Can anyone help me with this one? I want to insert a loop in my code to read all the data in excel file here's a portion of my code. [CODE] private void btnUpdate_Click(object sender, EventArgs e) { string directory = "D:/myFile.xls"; if (File.Exists(directory)) { Excel._Application myPartFile = …
Please help. I have an excel file, I wanted it to search for a word let's say "marketing" from column A5:CH5(or maybe more) and wanted it to copy the entire columns that contains the word marketing next to the original columns. There will be more than 1 column that contains …
Hello, I'm hoping that someone with experience with programming against DB2 can help a new programmer down the correct path. I've been given a project that requires me to pull data from tables in the companies DB2 database, and when all said and done have that data placed into an …
Hey, So I am very new to using VB, Visual Studio etc. I am trying to do something really simple. Basically I have an Excel 2003 workbook with some data pre stored. All I need to do is add a chart to the spreadsheet and plot some data. However I …
Hi, I have been trying to display Microsoft PowerPoint Slides in my C# application for some time already, but it was in vain, I was wondering if anyone could guide me on that? Your aid will be greatly appreciated... Have a nice day.
hi...... help me any one ,how to read whole excel document in asp.net,for instance in my excel document have 3 sheets i want to read 3 sheets content at a time and display ... plz help me as soon as possible
hi, I have Citrix Reciever for iPad and when I try to run a Microsoft office application, it says that the server is currently unavailable. The app works fine for my iPod touch 4th generation. Any solutions?
Okay so I have a program that calculates the time it takes for my application to run and i need it to enter those times in one row in excel 2007. What is the code or way for doing this? There are 1000 times iteration so you can see why …
Hello, I have to append 30 Excel 2007 files, each with 6700 columns, into one. The problem is that in these files the columns are not in the same order(the column names are the same in all the files). Im having Python27 with openpyxl, Win7, MS Office 2007, MS SQL …
Hi Everyone, It's official I'm back. I've started adding input instead of randomly popping by and asking for some assistance. So in my disappearing act I managed to do the whole military thing, grab a few associates degrees make a lot of money.. lost in all in a really bad …
On the ‘Folder’ ribbon the ‘favorites’ section does not appear. Right clicking the ribbon and choosing ‘Customize the Ribbon…’ shows the ‘Folder’ tab as being selected and within that tab are ‘New, Actions, Clean up, Favorites, Share, IMAP, Properties’. ‘Favorites, Share and IMAP’ do not appear on the ribbon. I …
hi all friend I wanna Read some data from my Excel , but I can't work excel 2007, do you know what's problem.
So I've set up a data connection to a table on my website and the data imports just fine, but it formats the cells wrong. Case in point: The text coming in is "May 7". First Excel auto-converts this to "5/7/2011". But then it doesn't even display that, it displays …
The End.