3,842 Topics
 | |
| | 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?  |
| | Here's a fun problem for you geniuses who know SharePoint and networking. We upload videos to our SharePoint site. Regardless of the size, when we play it here at the corporate office, it will play about 20 seconds in and then reset to zero and you would have to refresh …  |
 | 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 have the code below in VS 2012. It dynamically allocates a DataGridView and an Update button, then it binds the grid to MS Access database table. That all works well. When I click the Update button btnUpdate_Click() is called, which calls the DataAdapter's Update() method. That produces the syntax … |
 | 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 … |
| | I have no idea why the program isnt working, its practically the same code I used in the last project so why wont the database update? The code for the program is as follows: 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; … |
 | Ok, so I have 3 computers in my house. 2 of them have complete internet access, the otherone doesn't and I don't know why. Let's call this computer A. Computer-A can't access web pages (using let's say chrome or IE). However my router has it's mac in the connected devices …  |
| | 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 … |
| | hello, i am trying to save data in my listview item to access database.. i am new to programming and i am currently working on a project i need to submit very soon, this is really urgent and i will be much happy if i could get assisted as soon …  |
| | I am trying to create a form that allows the user to search (Access database) for a record by last name or customer number. It can be a partial last name or customer number. The SQL statement and code are below. This is the same method used successfully for a … |
| | Hello, How do I return the value of a custom property in Word 2007 using VBA? Depending on the custom property, I also need to automatically check a checkbox using VBA. Thanks! |
| | 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 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, In Windows 7 (and possibly older, can't remember off the top of my head), you can select which icons appear in your taskbar and which ones are only visible if you click the up arrow. Is there a way to set this default programatically? If it's relevant, my current … |
 | Come on then guys, one of the gratest wars of technology and IT - whats the best operating system and why?  |
 | Does the repair/recovery disc for Windows xp need any sort of installing before I can format my hard drive with it? My computer has a virus that doesn't allow installing of programs. I want to know before I order it from eBay.. I don't know much about this sorta thing |
| | If you thought, or indeed hoped, that the Google Chrome OS would be a thoroughly modern marvel running web apps only then you are about to be disappointed. It would appear that even the brave new future of the OS cannot escape from the legacy of Windows. According to a …  |
| | 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 … |
| | Hi all, We use a .hta vbscript from a fileserver, but after office 2007 has been intalled, the script does not read/write from/to a .mdb file on that same fileserver. The script does work (with office 2007), if it is started from a desktop instead of the fileserver. (reading/writing the … |
 | I am moving from database from Microsoft Access to MS SQL and I have not worked with MSSQL before, can you recommend a good place to get some initial and then follow on training in SQL and MS SQL?  |
| | Hi All My requirement is converting large quantity of images to vodeo (wmv) file without using Third party application such as power point. I googled it and find the windows media sdk is most closer to my requirement but, i do not find how to work with him my Question: … |
| | Hi, I am currently migrating access programs into vb.net with t-sql database backend. I am having 400000 rows of data that I have to pass into recordset and display it on the grid. In the good old access, the data appears almost immediately. Because access does not wait to load …  |
| | 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 … |
The End.