[office-suite] Forum Topics

Hello, The code below works almost perfectly except for two flaws: 1. It provides the full name of the file (workbook.xls) instead of just "workbook" 2. If there is more than 1 worksheet then the loop appends the previous worksheet to the filename. For example, Workbook1 has 1 worksheet Workbook2 …

hi can someone help me? I have an excel file and the columns consist of : ID, Name, ContactNo, SalesOutput Sample record is: ID,Name,ContactNo,SalesOutput 123,Michelle Dela Rosa, 8437, 2 456, Anthony Diaz, 8414, 5 What I would like to achive is auto add rows depending on the value in SalesOutput …

Good Morning Everyone, May i know how to extract all data from a excel file and copy the data all over to another excel file? Example from Excel A, we have data EmployeeID Name Department 1111 John MIS I want to copy the data over to Excel B... may i …

Hi All, How can I export data from gridview to excel sheet in ASP.net?

Was updating tags, at some point I got to this: http://www.daniweb.com/tags/tables Is this a caching issue? It's showing "usability" and "excel". I do come across tags in the tagclouds, where the link goes to the "Oops" page (e.g. http://www.daniweb.com/tags/three). Am guessing it's because I removed that tag, but the cached …

Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check …

hello thank you for your good solution but your solution always assume external workbook to be open, how to work with current opened workbook? Dim oxcel As Excel.Application Dim owb As Excel.Workbook Dim osht As Excel.Worksheet oxcel= New Excel.Application oxcel.Visible = True owb= oxcel.Workbooks.Open(Path) osht= owb.Worksheets(1) now I developing add-in …

Hello all, I have created an application in vb.net 2010 on my PC which runs Windows 7 (64 bit). I created a form with a webBrowser container to open docx files, but the method navigate, open the document in a new external window. I would like to open the docx …

can any one help me.. how to export a table echoed in php to an excel through a button ??

Hi, My requirement I need to edit or replace content in the word document every time and save it to another location. What I wanted is I want to simplify this through vb.net but stuck in somewhere I am doing mistake in the code itself (I am completly newbie). I …

guys - most of the export to excel code i've found really doesn't wind up being excel. it's simply HTML w/ a .xls tag on it. and i've done this for years in asp.net, winforms in both c# & vb.net. but it's always a hack. can someone point me in …

I have this routine that works in outlook 2010 but not in outlook 2013 (365). ` Public Sub readTextFile(oFolder As eFolder) If oFolder = NotSupported Then Exit Sub If oFolder = Inbox Then ActiveExplorer.CurrentView = Application.GetNamespace("MAPI").GetDefaultFolder(olFolderInbox).Views("MgInbox") Else ActiveExplorer.CurrentView = Application.GetNamespace("MAPI").GetDefaultFolder(olFolderSentMail).Views("MgSentMail") End If Dim oTV As Outlook.TableView Set oTV = ActiveExplorer.CurrentView …

Hi I have a Help.doc file in my application. How can I open this file on a winform to page 2 (say)? How can I open it to page 2 using a WebBrowser control? 'Microsoft.Office.Interop.Word added Private Sub OpenMyWordDoc() Dim MyWordApp As Word.Application Dim MyDoc As Word.Document MyWordApp = CreateObject("Word.Application") …

Group, I've got a protected spreadsheet at work that prevents me from creating links or writing macro's to do some repetitive copying and pasting from one spreadsheet to another. I hope someone can help. I'd like to use VB (if possible) to copy from a specific range in Spreadsheet1.Sheet1 (let's …

I'm new at this. I'm trying to set up a website. The contact us form gathers info but how do I set up where it goes? The platform is Office 365 on the public site. I'm using Access 2013 as my database.

I import a spreadsheet (csv) into my sqli database (keeps a track of all our firewalls) there are 10 excel columns , one for each connected network on the firewall. i would like all these columns to be imported as one entry in the database, so 1 database field would …

i want the whole excel file has to open in web page n moreover have to enter some input and will hv to **insert/update** based on formulae cells. Is thr any chance to achieve this?

I have a button which make it add data to accees database,but i want to another button which will make export data from access to excel. here is my button : try { string cmdText = "Insert INTO data(Name,Mail) Values(?,?)"; db_conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Alpozkanm\\Documents\\Visual Studio 2012\\WebSites\\IntegratedSubscribeSystem\\veri.accdb;Persist Security Info=False;"); OleDbCommand …

<?php include ('pages/dbconnect.php'); $rekdep=mysql_query("SELECT * FROM t_org ORDER BY dept, com ASC"); echo "<table class='gridtable'>"; echo "<tr><tr><th> Departement</th><th> Commune </th><th> ORG </th><th>Animal</th>"; echo "</tr>"; echo "</tr>"; $odl_dept = null; $odl_com = null; $odl_org = null; while($dep=mysql_fetch_assoc($rekdep)){ //List of department if($dep['dept']!=$odl_dept){ echo "<td>".$dep['dept']."</td>"; } //display blank td if the same department …

I have a template of a contract. The margin on the left holds but half way through typing in the contract the blue line on the ruler at the top that shows where the margin begins moves to the left and blocks all typing. I have used this template for …

I have a column in a spreadsheet labled SEX with the value of 1 or 2 for male or female. How do I calculate the average number of males and females? Or should I use a different value to calculate??

Can i help U ? Need to get information into the Order .

Hi.. I really don't know what to do with my Program, it is needed to have a excel file on MDI Form, But i really don't how to. Can somebody help! Highly Appreciated. : ) Thanks! :)

Hi guys I need your help once again. I can update a record from excel through datagrid but I've encounter a problem where instead updating in number/percentage format(I have columns in number format and in percentage format) it updates in General Format. Example: col1 col2 col3 abc 123.00 100% -------> …

Like what we see in the Microsoft office word, if i wrote "This is abble" will show me a red line under the word. my project is load text file in the Richtextbox and correcting the wrong words, every thing is fine except this thing. so any information or details …

pls help me i need this code to view my excel data in vb6 forms only.

Dear All, is there anyone out there who can help me ? I need to calculate when a server is likely to run out of disk space, before you all say there are applications which do that I do not have access to the server so that approach is pointless. …

If your Excel spreadsheet is laid out as regular columns and rows with a header row that identifies the columns then this code will allow you to read the data using ADODB the same way you would read records from a database table. To try this code 1. Create a …

I really didn't know where to post something like this so sorry guys if this not the right section I have a text file looks like this   I want to import it into Excel file so each info will be in seperated coloumn , even the …

Hi everyone, need some help with outlook. i need to extract information from outlook messages from default folder(inbox) to subfolders(including subfolders of subfolders) but it seems that i'm having problem on calling the folder from the outlook's default pst file. below are the codes i've already tried. outlookfolder = outlookmapi.Folders(folder_name) …

hi i am creating a program that needed an excel app., and i already do it, at first no error, but after a sudden, an error appeal, here is a error. **Microsoft.Office.Interop.Excel.Application' is not defined.** i am still new and still exploring in vb.net. thank you in advance! Any help …

Hello I am using jxls quite fine. I'm sort of on my last lap with exporting my data to a file. However all I want to know is, how do I display my collection in the same row please? I've manage to do this downwards in the same column, but …

Our company use mail exchange server. We have a domain address. From our POP3 outlook email to hotmail users, we cannot send. But we can receive. I looked for in Microsoft website, to change POP3 and SMTP settings. But this cannot solve. We don’t want to use hotmail address as …

i like openoffice much better than ms office, what do you think? After having to use ms word 2007 and other products under the ms office package and vista OS, i started to like non-microsoft products. Thanks to these crap(i dont remember it can be crab), i even started to …

hi! i am creating a program that need to import excel file. i really don't know how to. Can someone help? Thanks in Advance! God Bless!

I have a 31,000 line spreadsheet, that will become a printed book. Based on the current column width (which has to stay the same for printing purposes) there are many lines that are only one line of text, and others that wrap to multiple lines. For some reason, for lines …

Hi I will from the database only copy some textboxes to excel to specifik place in the excel sheet Just those from the database surename,lastname,adress,zip,zipadress,prn only one at the time PS ! the excel sheet is an invoice one textbox to excel i4 = prn one textbox to excel f9 …

Hi What have I done that is wrong the Excell sheet will not be visible I will have it visible when I press the command button Dim objXl As New excel.Application Dim objWb As excel.Workbook Dim xlTmp As excel.Application Set xlTmp = excel.Application xlTmp.Workbooks.open ("c:\kundreg\bokfaktura2.xls") '"bokfaktura2.xls" xlTmp.Workbooks.open ("app.path & \kundreg\bokfaktura2.xls") …

Hi there, I am using Libre Office Calc in my windows 8 PC. I need to maintain a calc sheet for tracking my home electricity meter reading. pLEASE LOOK THE IMAGE. FUNCTION OF CELL A2 = if c2 = "" then value = "" otherwise value = TODAY(). This will …

Hi Champs, Im using VBA for Excel. and Im trying to use the code below to move through records and increment their values by one since they meet a certain criteria Sub promotion() Dim x As Range Dim y As Integer Sheet2.Range("c2").Activate Do While y < 1002 y = ActiveCell.Row …

Hi guys I need help in deleting rows in Excel. What I want is if I delete a row in DataGridView it will also delete a row with the same value. I tried using the OleDb way and I find out I can't delete a row using that so I …

what i am trying to do is make a program to read an excel file that i already have , choose certin columns depending on its header title then paste these columns into sheet2 . the problem is when i check for the columns i want to extract it gives …

Hi guys I'm having a problem in opening excel files using the workbook.open for me to save all the changes made by oledbcommands. Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & path & "'; Extended Properties=Excel 12.0;") MyConnection.Open() Dim i = 0 Dim h = Label1.Text Do 'Dim q = …

I have an Excel spreadsheet that contains names. addresses and various other information. I have word wrap set for all cells in case some new data gets entered that's long. If I sort the data, the data that was in the cells that were word wrapped will end up in …

Hi, I have a VBA script that places WinForm dropdown boxes (xlDropDown) into an excel workbook dynamically. For some reason, on the 17th box (called "INCL" & i + 1 in the code below), the data type of the placed shape becomes msoAutoShape instead of msoFormControl. All of the following …

How can i copy data from a named range in a different worksheet and paste it to another worksheet all done without activating both sheet. With all code just behind a form button If i try to use the statement **application.goto reference:="x"** where x is the named range but this …

I run Office 2003 successfully through CrossOver Mac on my Mac Mini but have encountered a problem when wishing to use Grammar checking with Word. If I open Word with a blank page then I can access and set-up all Grammar and Spelling options but when I open a document …

I am a programmer. That's why I'm receiving a paycheck. I sit alone in a small cubicle and do my work. I don't do desktop support and I'm not interested in working closely with users. So my boss says to me today that I am being signed up for a …

This may require an expert in MS Excel, I happen to have version 2007. The issue involves how Excel is distorting images when placed in a sheet. Imagine this scenario, and maybe duplicate it on your end: 1) I use the graphic borders feature of MS Word to create a …

Is it possible to implement theme of Microsoft Office in my windows application. I mean when anyone changes theme of Microsoft Office it should also make change the theme of my windows application. If its possible, let me know how to do that?