4,335 Topics
 | |
| | Hello, I am working on a web form project in Visual Studio 2012 and MS SQL Server 2008 R2 using Visual Basic. I would like to place an Excel file template in my project folder which would then be modified using the ASP.NET controls on the page and prompt the … |
 | My company is using a simple spreadsheet to write down things from control surveys. Then the data is beeing saved in a big and useless program. Since the data is beeing saved to a database, I want to view this same spreadsheet in a ASP.NET page, with the textboxes filled … |
| | Is it possible to create a delimited file and structure the delimited file in some way so that opening that file in Excel creates an Excel file with multiple worksheets with data on each worksheet?  |
 | hi, I am working on an asp application using c# and i can import excel file to sql table i have two columns in excel and as well as in sql of same name "id" and "status" when i import data both columns are imported to sql table in the … |
 | Situation: My VBA program compiles, but fails at runtime when I try to access a specific method. It doesn't seem to matter whether I set the method up as a function or a property get. Here is the code fragment which calls the method: ****** Function roots() As Variant ' …  |
| | Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart. Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are … |
 | I spent the last 8 or so hours trying to install Microsoft Office 2010 on Windows 8 Pro. Didn't happen. I called iYogi tech support who tryed to help me for the last 3 hours with no success. We finally concluded Office 2010 is not compatible with Windows 8. So, … |
 | I'm trying to generate a random number for each field in column "A" of my spreadsheet, and I have been trying to experiment with the following formula: =LARGE(ROW($1:$1000)*NOT(COUNTIF($A$1:A4, ROW($1:$1000))), RANDBETWEEN(1,1000-ROW(A4))) This is giving me the numerical values that I want, but is affecting both Columns "B" and "C" as well. …  |
| | Hi Guys... looking for a quick answer on excel Formula.. Anyone know why my text "Please Chase" is not showing up? =IF(ISNUMBER(F2),$F2>TODAY(),"Please Chase") |
 | Good day folks, lines = IO.File.ReadAllLines(txt_Source.Text) I have here a line of code which reads a text file and save it to an array, It works well. But I wanna ask if there is anything like this code that can be use to read a excel file? Something like this … |
| | Hi ! I have a column of 'City', now I want to compare the value of each cell of 'City' against the column 'City_Check'; the cell where the value matches, pick the value of 'City_ID' column & replace the city name with that ID in the 'City column'. * The … |
| | I have data in which column 'C' have cells which contain multiple values separated by (,).Now I want to get atomic values in all cells of column 'C'. i.e. that for a cell when there is more than one value; separated by (,) it should be copied in the next … |
| | does anyone know how to make syntax of max if in vb excel 2007? (not formula) |
| | I got this error from another computer, without visual studio. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at PAMS_Upload.frmMain.Validate_OtherDimensions() at PAMS_Upload.frmMain.btnLoadOther_Click(Object sender, EventArgs e) … |
| | I am trying to set the value of cells in an Office 2010 worksheet using this code in Visual Studio 2012: for (int i = 1; i < 5; i++) { xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(i); int columnCounter = 1; foreach (string s in columnNames) { range = ((Excel.Range)xlWorkSheet.Cells[1, columnCounter]); range.Value = … |
| | I want to put the total on the last row of the sheet regardless the number of the records. If 10 rows are populated, i want to put total on 11th row. If 12 rows are populated, i want to put total on 13th row. If I based the adjustment …  |
| | Hi, I have been trying to use AJAX with JQuery in a feedback page I am trying to build. I can get the feedback submitted without going to a new page, but currently I can only see the feedback updated when I refresh the page. I called the feedbackdisplay.php file … |
| | Hey guys, I'm a freshman in College and I've never had a job before. I really want to get a job doing some web development at my campus. The jobs are all entry level and I've beeing developing websites for the past six years so I feel like I should … |
| | A message comes up saying Setup cannot continue because a required file is either corrupted or not available. Run Setup again from the original disc or download location. But I went to Microsoft and downloaded it again but nothing happened! What should I do to uninstall it??? |
 | hello guys, This is my problem for example. My program is on my computer the image location of my picture is on my computer then i want to debug my program into other computer but the picture is not appear because the location path is changed this is my code …  |
| | I am working on a project in which i do some calculations for products and produce some end results then browse an excel file containing reference value for the products, but now i require that if a particular product is not found, that product should be automatically added to the … |
| | Does anyone how to hide excel macro worksheet each time excel 2007 starts up? using vba syntax thx |
| | I am opening a tab-delimited file in Excel 2010; the delimited file displays correctly in Excel but when I do a save as, to save it as a native Excel 2010 format, the resulting saved file is empty. The resulting saved file generates no errors when debugging and saves with … |
| | Hello everyone my name is andy... is anyone know how to make a simple data entry worksheet in excel 2007? i noticed that excel 2007 have a form control inside the developer tab i can add input text box and command button in sheet1 but i dont know what syntax …  |
| | Hi I try to convert ppt to video:; i know that CreateVideo is part of presentation. but, when i try this i have this error: Inline Code Example Here Looks like createvideo is not part of presentation. Microsoft.Office.Interop.PowerPoint.Application pptApplication = new Microsoft.Office.Interop.PowerPoint.Application(); Microsoft.Office.Interop.PowerPoint.Slides slides; Microsoft.Office.Interop.PowerPoint._Slide slide; Microsoft.Office.Interop.PowerPoint.TextRange objText; // Create … |
| | I am using this function to convert the contents of my richtextbox to html: Public Function myRTF_To_HTML(ByVal sRTF As String) As String Dim MyWord As Microsoft.Office.Interop.Word.Application Dim oDoNotSaveChanges As Object = Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges Dim sReturnString As String = "" Dim sConvertedString As String = "" Try MyWord = CreateObject("Word.application") MyWord.Visible = … |
| | I am trying to add an excel file(.xlsx) as a database to my vb.net 2010 project. But it does not recognize excel as a database type, it can only connect with access or sql. Any idea how excel can be connected to the project? Or should I just use file …  |
 | Good day, I am having trouble with the excel file that i was uploaded.. after i uploaded the excel file i want to validate each header and each datatype of it. just to make sure that my dbase has integrity.let say i have 10 columns. Is there a way on … |
 | Hello, I am trying to figure out a way to open MS Word inside a panel in visual studio 2010. The code I have works for certain .exe files but if I try with word or excel it opens it's own window. Can anyone tell me if this is possible? … |
 | Hello friends, I'm tring to make excel file using vb but i don't know how to do it. There anyone know how to do this. Thank you. Eko |
| | I have a program I wrote a few years ago that interfaces largely with MS Excel. At the time my company used Office 2007. We have since upgraded to 2010 with no problems. However, I had to make some adjustments, and now I can not compile. The error is Error … |
 | I have MS EXCEL 2k3 problem: On my previous post I have the NOT the INTERSECTION of 2 sets of data using VLOOKUP() where is the equivalent function of INTERSECTION in Discrete Mathematics. Right now I was looking for forums if Excel has the ability to combine 2 sets of … |
| | Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has a b c d e and f the data of Line B has b and d only if I use … |
| | what I am trying to do is use this php script to load the data being submitted in the html form into my database and then populate the database into an excel (csv) file and then e-mail it to my address. Everything works great it populates into the database and …  |
| | I dont know where to post it, but this is the reliable help from geeks I've known for several years Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has …  |
 | Hi there everyone, my laptop began behaving strangely last week or so, and I've exhausted my limited knowledge of computers but to no avail. Im hoping someone on here my be able to provide some assistance, as I see you've managed to help a lot of other people. Right, I'll …  |
 | Is there a way to remove blank worksheets from an excel report that is generated in SSRS? I've done some research and i could find solutions such as removing blank rows and even entire sheets but only via marcor's in excel, which won't work in my case as the report … |
| | Just wondering if anyone knows how to not save a document after creation when using Microsoft.Office.Interop.Word. Basically i am using mail merge to print off a report from c#, the document get made, values are passed to it no problem and i can then print it without any issues, however, … |
| | Dim conn As New OleDb.OleDbConnection Dim ds As New DataSet Dim dt As New OleDb.OleDbDataAdapter conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\admin\Documents\Visual Studio 2010\Projects\office software\office software\bin\Debug\Office1.accdb;Persist Security Info=False; " Try cmd.Connection = conn conn.Open() cmd.CommandText = "insert into Office Values('" & CInt(TBID.Text) & "','" & TBSupplierName.Text & "', " & TBProductName.Text & "," …  |
 | I want to delete specific values from a column in excel, without deleting the cells themselves i.e the contents of the cell if the content meets certain conditions. In my case I have a column of almost 0.5M cells & I want to delete the contents from the cells which …  |
 | Dear fellows , The problem is ,one of my client wants to setup a credit card system in his company. He want to provide credit cards to his clients to let them swap in the slot machines when they need money and all the slot machines need to connect with … |
| | I want to delete the contents from cell if the content of that cell are similar to the content of the previous cell of last column. i.e If the 10th cell of column 'A' & 10th cell of column 'B' have the identical content then I need to clear that … |
 | hi i want to display word file with same style using asp.net c# here is code that display word file content without images ,tables ,etc...... ApplicationClass wordApp = new ApplicationClass(); object file = path; object nullobj = System.Reflection.Missing.Value; object format = true; Microsoft.Office.Interop.Word.Document doc = wordApp.Documents.Open( ref file, ref nullobj, … |
| | Hi Guys.. Can any experts in Excel/C# Help me with this one? I think I'm nearly there. Currently I have a DGV on a windows form which pulls data from a Datasource. I want to export the findings to and Excel report template. I've managed to export the data into … |
| | I previously used 32bit Python 2.7 on Windows Vista. My new PC is Windows8 and 64 bit. I would like Python to work with Microsoft Office Excel. Is the best / simplest way forward to stick with 32 bit Python and 32 bit Excel? Can you mix 32 bit Python …  |
| | Hi, it's me again.. I have this codes wherein I can export the data from the databse to Excel.. I get a **Notice: Undefined variable: aData** on one of the php files.. well two of them actually.. The weird thing is... The other page which I have modified - i … |
| | Hello, I want to re-arrange my existing macros in the excel file. I have a macro which goes to the specified sheet and checks column R if there are commas. If it finds the commas it replaces it to dots. Column R is called Email. But in some of documents … |
| | Hello. I would like to ask for a help. I deal with excel spread sheets and very often I need to amend specific column. The whole steps look like this: Step 1. Find the column name, Step 2. Mark the all populated rows in this column, Step 3. Proceed with … |
| | Hello guys, I would appreciate if you could help my on the below issue. When i used an Excel object in my code, when closing this, the excel.xls applicataion remains opened at the task manager. i am copying below the test code for your reference, which i am using in …  |
| | I tried to install Microsoft office 2003 on my computer but I get the error message saying setup cant continue installation source has been corrupted. I've tried updating the maximal parser file as advised by Microsoft website but still have the problem. I'm using windows 7  |
The End.