4,334 Topics
 | |
 | Hi everyone i have a connection to my sheet like this Dim da As New OleDbDataAdapter("Select * from [EBU 2 LOB$]", con) but i want to use this Dim Sheet1_EBU as string = "EBU 2 LOB$" so that the code will be something like this i think? Dim da As …  |
| | hi all i am reading excel file from c# into dataset everything working fine but the problem is it takes first row of excel as header's of column and i have "TRANSACTION DATA FOR CDs MANAGED BY TCBILs FOR THE MONTH OF DECEMBER 2012" in first row of excel ant … |
 | I just setup a new Dell computer running Windows 7 64-bit copied over the data using Microsoft's Easy Transfer then installed Microsoft Office 2007. However, now when opening an existing Excel 2007 spreadsheet, Excel appears to hang for over a minute before any changes can be made. Are there specific … |
| | hi, I have a sheet name 'rate' and another sheet name "master". rate sheet has data as below EmpCol1 rateCol1 a 1 b 2 c 3 etc... and master has data as empCol2 rateCol2 c a b What i want to do is to get the rateCol1 from rate sheet …  |
| | does anyone know how i can fix the pianoman virus on my computer and get my office documents back  |
 | 'the code is working properly only problem with this code is when the first line ends in excel and data is inserted in next Row "instead of inserting another row it copies the same content which is inseted last time in form "  |
 | I want to read data from word file without using interop.word dll..Because i don't want to install word in every server....Is it possible to deploy interop.word without installation of word in iis..If not provide a solution to read word file without it with complete code....I tried with open xml sdk …  |
| | Hello its me again... sorry to keep on posting about my problem well here it goes.. If you see in the attached file.  I have an AM Ervielette, Marriane etc. now i need to add their Total Calls for Ervie and Total Visits same goes to the other.. … |
 | Hi I once went for an interview before my previous job it was a practical interview and I was asked to determine and fix a number of problems and I cant for the life of me remember what was the fixes so was wondering if you guys could help: **the … |
 | Microsoft Office VBA is a language many of us love to hate. I am no exception, but I know better than to kick the cash cow that feeds me. As it is, the grand and spacious realm that is DaniWeb lacks a VBA forum. There's VB.NET, VB4,5,6 and Legacy Languages. … |
| | I have a calculated field that takes the ID field of a table and pads it with leading zeroes. So far, I've gotten this to work: `String$(4-Len(Trim$(Str$([ID]))),"0") & Trim$(Str$([ID]))` Broken down, it takes the ID field, and string-ifies it. For some reason, this pads it with a space, hence the …  |
| | can i get free download of MS office?  |
| | hi. my name is Marvin, from Australia. i am totally blind. i use a screen reader called Job Access With speech (jaws), right! a picture of a shark. from http://www.freedomscientific.com. okay here's my review of jaws 14. some of the new features i use include, when you can not read … |
| | Are you a freelancer or programmer for hire? Join, post & bid for projects free. Thousands of skilled programmers, skilled freelancers to choose from. Ultracoder is a developer oriented outsourcing site. Skilled programmers will bid to complete your project right now. Computer Based programs, Training, Web Services, Language Specific programs, … |
| | I'm still getting my feet wet with Java and I'm not familiar with all the custom libraries that exist; is anyone familiar with a library for working with multiple sheets of a Excel workbook? I need to pull data from a specific worksheet in the book to work with.  |
| | hi! i want to open a word document directly from a windows form application running on visual studio 2010! i tried a particular code but it wont work!!! this is the code! [CODE]this.Application.Documents.Open(@"C:\Test\NewDocument.doc");[/CODE] i also imported and used the following header: [CODE]using Microsoft.Office.Interop.Word;[/CODE] it says that the word application does …  |
| | Explorer is running in the background and I can't stop it. This has been going on for a week or so. Explorer sometimes runs as two processes simultaneously, one under "New User" and one under "System". I use Firefox 99.9% of the time. Any advice will be much appreciated. Below … |
| | Can any tell me ReadOnly Status os Excel Driver... I want to read from and write into Existing Excel Sheet.. Am using ADODB.Connection and ConnectionString as "DRIVER=Microsoft Excel Driver (*.xls);DBQ=FilePath;ReadOnly=1;" in javascript.. Here ReadOnly=1 indicates the connection to be established in read only mode.. If I put ReadOnly=0, then Is …  |
| | Help i need to import excel to my listview using adodb or oledb but i dont know how? in vb6 i use adodb and the code is like here Dim lngI as Long Dim lvItem as listItem *'adodb connection goes here...* *'then this code will import all excel data in … |
 | So there is a problem: I get data from the internet in table form( currency),and i want to get it into the chart form,and after refreshing-it could show the same as real forex trading platforms. And sorry for typing not in right direction, VBA close to /excel..and couldn't find any … |
| | Hi, I want to know what code should be used in order for me to import data from an excel file to dataset and then adding it to the database, how can it be done? thanks |
| |  # INTRODUCTION # This toolsuite will let peolple hide or unhide secret message inside of Microsoft Office 2007 files .just in an intelligent way.Since the newer Office files are basically just zip files containing XML and resources.By zip library,we can extract some xml parts inside of the file.This … |
| | I've been having problems with my computer. First images, or the arrow to get to them, weren't clickable in websites such as babycenter.com [Babycenter.com/slideshow-baby-size?slideNumber=36](http://www.babycenter.com/slideshow-baby-size?slideNumber=36) . Then the other images on websites such as walmart.com became unclickable [walmart.com/ip/Samsung-32-Class-LED-720p-60Hz-HDTV-3.7-ultra-slim-UN32EH4003/21081426](http://www.walmart.com/ip/Samsung-32-Class-LED-720p-60Hz-HDTV-3.7-ultra-slim-UN32EH4003/21081426) . Now websites either aren't coming up at all and either showing Internet …  |
 | Hello to all, I am working on a spreadsheet/database for my company to track our service calls for the equipment we sell. There are a total of three of us that travel to different locations. I have helped create a database that allows a user to enter information after completeing … |
| | I am getting an error..Need help.. " Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\test2.php on line 24"; line 24 is --"header("Content-Type: application/xls");"-- <?php $DB_Server = "localhost"; //MySQL Server $DB_Username = "root"; //MySQL Username $DB_Password = ""; //MySQL Password $DB_DBName = "test"; //MySQL Database Name $DB_TBLName = "sample"; //MySQL Table … |
 | -->>Hi to all, now I was about to document the help file of my applicatiion and I thought "How or what kind of controls will I use to have something like waht Microsoft has in a Word application where I can just write the documentation in in such a way … |
| | I have a barcode scanner. So when the barcode is scanned using a gun, the value normally is entered to textfield placed on the screen. So I have made an excel macro. And when the barcode is scanned, the text appears on the cell ending with the new line character … |
 | Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this … |
 | is it possible to load the data contained in an Excel file into a MySQL table using PHP? |
| | My laptop is infected and I have tried everything I know to clean it. I now need your help to interpret the attached Hyjackthis report. My normal anti-virus/Firewall is ESET NOD32. I have run the following, in Safe mode: * NOD32 Virus checker * Adaware * Spybot S&D * Karpersky …  |
| | Sorry - might be a noob question and there's no section for Microsoft office, but this is the closest section I can get. I just installed outlook and am using it for the first time. I added an email and it shows up on the left, but I also want … |
 | Hello Community, I was wondering if there is a way to make a program that will copy text from an excel spreatsheet and place it in another using visualbasic.net not vba? Please Help  |
| | Hello Community, I was wondering if there is a way to replace a cell value from one excel spreadsheet and save it as another spreadsheet but with the replaced cell value. Please Help |
| | Here is what I am trying to do: From VB.net open a word template --- Done Populate it from a database ------Done Have word report back with the saved file name so as I can add it to the database history ----Not done. I know is has something to do … |
| | I've inherited a small C# command line program that takes a date and creates several spreadsheets containing data pulled from a microsoft sql server database based on that supplied date and some names hard coded into the program. I'm looking to change the program to pull the data from a …  |
| | hello, desktop .ini has taken control of some of my folders and files. also, turned on pc and it said it couldn't load neccasary files and went into a scan. it seemed fake but nothing ever happened. Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 10:50:23 AM, on 11/5/2012 …  |
| | Hi , I am developing a windows application using C#. In that I want to display all the outlook profiles in a listbox and on selecting one, The folder structure should be displayed on a treeview control. I can display all the profiles in the listbox and on its changedindex … |
| | Good day, I keep running into a very persistent "Could not fine installable ISAM" error when trying to connect to an Excel sheet (office 2010) by opening an OledbConnection Here's my connection string: Dim strCon As String strCon = "Provider=Microsoft.ACE.OLEDB.12.0;ACE OLEDB:Database Password=" & strEnter & ";Data Source= " & strExcel … |
| | I would to add row values in an array each column will be an array value. echo '<table>' . "\n"; for ($row = 1; $row <= $highestRow; ++$row) { echo '<tr>' . "\n"; for ($col = 0; $col <= $highestColumnIndex; ++$col) { $values = '<td>' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() . '</td>' … |
| | I would like to add data from 2 worksheets in the same document and have them combined in one worksheet. Am using PHPExcel could you guys kindly help. -worksheet 1 and worksheet 2 = worksheet 3(combined worksheet1+worksheet2) Thanks |
| | Hi Using VB.NET I created an excel sheet with list of items in dropdownlist. Using the below code With xlWorksheet.Range("A2", "A101").Validation .Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:=[COLOR="Red"]"Construct,Testing,Review,Look Ahead Meetings,Process Audit,Process Improvement,Project Monitoring and control,Project Planning,Project Setup,Project Team Management,RCA Activities,Re-Estimation,Review,Review-Rework,Senior Management Reviews, Testing,Testing Rework,Training, Work Product Audit"[/COLOR]) End With But i can able … |
| | im making a student marksheet generation project.....and i need a facility to print from turbo c++ to excel.... i have used only file handling and no database(tht was the criteria). pls help.....  |
| | I want 1 dialog box which is having a login username and Password field. ANd it must have 12 buttons. whenever i click on any button, it must open 1 Excel sheet associated with it. Just want 1 skeleton code.  |
| | The cell values in excel are all formatted as text. Each value in the source array is not a String but to a proper data type based upon its value but I want the cell formatted value as it would appear on the screen in excel. Some of the cells … |
| | I am trying to open an instance of Excel 2007 and load some text into a new file's cells (such as a list of something) through my Delphi4 program. I have already tried the ShellExecute and ComObj (variant) methods. ShellExecute works fine on the Windows XP platform, but not on … |
 | When I see an article starting with the sentence saying a company offering free software has urged people to start reaping the benefits of free software, I get this sinking feeling. I mean, they would, wouldn't they - it's a bit like Microsoft saying everyone should get the benefit of … |
| | I wasn't quite sure where to post this so I thought considering SSRS in VS 2005 produces XML scripts i thought this would be the best forum. I have a table grouping which produces a number of tables using the same section of xml code. Due to this the problem … |
| | Hi All,, I want to add new leave type which its respective purple color to the already existing template by microsoft office available at "http://office.microsoft.com/en-us/templates/results.aspx?qu=employee%20attendance&queryid=194963f8-3883-4599-b317-3dbd92b705c5#ai:TC102780235". Anyone could help me how to add new add new leave type and its color to the year column. Thanks in advance Jos  |
| | I want to make student management system in which student will enter his data and we can save it in any other program such as word, excel. And when he will open again he can get his data back.. |
| | Hi, I am writing code for connecting to an access database in my windows 7 machine. Am using visual studio 2010 with access 2007. While debugging the code am getting the exception **"The 'Microsoft.Jet.OLEDB.4,0' provider is not registered on the local machine"**. Below is my code, Try connection = New … |
The End.