629 Topics
 | |
 | Hi. In my application I'm using Excel to get some data into an array from a worksheet. Here is my method. public string[,] WorksheetToArray(string path, bool visible = false) { oExcel oXL = new oExcel(); // here new icon appears. if (oXL.Error > 0) { MessageBox.Show("An Error Occurred" + "\r" …  |
| | Here she is! Logfile of Trend Micro HijackThis v2.0.5 Scan saved at 6:52:26 PM, on 3/25/2015 Platform: Windows 7 SP1 (WinNT 6.00.3505) MSIE: Internet Explorer v11.0 (11.00.9600.17689) FIREFOX: 33.1.1 (x86 en-US) Boot mode: Normal Running processes: C:\Program Files (x86)\Malwarebytes' Anti-Malware\mbamgui.exe C:\Program Files (x86)\Extensis\Suitcase Fusion 5\FMCore.exe C:\Program Files (x86)\Intel\Bluetooth\BTPlayerCtrl.exe C:\Program Files …  |
| | Hi Dan, i am looking for something where i click on the button and the excel sheet opens. i have created buttons on the VB excel but i am looking for the coding about how should i link the excel sheet with the command button? please can you help? regards, … |
| | I'm getting an excel range to an array. From my search it was clear I need to use object array. object[,] saRet; oRng = oSheet.UsedRange; saRet = (System.Object[,])oRng.get_Value(Type.Missing); This works fine, but what I really need is for that array to be string. So how might I cast object[,] to … |
| | Hi, so I have a dataset which I am using to create a CSV. When I run the code in debug mode and use the datatable visualiser all the data is shown, however when it opens in excel the last two cells of the last row are missing. I can't … |
| | Hello Sir I want the php code to import the excel data into mysql . pls hel me Thanks |
 | Hi, I hope someone out there can help me. Envision this ... an accounts receivable / accounts payable super simple spreadsheet, to ultimately be maintained by someone who is not computer literate. It needs to be accessible from within the cloud (Google Spreadsheet, some other free SaaS product, etc) with … |
 | Hi guys, I want to create a window application from VB, so that a user can enter the **OLD Power** value in table. Then **line chart** will be created in that windows application. My **Old Power** data already obtained and recorded in Excel. So, in that window application, 1) The … |
| | Hi all, I would like to return an array of String variables from a C++ DLL to a VBA application. My understanding is that: [LIST=1] [*]To do so, the C++ function must return a SAFEARRAY of BSTR. [*]Although Excel uses BSTR containing wide characters (wchar_t), VBA itself uses BSTR with … |
| | We have a shared network drive with excel spread sheets on them, the connect between the two buildings is via a microwave, and every now and then the spread sheets will lock up. Can anyone suggest a budget sensitive solution that could improve the connection, and/or help with the freezes?  |
| | Hi Evryone. I'm new to this group , this being my first post. I have a query which if sorted out could benefit allot. I have searched bt couldnt come to a solution. I just need a direction and a say that "[B] whatever i'm proposing to do is FEASIBLE"[/B] … |
 | hy when i run this command to open excel and i get error (on 2007 excel it was fine) //Excel.ApplicationClass xlApp; Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; SaveFileDialog oDialog = new SaveFileDialog(); xlApp = new Excel.ApplicationClass(); ** xlWorkBook = xlApp.Workbooks.Add(misValue);** xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); int i = …  |
 | Hi Group, I've written a macro to save a copy of the spreadsheet at the end of each day. I tried to test it as a shared file and learned the macro wouldn't work. Is this normal for a shared document? If so, is there a way around this? How …  |
| | Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a … |
| | Hello Group! I am in need of converting a "text" file created by a UNIX based program (it is only semi-formatted) and put it into a more-formatted text (.txt) file. Put a different way, this needs to be converted such that it can be opened in Notepad and it be … |
| | I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets of code that do one or the other perfectly, but I can't make it work. I'm sure I'm just missing …  |
 | I'm a fairly prominent member of the Linux Community as a writer, contributor, and longtime evangelist for the cause and there are a few things I'd like the Community-at-Large to consider on my behalf. These are five things that I wish Linux had. Consider this as my wish list for …  |
| | Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It is creating a text file for us that uses the date, the hour, minutes and seconds that the file was … |
 | Hi Team, I was wondering if I am the only one who is not able to do it or what. Well, as the title suggests, I would like to OPen Excel in vb.net. I was able to find end number of articles online on this but none would help. It … |
| | Hello-- I am not sure where I should post this. I have an Excel spreadsheet with some cells I would like to concatenate into one resulting cell. I can get the cells concatinated, but I would like to concatenate one cell to the degrees symbol, followed by a space, followed …  |
| | I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change … |
| | Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, … |
| | Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a "Run-time error '9': Subscript out of range" error. I have no idea what is causing it. It is stoping at … |
| | I need to install Z tool in MS WORD and use the option in MSWORD  |
| | Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a range of dates in a column to find the row the matching date is on. I have some things that … |
| | I´m having some trouble with my web browsers, both internet explorer and firefox. After around ten minutes or so of use, whatever browser I am using keeps opening itself again and again and won´t stop. The pages open to the homepage. I´ve run adaware and spybot and norton, and they´ve … |
| | hi everyone im really new to report viewer in vb.net and i wanto import the data from an excel file to the reportviewer in vb.net can anyone help me out? here is waht i tried so far: Private Sub ViewReport_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local … |
| | Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 … |
| | I have an excel file that i managed to perform some calculation.It's to know the asset value of bridges in a current year.I have 21 fields in the file.Out of the 21 fields,seven fields are just information about the bridge,the rest are used for the calculation based on various conditions.And … |
| | In my Windows application, I want to create an automation software using C#.NET which works in two steps: 1. Select particular data and copy it from a page of a website. I have done it using web browser control for SelectAll. The data is not HTML data but databound data. …  |
The End.