4,334 Topics
 | |
 | hy when i run this command to open excel and i get error (on 2007 excel it was fine) //Excel.ApplicationClass xlApp; Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; SaveFileDialog oDialog = new SaveFileDialog(); xlApp = new Excel.ApplicationClass(); ** xlWorkBook = xlApp.Workbooks.Add(misValue);** xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); int i = …  |
 | Hi Group, I've written a macro to save a copy of the spreadsheet at the end of each day. I tried to test it as a shared file and learned the macro wouldn't work. Is this normal for a shared document? If so, is there a way around this? How …  |
| | Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a … |
| | A friend of mine said this would be the place to get some answers that there was a bunch of smart people at this site. I can usually dig till I figure things out but this time it’s a no go. I bought a Toshiba satellite P105-S6177 with no hard …  |
| | I think my two-year old hit some combination of keys as the keyboard on my Windows XP machine just make clicking noises but generate no type on screen. I've tried the shift-tab, shift-scroll lock and 3x on the scroll-lock key but none help. Any ideas? I should add this is …  |
| | Hello Group! I am in need of converting a "text" file created by a UNIX based program (it is only semi-formatted) and put it into a more-formatted text (.txt) file. Put a different way, this needs to be converted such that it can be opened in Notepad and it be … |
| | I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets of code that do one or the other perfectly, but I can't make it work. I'm sure I'm just missing …  |
 | I'm a fairly prominent member of the Linux Community as a writer, contributor, and longtime evangelist for the cause and there are a few things I'd like the Community-at-Large to consider on my behalf. These are five things that I wish Linux had. Consider this as my wish list for …  |
| | Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It is creating a text file for us that uses the date, the hour, minutes and seconds that the file was … |
| | I believe I got a trojan virus that has caused some damage to my computer which will no longer connect to the internet. I read several threads on here and these are the steps I have already taken: 1)I downloaded and ran Marlwarebytes and AVG. (I think it found the … |
 | Hi Team, I was wondering if I am the only one who is not able to do it or what. Well, as the title suggests, I would like to OPen Excel in vb.net. I was able to find end number of articles online on this but none would help. It … |
| | This question covers Windows only. I know Microsoft makes a wide variety of other software products (Office, Exchange, etc.), I'm not interested in them, only in the Desktop Operating Systems. [B]First[/B] - unlike the most of you, I've read Microsoft's financial reports, and understand accounting. I know how much money …  |
| | Hello-- I am not sure where I should post this. I have an Excel spreadsheet with some cells I would like to concatenate into one resulting cell. I can get the cells concatinated, but I would like to concatenate one cell to the degrees symbol, followed by a space, followed …  |
| | I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change … |
 | Hello, The website that I build has xampp logo sides it's title. I wonder how to erase it? Daniweb has the right logo - > Mind has xampp logo in it. I would like to erase it or change it but I do not know how to? index.php <!DOCTYPE html> … |
| | Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, … |
| | Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a "Run-time error '9': Subscript out of range" error. I have no idea what is causing it. It is stoping at … |
| | I've been having a ton of problems since my boyfriend clicked on an email he thought was authentic from an ebay fraud. Web pages have been slow to not responsive, I kept getting errors about remote server refusing connections, the lan service kept showing proxy server settings and when I … |
| | Hi I use Firefox as my browser and whenever I enter a search on the "search the web" box I'm diverted momentarily to [url]www.goonsearch.com[/url] then to [url]www.plusnetwork.com[/url] I have tried to eradicate the virus using many tools without success. I have completed all 8 steps in the sticky and included … |
| | Hello, I'm carlo and I have been experiencing this problem for about a week now. The windows defender is not functioning and the win explorer keeps on closing. here is my hijackthis file: Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 3:04:04 AM, on 9/14/2013 Platform: Unknown Windows (WinNT … |
| | I need to install Z tool in MS WORD and use the option in MSWORD  |
| | Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a range of dates in a column to find the row the matching date is on. I have some things that … |
| | Good day! I want to save the data report with the .mdi(microsoft document imaging printer viewer) on a specidied folder.. 'Print to a Specified nondefault printer Dim PrintData As Printer Dim defprinterpos As Integer Dim currentPrinter As String For Each PrintData In Printers If PrintData.DeviceName = Printer.DeviceName Then currentPrinter = … |
| | I´m having some trouble with my web browsers, both internet explorer and firefox. After around ten minutes or so of use, whatever browser I am using keeps opening itself again and again and won´t stop. The pages open to the homepage. I´ve run adaware and spybot and norton, and they´ve … |
| | hi everyone im really new to report viewer in vb.net and i wanto import the data from an excel file to the reportviewer in vb.net can anyone help me out? here is waht i tried so far: Private Sub ViewReport_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local … |
| | Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 … |
| | How to copy a word table multiple times to a specific place using VB.Net 2010? I have viewed the other responses and these seem just not to work. I am working on a VB.Net 2010 program using the Interop class. We are having problems trying to duplicate a table more … |
| | I have an excel file that i managed to perform some calculation.It's to know the asset value of bridges in a current year.I have 21 fields in the file.Out of the 21 fields,seven fields are just information about the bridge,the rest are used for the calculation based on various conditions.And … |
 | SYSTEM: Windows 8.1 Tablet, VS 2012 OLD SYSTEM: Windows 7, VS 2013 Enterprise (thanks to my employer) Something is wrong. I never had any errors on my old system. On my new system, I'm getting the following: An unhandled exception of type 'System.Exception' occurred in Microsoft.VisualBasic.dll Additional information: Cannot create … |
| | In my Windows application, I want to create an automation software using C#.NET which works in two steps: 1. Select particular data and copy it from a page of a website. I have done it using web browser control for SelectAll. The data is not HTML data but databound data. …  |
| | Hi All, I am using cognos report sudio 8.4. I have got a problem in adding each cell to its next cell data (means running total not addition two cells). I tried with available report studio functions like running_total, Moving_total. I got errors. I am automating excel reports into cognos … |
| | Hi, I want to use the microsoft office theme (rubban for example,the word button's form) in my C# wpf application,is it possible? I work with visual studio 2010 thanks for help |
| | I need to dynamically group rows together in an EXCEL worksheet. The obvious choice to do this will be VBA. I hope you can help. My spreadsheet has 18 columns and (up to) 5,000 rows of data. I've written the following code which works "OK" however it fails to group … |
| | helo friends. i need to deal with more than 10 excel sheets.. so i want to make an desktop application in Visual Studio(c#), which performs as followings..: 1) first user can choose on which file he wants to work on. 2) then retrieving column wise data, and performing many mathematical … |
| | Hello, The code below works almost perfectly except for two flaws: 1. It provides the full name of the file (workbook.xls) instead of just "workbook" 2. If there is more than 1 worksheet then the loop appends the previous worksheet to the filename. For example, Workbook1 has 1 worksheet Workbook2 … |
| | I want to import/upload excel files to sql server via cake php, it will occur Undefined variable: ext and Undefined index: the code are shown as below. Is there any mistake in my code? Thanks in advance! <?php App::import('Vendor', 'php-excel-reader/excel_reader2'); class UploadsController extends RealTimeAnalysisAppController { public function upload() { $destination …  |
| | i'm not sure what is the syntax error. I try in this source code in dreamweaver, it shows line 8 is a syntax error. $destination = realpath(‘../../app/webroot/uploads/excel/’); App::import(‘Vendor’, ‘php-excel-reader/excel_reader2’); //import statement class UploadsController extends RealTimeAnalysisAppController public function upload() { $destination = realpath(‘../../app/webroot/uploads/excel/’); //Set your upload path here if(isset($_FILES['Upload']['XLS_File'])); $ext = … |
| | Good Morning Everyone, May i know how to extract all data from a excel file and copy the data all over to another excel file? Example from Excel A, we have data EmployeeID Name Department 1111 John MIS I want to copy the data over to Excel B... may i … |
| | Hi, I have a 3-column data (below) from excel file. How can I write a perl code to sort all rows according to the first numeric number of a numeric interval and the word "complement" if they appear before the numeric interval as shown in the expeceted output below? Data: …  |
| | Hi All, How can I export data from gridview to excel sheet in ASP.net? |
 | Was updating tags, at some point I got to this: http://www.daniweb.com/tags/tables Is this a caching issue? It's showing "usability" and "excel". I do come across tags in the tagclouds, where the link goes to the "Oops" page (e.g. http://www.daniweb.com/tags/three). Am guessing it's because I removed that tag, but the cached …  |
| | Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check … |
| | Hi all, i encounter an syntax error "Syntax Error in Insert Into" when i try to run this code... anyone can assist? Thanks! Dim sConnectionString As String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=H:\Users\Desktop\EmployeeAway2.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""" Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objConn.Open() Dim objCmd As New System.Data.OleDb.OleDbCommand() objCmd.Connection = objConn … |
 | hello thank you for your good solution but your solution always assume external workbook to be open, how to work with current opened workbook? Dim oxcel As Excel.Application Dim owb As Excel.Workbook Dim osht As Excel.Worksheet oxcel= New Excel.Application oxcel.Visible = True owb= oxcel.Workbooks.Open(Path) osht= owb.Worksheets(1) now I developing add-in … |
 | When using my Toshiba laptop the screen went black for a few seconds, came back, the went black again permanently. I turned it off but when I turn it back on the Toshiba loud up screen comes on but the screen again goes black afterwards. The solution of, 'turn it … |
| | Hi I am trying to upload excel file data thorugh .net uploading code. But i am getting an error message. can any one please help me to resolve this. **Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="add_residentupload.aspx.cs" Inherits="add_residentupload" %> <table class="table-list"> <tr> <td width="30%">Upload File</td> <td><asp:FileUpload ID="fupUpload" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" …  |
| | i need to the step by steps screenshot and coding |
| | Hello all, I have created an application in vb.net 2010 on my PC which runs Windows 7 (64 bit). I created a form with a webBrowser container to open docx files, but the method navigate, open the document in a new external window. I would like to open the docx … |
 | can any one help me.. how to export a table echoed in php to an excel through a button ?? |
 | Hi, My requirement I need to edit or replace content in the word document every time and save it to another location. What I wanted is I want to simplify this through vb.net but stuck in somewhere I am doing mistake in the code itself (I am completly newbie). I … |
The End.