4,334 Topics
 | |
| | Thank you all for helping me in completing my collage mini-project //form1 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; using System.Data.OleDb; using System.IO; using Microsoft.Office.Interop.Excel; using ClosedXML.Excel; namespace merge_excel { public partial class Form1 : Form { public Form1() { InitializeComponent(); … |
| | Hi All, M trying to design a web portal which shows all my trackers and allows me to open it . the trackers are in ms Excel format. Please suggest me d best possible way to achieve the goal. Thanks Mukul  |
| | Hi, SIR I HAVE A SHEET IN WHICH I HAVE 6 COLUMNS FOR RICE INVENTORY. 1)Report No 2)IN/OUT/PROCESS/Fg(This column show whether Rice In, out,Proceeds & Finshed goods) 3)Product Name 4) In (If In & FG i have make entry of quantity in this column) 5) Out (If out or process …  |
| | I was wondering if anyone can tell me what is wrong with this code in EXCEL. I'm trying to fill in one cell (in this case, K2), based on the wording in an adjacent cell (in this case, J2). If J2 does not state "PENDING", then I want to reference … |
 | Greetings community Excel Errors: Unreadable content error in excel 2010. I have gone to many web sites in the past month or two and not able to solve this error. I dont have a pivot table. I hope somebody will direct me to right solution. Thanks |
 | Hi, I am trying to get Outlook 2007 to work on one account. At present three users have email accounts. Two are working properly. One is not. The not working account opens and then goes into a Not Responding state. It worked earlier in the day. The computer is a … |
 | Machine running Windows 7 Pro 64 bit. MS Office 2010. Problem is once there is a spreadsheet open and minimized and you click on a second spreadsheet shortcut, it won't open. You will get the blue circle so it is trying. You can do it through file/resent files and open … |
| | I try installing office 2013 on my window 7 machine but when i try,it fails and they give me an error message that "Microsoft bootstrapper has stopped working".Please help me out...  |
| | I am creating a software for my company in C#. The working process is like this. 1: we write information in an Excel file. 2: Then we go to the website (Company's customer support page) there is only one search box. and we search after appropriate information. it gives us …  |
| | I'm currently pulling out information from column B in an Excel worksheet + the worksheet name. How would I go about pulling information from column J (which has the same start row/end row as the information pulled out from column B) in the same worksheet and assigning it to the … |
| | hi i have a code here that export my listview items to excel but i want to customize each cell size and i want to format the date and landscape environment Try Dim objExcel As New Excel.Application Dim bkWorkBook As Workbook Dim shWorkSheet As Worksheet Dim i As Integer Dim … |
| | What's the simplest way to read an excel file, get cell 'A1' in table(1,2,3), B3 to table(1,2,3), B6 to Table... import specific cell to table.  |
 | ## Hey Guys ## , I've recently stopped doing some of the projects which I wanted to do and took a look at SQL and came across Microsoft SQL and i was pretty pleased with wha tit can do so i downloaded the program and watched some basic MSSQL tutorials … |
| | Hello folks....it's been awhile but I'm back with a potential nasties issue - my desktop is operating VERY slowly....here's a hijackthis log......can someone take a look and suggest some next steps? Thanks in advance! JD Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 8:38:47 PM, on 7/21/2013 Platform: Windows … |
| | good day.. i have a slight problem in my enrolment sytem. im new in vb programming, and this problem perfectly work in stressing out and pressuring me as begginer. i have a listbox that contains all filtered data from my database. and i want it (all entry in the filtered … |
| | i have an office with 6 computer & laptops fully wi fi connected but i always face trouble of either connection cut or mainly slow network pl .help  |
 | Hi I have access database with two tables With a Relationship i can insert records into the first table with no problems but when im trying to insert a record in the second table i got error message Error message : Syntax error in INSERT INTO statement. - Microsoft Office … |
| | I am trying to apply conditiona formating to shade every other row with a different colour. I am applying the following formula =MOD(ROW();2)=1 and nothing happens, if I use a coma instead of a semi colon I get an error. Can somebody help me. Thank you. |
 | Hie everyone I have the below code on my console to import data from an excel sheet to a mySql database but unfortunately I am having an error which reads: NO CONNECTION TRYING TO RECONNECT.... ERROR 2005 (HY000): UNKNOWN MYSQL SERVER HOST '(ID,NAME):' (11001) ERROR: Can't connect to the server … |
| | Dear All, I'm working on application in C# which needs to filter "blanks" in one column and copy some value from other column instead. Filtering works perfectly, but copying is not so cool.. It copies some lines, but rest left blank. I cant find out where is problem. If possible … |
 | Hi I used below coding for create a excel sheet.I got from on web site. In below coding there is no problem.Its create the excel file.If i run second time,its ask to overwrite the current excel file.If I said "Yes" then it ok ,but If I select cancel button,its generate …  |
| | hello i am using vb 2008 version and microsoft office access 2003.I have installed access 2007 also. while i work in vb,i get error -could not find installable ISAM ,at this code con.open("provider=microsoft.jet.oledb.4.0;datasourse="&application startup path&"vbnet.mdb") |
 | Hello, I am trying to write a macro for Excel 2003 that will allow me to search for two words in Sheet1, copy all the data below those words, and then paste that data in Sheet2. That part I can get to work. My problem is that I have multiple … |
| | Hi CAn anyone help. I have had several incidents of a virus called pianoman that attacks MS documents and adds an extetion 'pianiomancorupt' on all microsoft office documents. No antivirus or virus tool i have tried is helping at the moment. Please help!!! |
| | Please could someone help me with this one? I have developed a small application to call several powerpoint presentations. The user will enter the powerpoint number and the powerpoint will be shown in Viewshow form. However this is not the case. The powerpoints are showing in the normal powerpoint form …  |
 | Hello, My next school project is in microsoft excel. However school are using 2007 and it seems to be rather expencive. Now I could use skydrive/google spreadsheets to do it however it needs to be handed in, in xlsx format. Therefore it would be wise to just get office at … |
 | I already have a php file that catches data from an uploaded CSV file to MySQL but the problem is, every time I upload the csv file, it duplicates the data into the MySQL What i really want is, if I uploaded the first csv file, and edit some data …  |
 | Hi, I was wondering how I might get data from a personal application form (name, address, phone, etc..) sent to me in an email into excel without having to retype or cut and paste. I am open to any idea, I have upcoming membership drive/update and would love to automate … |
 | Hi there, Recently I've started using a client called Tribot which allows me to automate playing a game. The Client has been crashing (for example I was running 8 clients simultaniously last night) and one by one, they crashed over time and produced there error logs in the start-up directory … |
 | I haven't seen this confirmed anywhere else yet. The article starts with >According to leaked internal documents from the German Federal Office for Information Security (BSI) that Die Zeit obtained, IT experts figured out that Windows 8, the touch-screen enabled, super-duper, but sales-challenged Microsoft operating system is outright dangerous for …  |
| | I receive an error message when i install an Office Software or open an Office program or document. |
 | Good Day all, My question is When I get the schema of an EXCEL worksheet with Column headers I get what's expected the names of the columns but when I get the schema of a worksheet without headers I get the first row of data as the Column Names. The … |
| | dear friends, icreated small project to open excel using vb. everything works fine with one exception. i used VB express 2010 in xp OS when developing the project. when it runs on the windows 7 platform the opening excel file goes behind the my application. the VB form topmost function … |
| | Hi, I have some hijacking virus that I can't get rid of. I've tried Malwarebytes, tdsskiller, Skybot, AdAware and Superantispyware, cleaned some things, but it persists. Can anyone help? Below is the hijackthis log. Many thanks for any input. Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 9:00:16 PM, …  |
 | when i click my any microsoft office's product then it start geetting installing. it is installed from 4-5 years and was wroking fine. it happened 10 days before. now i cant open my word, excel or any other file. when i try to unsitall it , it says "this product …  |
 | I've got these two tables on two different worksheets. A1: ID B1: Name C1: Locality D1: ID_2 E1: Status A1: ID B1: Name C1: Locality D1: Status Basically I need to match the two tables via "Name". If the names are similar I want to fill in "ID_2" with "ID" … |
| | Hi, Some one pls help me to read datas from mysql table and update only single field in my table. I have mysql table and already inserted datas. But now i want to update only date field , since i need to place the all other data as it is. … |
| | Hi, Can someone help me. I need to create a VBA project in excel using combo box. For example, I have in column A, combo box of ITEMSA and in column B, combo box of ITEMSB. If I choose items from ITEMSA, just the corresponding items that will match will … |
| | Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go … |
| | A simple timer for Excel VBA Excel VBA does not have a timer control. The alternative is to use the Timer() Function, and that leaves much to be desired. This code should be placed in a code module. My need was to tend to an abandoned program that was waiting …  |
| | I've written a script to alter images in a number of Excel workbooks. In order to properly access the image information, I need to iterate through all Sheet.Shapes on a particular worksheet. I'm having trouble with grouped worksheets. **How do I ungroup worksheets from VB.NET?** I've tried both activating and … |
| | **Hi..I get above mensiond error while converting excel file to pdf please help....** ///Converting excel file into pdf format... string Despath = "D:\\Jaimin\\ExtractData\\"; Microsoft.Office.Interop.Excel.Workbooks myExcelWorkbooks = null; Microsoft.Office.Interop.Excel.Workbook myExcelWorkbook = null; ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); ExcelApp.Visible = true; object varmiss = Type.Missing; object valmiss = System.Reflection.Missing.Value; myExcelWorkbooks = ExcelApp.Workbooks; myExcelWorkbook … |
| | Further along in this code I'm trying to access processRow, which is of type DataRow, but I get a RowNotInTableException This row has been removed from a table and does not have any data. In an attempt to figure out when this data is getting deleted, I added a bunch … |
| | So I must build an app that has to do with mail address management and more. Let's say the user has an excel file with 2 millions of rows (email addresses). I made it the oledb way and the first mistake I made was putting ~500k rows in a datagridview, … |
 | Hello, I am using VBA userform in MS Excel to insert data for database purpose. When I tested it for the first time, it was running okay. But after I saved it and used it again to insert the real data, it happens to repeat/duplicate the data to multiple times …  |
 | HEy guys, I got possible a stupied question but i was wondering... if you are useing microsoft runtime on all of your clients computer in a office of like 150 clients. If i put a package together with MS runtime and current databases will runtime be able to to automaticlly … |
| | Hey guys Im doing some Research on the artical title. Im wondering if it is possible to have an Access database set upfor a company, but instead of installing microsoft office on every client machine, can you create an .EXE excutable file that will access the database that will be … |
| | Hi, This is going to be the least important post you will read, but if anyone can help me, I will still appreciate it. Every fall I have a small weekly football contest with my friends for fun. I have an html file with 20 games on it, players choose … |
 | Good day folks, I've been wondering how can I open an excel file in vb.net. Can somebody help me? I always get this error below: > The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) Thanks in advance |
| | 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 … |
The End.