4,334 Topics
 | |
| | I'm currently have and excel speadsheet that has 3 rows. What I would like to do is create a macro that reads the last populated row, usually will be column A1, and then created a new column listing the current date and time. So for example, I have ColA ColB … |
| | How to export the column data from excel to listbox without using database. plz help  |
 | My Mac address book syncs itself with my iPhone. Somehow (I think through Microsoft Entourage??) it silently added contacts to the address book for everyone I sent/received an email to/from. I now have thousands of contacts that have an email address only with no phone number, and I don't want … |
| | Hi All, I have created Add-In for Outlook 2007, 2010 and 2013 with VS 2010 (VSTO 4) The requirment is to store the Email addresses (FROM and TO addresses) to one table. I can able to get the TO email addresses in Outlook version 2010 and 2013, but unable to … |
| | Hello, My computer has been slow and having problems for the last week or so. A message popped up the other day that my son said something about my internet provider found a threat or something weird. He closed out of the internet quickly, so I never saw it, but … Information Security amazon-web-services api apple apple-hardware audio data-protection file-stream google-api microsoft-office microsoft-windows office-suite pdf printer user-interface vbscript video-card virus-malware visual-basic visual-studio web-browser webcam windows-api windows-virus windows-vista wireless-networking  |
 | Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … |
| | I am using following C++ code to enter a value of X which is used to print out variable CDF. This C++ code is expected to give very similar value we get from NORMDIST function in excel. However I get following error in debugger with out getting any output in … |
| | Since upgrading to Microsoft Office 2007 I now have trouble reading PowerPoint documents from a particular client. Before I upgraded, I had no troubles reading their PowerPoint. Now, I have missing fonts and graphics - so much so that many pages are blank, or filled only with a few dots … |
| | Good Afternoon: I would like to have this JSON object written out to a CSV file so that the keys are header fields (for each of the columns) and the values are values that are associated with each header field. Is there a best practice for working with this? Ideally … |
| | hi, I was trying to download whatsapp for my pc and lots of rubbish came down instead. I have got rid of most of it but now every time I start IE searching.com comes up. Click on mu home page icon and ok. Also I've tried to uninstall all that … |
| | My problem is this: I am trying to automate the download, parsing, and insertion of an excel file into a database. I have the parser and inserter done, but I can't seem to find a way to download the files automatically. The core of the issue is that the website … |
| | Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, some of these cells are changing automatically after the other users open them up. I've read online there may have …  |
| | Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, … |
| | Hi this is scorpionz I am uploading an excel sheet file using PHP Now the file code is working fine for gif files but not working if i provive xls extension Here is the php main code [code] <?php // include 'config.php' include 'uploadcode.php'; if(isset($_POST['upload_file'])) { $user_file = $_FILES["car_info_file"]["name"]; upload_files($_FILES["car_info_file"]["name"]); … |
| | I have a computer that is running Windows XP with Office 2007 Professional. He is having problems only with the Powerpoint files in the office, specifically .pptx files. When you double-click on the file it opens up to a blank presentation. Once that is open if you click open and … |
| | Dearl all, Is there any way or codes for export dataset or datatabe to excel file. Whenever I use click event in the button, it will save my report in an excel file. My information inside in datatable (dataset) from database and I want to save it in excel file. …  |
| | Before upgrading to EXCEL 2010, I am able to open dbf files created in Visual Foxpro 7 or 9 in Excel 2003. I am not sure why after installing EXCEL 2010 I am no longer able to open the file. I get the error message when I tried opening the … |
| | Hello all, Help me to understand how they create deal or no deal game in excel? is that converted? or made in excel? that would be very helpfull. |
| | I am importing Excel into Data Base. I enter in Excel is 9-Oct-2006.I want to get the excel to php file but i am not getting. I am trying this code $date = date('m-d-Y',strtotime($dob)); echo $date; but getting o/p is 01-01-1970 any body help me to get date formate |
| | i want a macro which can find the "$" select all the data and copy it to the next sheet The dollar symbols are dynamic so 1st and 4th dollar symbol will be copied sheet 1, data between 4th and 5th will be copied to sheet2,data between 2nd and 3rd … |
 | Hi all, I am trying to create a script that I can run and edit a user's settings on their excel. IE: the script will edit the user's options by enabling macros and adding in the add-on. Anyone ever work on something like this? |
| | Hi, I need to validate a text input with the rest of the data inside excel file. The following is my code. It just read the text input and only execute data in row 1 only instead of searching other model's data. Any suggestion where did the code goes wrong? … |
 | Hi all, Want to write some data from C# to Excel. Code enough I thought, here at DANI's and on the web. So I managed to come up with this : [CODE=csharp]private void DoExcel(string Fname) { Microsoft.Office.Interop.Excel.ApplicationClass excel = null; Microsoft.Office.Interop.Excel.Workbook wb = null; Microsoft.Office.Interop.Excel.Worksheet ws = null; Microsoft.Office.Interop.Excel.Range rng … |
| | guys, i have a bit of an anomole exporting to excel. on date formats, it seems no matter what i export to excel, it becomes a 24hr clock. for instance the date format thats being exported is stored as:: 03/11/2015 04:26:09 PM - however when it hits excel, it becomes: …  |
| | Hi, hoping someone might be able to help me with a possible infection. A few months ago, I started to notice some mouse lagging whenever I started chrome. I didn't think anything of it at the time because I usually start chrome with 5 tabs and 5 extensions, and figured … Information Security api app-store audio chrome-os data-protection dns google-api home-theater http-protocol microsoft-access microsoft-office microsoft-windows os-x pci-card pdf peer-to-peer printer sharepoint storage user-interface vbscript video-card visual-studio window-manager windows-api windows-virus windows-vista |
| | Guess this is javascript. Similar as in excel, (I have seen this before), lets say I have 3 fields in a form. Now when entering a numeric value in field 1, and lets say field 2 has the value of 5, then the value of field 1 times field 2 … |
| | Hey! Firstly, here's the code: for (Row row : sheetToSearch) { for (Cell cell : row) { if(cell.toString().equals("Oladimeji")){ System.out.println("Found Oladimeji!!"); break; } else { System.out.println("Oladimeji not found...."); } } } What this does is search through the an excel spreadsheet, looking for a name (which happens to be my surname!). …  |
| | Hi I have been experiencing high CPU usage for the past few days. Upon investigation I found out that the iphlpsvc was constantly running at 25% alongwith gpsvc, together putting the CPU usage to frequently 100%. I ran MBAM and AVAST scans I assume they couldnt find anything to fix … |
| | I import excel file and show on datagridview I want insert all row datagridview to mysql. But i receive error: Incorrect date value:'11/14/1991 12:00:00 AM' for column 'Ngaysinh at row 1. Mysql : i using date : yyyy/mm/dd datagridview show : mm/dd/yyyy. i don't know error: '12:00:00AM ' ???? column … |
| | How can I take a copy of the text inside listbox to Excel Sheet or Word Page ? Thank you |
| | Hi! Firstly, here's the code: if(new File("ATM.xls").exists()){ System.out.println("File exists"); } else{ File excel = new File("ATM.xls"); } What I'm trying to do is check whether or not a file exists and then create said file, if it does not exist. This all works fine, but somehow, I'm unable to use … |
 | Hi All I use MS Access to import information from Excel, check for duplicates and post it to an Access data table. The amount of data is making this process extremely slow. I am attempting to move the data tables to MySQL and then running a Stored Procedure to do …  |
| | Hello Everyone, is it possible to create excel file without excel installed on machine in vb6 code? is there any code, dll, link is available? Thanks. |
| | Not sure how to put my code in to excel. 1.#include <iostream> 2.using namespace std; 3. 4.int main() 5.{ 6. const int n = 20; 7. int Array[n] = { 3, 5, 2, 9, 6, 12, 16, 11, 18, 4, 14, 8, 1, 15, 17, 7, 19, 13, 20, 10 … |
| | Good day guys I need help for adding 2 column in datagridview my project is : the import and the varibles are : Imports Excel = Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices Public Class Form2 Friend xlApp As New Excel.Application Friend xlWorkBook As Excel.Workbook Friend xlWorkSheet As Excel.Worksheet Friend … |
 | Hi, how to plot a chart from imported excel in Datagridview? I tried the tutorial from [HERE](https://www.daniweb.com/software-development/csharp/code/492766/display-excel-data-in-a-datagridview), but I do not know how to plot the chart. Previously, I used MS.Access for my Datagridview, then I manage to choose the Datasource. But, for this case, I imported an excel and … |
| | Hello !! I use vb.net with excel I have a buttom "get the name of the column from worksheet" with a combobox thi is the code of the button: Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click Dim Excols As New Dictionary(Of Integer, String) Form2.xlWorkSheet = … |
 | This snippet demonstrates how you can add VBA code to an Excel file at run time. **Prerequisites** In this snippet I am using Microsoft Excel 2013 with the Microsoft Excel 15.0 object library. Before you can use this code, you will have to change a setting within Microsoft Excel to … |
 | I'm printing some strings to the output console to visualise an array, so I'm looping though a string array and using `Debug.Write(array[x,y] + "\t")` etc... All was fine before I went to bed, and the output was fine, like this. "type-b flat three core 29/03/2015 23:34 6 £13.65 wire grade" … |
| | 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] … |
The End.