4,335 Topics
 | |
| | 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 …  |
| | I downloaded McAfee Personal Firewall Express v4.5 to my computer. Since I have done this, my computer sometimes freezes when I boot up. When it freezes, I hit Ctrl + Alt + Dlt. It says that Microsoft Office Shortcut Bar Not Responding. When this happens, I turn off the computer … |
 | Not sure if this can be done. There are word files in a directory with all familiar names. i.e. fr001, fr002, fr003, etc... all with the extension .doc. I would like to know is there a code that will link an excel file to a directory and then be able … |
| | Hi, I have a problem on getting data from XML file. I am honestly have 0 knowledge on this. Here is the XML data content, i opened the XML file using notepad then pasted here. <?xml version="1.0" encoding="utf-8"?> <?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:Test-Form:-myXSD-2012-09-02T13-13-23" solutionVersion="1.0.0.55" productVersion="14.0.0.0" PIVersion="1.0.0.0" href="http://share.test.com/it/Test%20Form/Forms/template.xsn"?> <?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.3"?> <my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:pc="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" … |
| | a message keeps coming up telling me my windows 7 is not genuine. i bought the computer from dell and it was already installed on it - are microsoft right to tell me it's not genuine? what can i do about this? (i did validate my office word though, and … |
| | Sir I have a doc file,which doesn't open in any microsoft office.when you open this file in any microsoft office,its shows some unreadable characters as shows in below picture.so what can i do? any help plz..... Hamza Murad   |
| | I could reallly use some help. I am a complete newbie in python. What I would like to do is import a csv file (originally an excel file). Have the user pick a beginning month and an ending month and add the columns of the months between. For example I … |
 | hallo there i read an excel file using excel_reader library. The excel file contains greek characters. i get the data and store it into arrays (it is a common xls file that contains names, lastnames and fathersnames) using characters set utf-8. the code works fine //i uploaded the xls file … |
| | Dear C++ Gurus/Experts, I am writing a program to automate excel.My program is working well when I use integer (Write/Read) in excel.My program also works well when I use string.But the issue appears when I use array of strings.I am getting the issue as below **"error C2664: 'SysAllocString' : cannot …  |
 | Hi! I have a php code that generates an excel file that is populated with mysql data of course through a mysql_query.. Here it is.. <?php require("aacfs.php"); header("Content-type: application/ms-excel"); header("Content-Disposition: attachment; filename=Reservation Summary_sortbydate.xls"); header("Pragma: no-cache"); header("Expires: 0"); $head1="Ayala Aviation Corporation"; $head2="RESERVATION SUMMARY"; $head3="For the period ___________"; $heads="$head1\n$head2\n$head3\n"; $query = "select … |
| | Hi Everyone, I would really appreciate some help on this. I'm a web project manager - and the machine mgmt gave me has pretty much given up completely. It only works in Safe Mode - luckily Safe Mode with networking so I am able to get online. I have backed … |
| | Hi, I'm trying to generate Docx files using python. I searched the web and found a module: https://github.com/mikemaccana/python-docx/blob/master/README.markdown It says to install using easy_install or pip, which I have no idea how to do. I also have a mac so I think that makes it a little more complicated. I'm …  |
| | I have problem with writing csv file using **fputcsv**. Its putting the page html also into the csv file. Whats wrong with my code ? //Excel header header("Content-Disposition: attachment; filename=\"Delivery_Reports.csv\";" ); header("Content-type: application/vnd.ms-excel"); $out = fopen("php://output", 'w'); $flag = false; // $result = mysql_query("SELECT * FROM senderids ") or die('Query … |
| | Hi, I'm trying to export data from excel sheet to my grid, I'm using the foll code, but I get an error at DataGridView1.Rows.Add(), saying rows cannot be added programmatically. Private Sub btnexport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnexport.Click Dim xlsApp As Microsoft.Office.Interop.Excel.Application Dim xlsbook As Microsoft.Office.Interop.Excel.Workbook …  |
| | Hi all, Not sure if this is something that is possible or not but what i'm looking for is as follows....... I have an excel sheet of football league tables. The sheet automatically updates when I enter in results I'm looking for a way (prefibally in HTML as i'm fairly …  |
| | Hi guys, I am developing a software and I want to make it in good appearance!!!! As you see most of programs have a beautiful skins, I want too!! I have google it in days and I found a dll file called "DevComponents.DotNetBar2.dll" ( may you have heard about it) … |
| | Hi, I've written a routine for a customer to import sales orders into their Sage system. Everything was going well but the client has come back with a particular excel sheet that is not importing. He is getting a message to tell him the sheet is not in a valid … |
| | HI, I am have a string and I want to remove <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> from this string.I have tried str_replace but of no use can any one help that how would I remove this problem from my string. Thanks in advance.  |
| | Hi Guys!! I am creating an addin in Excel using VB.Net. I want to access the current worksheet using a ribbon designer. I have tried all sorts but to no avail. Also all the resources that I have checked are providing solutions by adding or opening new workbook. What I … |
 | Hi I want to install the following on my new laptop:- 1. VB6 2. Crystal Reports 8.5 3. Crystal Reports 9 4. SQL Server 2005 5. VS 2005 6. SQL Server 2008/SQL Server 2008 R2 7. VS 2008 8. Oracle Server 9. Microsoft Office 2007 What sequence should i follow …  |
| | Hi to everyone. I have created jsp report in that date column is there where am showing the date format like this (02-01-2012) <% String Rcheckdate=""; SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy"); Rcheckdate=df.format(rs.getDate("tr_dt")); %> <td align='center'><%=Rcheckdate%></td> In report i have given the excel button from there am exporting the data to … |
| | Hi I hope someone can shed some light on the problem I am having at the momment with an Excel 2010 Sheet, the workbook has 13 sheets with formulas and I rotate the 2 values using vba there are other things going on like a link to SQL server that …  |
| | Am having this piece of COde, but whenever am trying to execute this , Dim tsf As TestSetFactory - > error user not defined appears. pls help Dim tdc As TDConnection Sub UpdateStats() 'create QC connection QCconnect_silent "URL", "DOMAIN", "PROJECT", "USERNAME", "PASSWORD" 'process tests getMetrics 'disconnect QCdisconnect End Sub Private … |
| | hi there, i have an application that opens an excel file and get the values to the mdf file in visual studio database file. the code for opening the file is below [CODE] Microsoft.Office.Interop.Excel.ApplicationClass tt = new Microsoft.Office.Interop.Excel.ApplicationClass(); String path = a; tt.Workbooks.Open(path, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, … |
| | Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks  |
| | hey does anyone here knows how to change excel page orientation to portrait? i get landscape as default <?php header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=transactions.xls"); header("Pragma: no-cache"); header("Expires: 0"); ?> |
| | hi, i want to disable menu bar button(left-top) in office 2007 word document opened in windows form. please provide sample code. ASAP Thanks in advace... |
| | Hi All, I am tasked to generate report templates in excel and I am new to excel, VBA and still learning. A little more information on my task, the information for the report will be extracted from different sheets in the workbook which contains a whole list of calculation and … |
| | Hi, This is a problem googled easily, but no solution helped me. Locally I am trying to open a PowerPoint application to read and import a ppt (or pptx) file. this is the command where exception is thrown (ASP.NET VB): [CODE] objApplication = New Microsoft.Office.Interop.PowerPoint.Application [/CODE] the exception text is … |
 | Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end … |
| | From this [article](http://www.daniweb.com/web-development/asp/threads/42314/exporting-asp-pages-to-excel) i found this code snippet that imports html data to excel: <% Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "filename=excelfile.xls" %> <table> <tr> <td>Category Name</td> <td>Category Description</td> </tr> <tr> <td>Software</td> <td>Holds data for software</td> </tr> <tr> <td>Hardware</td> <td>Hardware related data</td> </tr> </table> However, what i want to do is …  |
| | First of all, I realise there are a fair few related questions on many other sites, in addition to Microsoft Support pages. I have spent many hours on this issue, and this is where I stand and what I know/have been able to achieve: * I have an application written … |
| | Is it possible to alter Excel Viewer print settings via VB.NET and, if so, what is the syntax I need to do this? I would like my application to be able to change the printing preferences of an Excel spreadsheet opened in Excel Viewer (through the application via `Process.Start()`). This … |
| | Hello, I am trying to read values from an excel spreadsheet but just for specific cells at a time; say Cell A1 and B1. Then I want to save the respective values into a variable and use the variable through out the rest of the code. Then loop at the … |
| | I'm struggling to think of a reason why I should be getting an 'Access denied' error when trying to save an Excel document opened through a program written in VB 2010 Express. The program is essentially glorified Excel automation. It converts information from hundreds of Excel documents into a few …  |
 | Hi Guys.. I recently discovered that I am having issues with Windows Installer. I searched the web and tried a couple different things and finally found a thread on this site. I went through the steps and will post the results below. Also, when I open up Services, Windows Installer … |
| | I need Delphi 2011 XE code for editing an Excel file. If there is found a text in a row of column A of the Excel file, to change the number of the same row in column B. That's all I need. Thanks!  |
| | Hi everyone and thanks in advance for your help! To begin I did have McAfee but deleted it and I am now using Avast. I fell victim to the idea that something free can’t be as good as something that you pay for. However, I have only had Avast on … |
| | Hello guys, I am trying to insert watermark as text in word 2007 using c# but getting error can u pls help me out. here is my code... //THE LOGO IS ASSIGNED TO A SHAPE OBJECT SO THAT WE CAN USE ALL THE //SHAPE FORMATTING OPTIONS PRESENT FOR THE SHAPE … |
| | Hello all, I have this C# code where in I am writing some datato an excel sheet and then saving it using saveas. But when I run the program again for the next time it is asking me prompt whether or not replace the exisiting file. I want it to … |
| | Hi. So I have this HTML file that tests the user's screen resolution, and plugins installed using Javascript. So when the user accesses the page it sees: (e.g.) Your current screen resolution is 1024x768 and you have the following plugins installed: Plug-in No.2- Java Deployment Toolkit 7.0.10.8 [Location: npdeployJava1.dll], Plug-in … |
| | Office 2007 on a Windows 7 PC. A user has an intermittent problem where when she copies a cell with a formula in it, clipboard picks it up as text. Typically, if one pastes a copied cell with a formula it also puts the formula in the cell. Not always …  |
| | Hi, I am trying to add content to an excel sheet using the below code. However, when I open the excel sheet, nothing is added. Please advice. public class StepNoToExcel { HSSFWorkbook wb = null; String fileName = "C:\\StepNoForEvidences.xls"; File file = null; StepNoToExcel() { file = new File(fileName); if(!file.exists()) … |
| | Hi, I have an application that converts the ascii characters within the excel file into hexa conversion ie. à to & #x00E0; but my application has one strict requirement and that is the excel file must be properly encoded in UTF-8. I have noticed that simply saving the excel file … |
 | Greetings all. I am a 38 year student and will be starting my last year of studies at a local university this fall. My field of study is Information Systems and I work as a student for my local utilities as an IS support for the company's Economic Analysis Department. … |
| | So, I'm currently trying to open a .xls/.xlsx file, tell it to run a macro to refresh the workbooks, and then save the file as a different file name, thus leaving the original untouched. Now, technically, it is working, because the last person who held my position wrote a dll … |
| | i just upgraded a user from office 2007 to office 2010, now her documents that user to print in 2 pages is now printing on 4 pages and so on, please assist  |
| | Can someone tell me how to install the speech recognition with microsoft office 2007? so far i only found speech recognition installations for office 2003. i need to install speech recognition for my microphone. Thanks |
| | I'd like to say "hello" to everyone as it is my first post. I looked for the solution to my problem on the internet for over 2 hours and I didn't find anything relevant. I hope you are able to help me. I have a bunch of invoices written in … |
| | Hello i cannot access any files to download and my antiviurs software will not work at all, i cannot access any antivirus websites, and i can't download hardly any files, it is the same for mozilla firefox too. Please help. Thankyou This is the Hijacker scan Logfile of Trend Micro … |
The End.