629 Topics
 | |
| | I am trying to create an Excel sheet and save it in server... Once it is saved, I display a link to the user "download excel". He can click it and then download it.. The pblm is I cant save the excel it says "The file could not be accessed." … |
| | How do I add a Macro to an Excel Sheet using Late Binding? I had the code working using Excel(2010) PIA: [CODE] //create a new VBA control module oModule = oWorkbook.VBProject.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); //Add the VBA macro to the new code module oModule.CodeModule.AddFromString(sCode) //sCode is the VBA macro I created;[/CODE] I now … |
| | I'm using VBA to query and modify an Excel database. The database contains information about servers and their locations. Most of the rack mount servers have the location column as something like "G-05". Those are easy. When it comes to the blade servers, the locations are listed as "G-05E2S09" or …  |
| | Hello, everyone, My question deals with Excel, and not Access, but I understand they should be roughly the same. I have an Excel worksheet which contains several tables. The tables are actually named ranges; basically, I grabbed an area, gave it a name, and -voila!- it is a table. Until … |
| | Okay, so I've been searching the internet for hours trying to find the solution to my problem. Many came close, but didn't describe exactly what I want to do. I have an excel file that displays the names, locations and other information about certain servers for work. I want to … |
| | I have a spreadsheet for each month of 2010 (Jan-Dec) that is used to track church members donations by month. Under each month I have the last name, first name and weekly donation with the monthly donation total at the end of the row. I would like to output on …  |
| | good evening everyone.. im a student and currently taking my thesis...im having a problem with creating a excel file with vb... the thing is I need to open the excel file inside the form in vb.net... Anyone please need help... |
| | hey guys where can i find free office 2010 ribbon for vb.net i found ribbon for c# but nothing for vb |
| | Hi All, I am trying to output an excel workbook that I created else where in the program through a Response.Write() call. The issue I am having is that when I call the Response.Write(); it shows the download dialog for the excel file which it is supposed, but when opened, … |
| | Hi All, I have a small problem that I am trying to solve...It regards storing string values in an array and outputting them to a .csv file. As you know the .csv file accepts inputs delimeted by commas ",", however the arrayed values are also delimeted by commas therefore $arr[$i]="1,2,3"; … |
| | My Excel 2008 literally freezes after one click into a cell. I updated my Mac and I updated my Microsoft Office Software. Please Please Please Help! I really need to get it to work :( -Sarabeth |
 | I want to bring data from certain cells in an Excel workbook into a datatable. The Excel is 97 - 2003 and is in \Box_zero.xls. The code snippet below gives an error "Could not find installable ISAM". From what I see in the literature, this error often means that there … |
| | I’m trying to automatically save an excel file to pdf file using visual basic. So, I will manually open the excel, upon opening the excel file, it will run code to calculate a daily totalizer (this I have functioning) as soon as this code finishes, I want the excel file … |
| | I have been working on several plugins for office. One for Word, one for excel. They are working fine on the developer system however when I try to install the Word plugin on any other machine it doesn't appear to register with Word at all. It isn't listed in the …  |
| | What is the connection string to write for importing mixed data from excel sheet to data grid My problem is, I have rows like 1 2 3 4 5 6 7 8 9 a b c d in excel sheet.But when I imported these rows only 1-9 imported succesfully but … |
 | In my form I have a graphic in a picturebox- simple stuff. My application prints a bunch of stuff to an Excel file- everything works perfectly with no problems. I need the image in the picturebox to print to the Excel sheet. I've tried a ton of code but nothing … |
| | Originally I was using Office Interop to import data, but that was a headache and a half for both me and my computer. Right now I'm attempting to load it with ACE, but my data grid isn't being populated. Once that's up and running I need to know how to … |
| | hi im trying to create a small excel addin in VS2008 byt i cant figure out how to write lika a string or an int to a specific cell? for example: i want to write something in cell B1? how do i do that in the C# code? it must … |
| | I am programing VBA for excel and was wondering if anyone knows where I can fidn the documentation for the selection object. Also do you know how I can get the VB editor to recognize thet object so when I type Selection and put the period after it, it pops … |
| | Hi, I have this code. It is not working properly. Anybody may know the solution? Thank you [CODE]<?php include 'admin_homepage.php' ?> <div id="sidebar1"> <b></b><br /></br></br><img src="MMU_logo.jpg" width="180" height="150"/><br /> <a href="admin_view_student.php" style="font-size:13px" >View Student</a><br /> <a href="admin_new_student_reg.php" style="font-size:13px">Add Student</a><br /> <a href="student_excel.php" style="font-size:13px">Get Excel File</a><br /> <a href="student_mailing_list.php" style="font-size:13px">Get Mailing … |
| | Hi to all! it's my first time to post under the networking category since i'm really on the programming side so pls. bear with my ignorance. I'm just tasked to create a network with a very little understanding of it so here goes: i need to set up a small … |
| | H.i I have a Windows 7 laptop with Office 2007 which I am trying to repair, and getting the above error. I do not have the media, just the Key, so I can not copy files from a cd to the desktop. Can anyone please advise how I can repair … |
 | Hi I dont think I ever untapped the powers of Excel for advanced analytics. Thus, as Im going through these tutorial books, I do wonder what are your tips to help you analyze data quickly and efficiently. Help! |
| | Hi everyone, I need a script that will redirect an excel API from one database to another using VB.net. I am still a novice. I need your help. Thank you. |
| | Ok, here's what I've got. I have a form that exports to an Excel worksheet (sheet1) and it works great, no issues there or anything. It's not a template, just a regular .xlsx spreadsheet, but I use it as my template. Now, the goal is for the end user to … |
| | Hello everyone! Trying to setup a connection to a website to be able to update currently displayed data and push it on a regular basis to my spreadsheet. The link I have is a direct link to download the newly updated spreadsheet. I continue to get an error message when … |
| | HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack |
| | Adding excel data into hash table: [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataTable dt1 = new System.Data.DataTable(); da.Fill(dt1); System.Data.DataRow dr; //System.Data.DataColumn dc; #endregion # region adding excel file into hash table if (dt1.Rows.Count > 0) { for (int c = 0; c < dt1.Rows.Count; c++) { // if (c > … |
| | Can anyone recommend an ODBC driver for Excel in VB 2010 Express? This is a 'legacy' problem having just being forced to move from VB6 to 2010. Any help well appreciated |
| | I want to add first two columns of excel file into hashtable.. I wrote following code but it is giving me eror saying indexing not allowed in datacolumn... [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataColumn dc; // adding excel file into hash table if (dt1.Columns.Count > 0) { for (int … |
The End.