[excel] Forum Topics

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

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.

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 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 …

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 …

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 …

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 …

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 …

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 …

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 …

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?