[office-suite] Forum Topics

Hi all I am newbie to VB.I want to append text file data to an already existing excel file. Following is the Text file:: [code] BARCODE|TITLE|PRICE|CUSTOMER_FIRST_NAME|CUSTOMER_LAST_NAME|CITY|STATE|ZIP|PURCHASE DATE 111111868167|Dead North Friday Night OCT 10th |18.5|Amber|Follensbee|Windsor|VT|05089|08/07/08 11:30am 111111868177|Dead North Friday Night OCT 10th |18.5|Amber|Follensbee|Windsor|VT|05089|08/07/08 11:30am 111111868187|Dead North Friday Night OCT 10th |18.5|Amber|Follensbee|Windsor|VT|05089|08/07/08 …

Is there any way to identify the specific instance of word that a vb.net applcation creates [code] objWord = New Microsoft.Office.Interop.Word.Application objWord.Documents.Open("C:\TestFile.rtf") objWord.Visible = True [/code] In the text above how can identify this instance of word to close it after a specific event or period of time.

Hey everyone, I am wondering if it is possible to open a word template in the open document. I am running Word 2007 and I have created a new Ribbon tab with a bunch of macros on it and basically, I want to be able to have a button on …

Hi folks ... im in desperate need of some assistance. Somehow (all of a sudden) my Office 2007 doesnt work and I get the following message when trying to open Word, Excel etc... "The command cannot be performed because the dialog box is open. Click OK, and then close open …

Hi, How do you restore all the settings to default in Office 2007? Thanks

I recently updated and uploaded my website -http://www.chadwickenddominoes.co.uk - via my webspace on Tiscali. I use Microsoft Office Publisher to build the site. I can view all six pages in Mozilla Firefox with no problems. Now someone using Internet Explorer browser tells me they can only see the first page …

Hi, I'm having problems with the Citation and Bibliography function in Word 2007. When i add a new source (using the Manage Sources button) it adds successfully but I get no preview of what i've just added. Just a message saying: "Citation: Invalid Source Specified" When i try and insert …

I get Object variable or With block variable not set error message all the time whenever I open the word document and save it. I search on Google but people are talking about Visual basics. I need to troubleshoot this word 2007 error 91 message. Any help would be appreciated. …

Hi all. I have a worksheet with col A populated by reoccuring numbers (LINES), and col B by unique text (VARIANTS) ... A B = = 2 Bananas 6 Oranges 3 Apples 3 Grapes 6 Pineapple 2 Strawberries 3 Kiwi etc In another worksheet I have a cell which drop-down …

I did create a very simple basic table in Ms Word 2003 with 2 colums/2 rows like (Insert Table of 4 columns, 2 rows) Pref. Settlement Method Test1 Test2 Test3 Face Value of Settlement 50 60 70 Then imported that table in Power Point. Problem: In power Point (version 2003 …

I have a friend who is trying to copy a pdf file witch is written in Greek to microsoft world and the Greek fond changed to something i don't know how to explain it, :) not language anyway i hope you guys understand. :) Thank you

Can anyone tell me if there is a way to add Access to a purchased copy of MS Office 2003? It is a company pc with only MS Office standard installed and since this version didn't come with Access I would like to legally install it. Does anyone know if …

Hi I'm using MS Word 2003 on PC. I am creating templates for letters and reports that I want other staff members to be able to open - but not change the template. I want them to be able to save a copy, and be able to make edits in …

When making a chart, is there a way to change the x values? I want them to be listed as dates instead of just 1, 2, 3...

I am making a spreadsheet for work. I have multiple worksheets in this particular file. How do I make it so I can just update one spreadsheet and it automatically updates another one?

I need help in Outlook, some of my user’s connection to Outlook while they are connected to Exchange server will receive a message saying that connection to server has been disconnected and then few seconds later user will receive that connection to server has been restored. Please help

I am using Word 97 with the Office 97 Suite to manage my small business. I have encountered a problem, which persists. I can start a new document or open an existing document and edit it with no problem. In a window at the bottom of the screen there is …

Hi, I can't get Outlook 200 to load - for no apparent reason - I get the flash title screen and that's it, and the only way to close it is CTRL-ALT-DEL - all other office apps seem to be fine I have already done the following renamed the pst …

Help Badly needed here! I am trying to find a macro that will do the following: Copy the value of a cell M6 for all worksheets in a workbook, and paste them to a new workbook but the cell value for each worksheet of the original workbook should be pasted …

Hi there, I hope that there is some out there able to assist with my query. I make back-ups of all my software programs. Just in case something goes wrong with the CD's. I am now trying to install Microsoft Office 2007 on my computer, but the installation keeps on …

I insert AutoText entry, and it disappeared. Word

Hi I've a WindowsFormsApplication project and I wanna use Office components in it. For example, Consider the PlainTextContentControl which belongs to Microsoft.Office.Tools.Word namespace. (i.e. As we know this component is in the "Word Controls" group of ToolBox.) I added the above reference to my project, but this component is not …

Hey all, I had a project assigned today and I need to complete in 4 days..A part of that project requires me to create a user online registration form..All user information needs to get saved in an excel file. I have never done this before.. I know how to save …

I have two seperate word files set up in tables with the information in chonological order. How can I combine them into one document (in one table) that combines the two in chonological order?

Hi, I want to search an excel sheet with heading columns. There are Hotel code, name, address etc. I want to search at specific hotel code and get their details. Please help me out in this matter. Thank you in advance.

Hi - Can someone please help me? I have a html table generated by php mysql and have a header to download it to excel. My problem is, I have this cell/table data that displays .10 in html and when I exported it in excel it displays as 0.1. The …

In word automation, how ca i retrive and save images from a word file's header section. I can get the counting of header section's images but want to save them or extract them into jpg format onto my harddisk. I m using "Microsoft.Office.Interop.Word" dll. Code is : ------ [code]object oMissing …

I bought this computer new, several years ago, with ME and have since installed XP Home. When I open Word, it starts the install and asks me to insert the CD. I didn't get a CD since this was bundled by Comp USA. If I cancel the install Word will …

Last week I received a document that the author had trouble sending. Since then, whenever I switch language usage or insert the date automatically into a document, I get the message "Buffer Overflow" and the document I'm working on has to be closed. Full virus/malware scans (Panda) have not come …

Im looking for a microsoft excel example. I found this here [url]http://www.daniweb.com/forums/thread102795.html[/url] but dosent give a small example of code in work. What I gathered from the above thread was: - You cannot write to xls extensions (What about xlsx 2008 office? & can you write to xls?) - Each …

I typed in some text and would like to draw a box around it to fit the text. How do I accomplish this? I've gone into MS Help and tried just about everything, but cannot seem to figure it out. I tried the rectangular box but cannot resize it to …

I've been trying to run an SQL script using an Excel macro. There are hundreds of records (one coumn - Item numbers) returned, and I would love to have the results start at C3 in the Excel worksheet and propagate down until all of the records have been added to …

Hi All, I have a shared excel sheet which is simultaneously used by couple of users placed in a network share. At certain instance of time I want to know who all are using the Workbook. You would say goto Tools-> Share Workbook. Instead I want to obtain the list …

hi all, i am working on a windows application. In that i have to open a saved text file using a open dialog box and load it into the word document..i am not able to load a text file to word document. what can i do for this? Thanks in …

Whenenver I try to Save the Excel Workbook after editing the content by using this Code "xlwbook.Save", It always ask whether to replace the existing File or not. Is there any way to avoid this message? What shall I do to close the workbook silently (not seeing the Message). I …

I have installed ms office.Now i want to remove it from my computer,I removed other tools but couldn't remove ms-exel and ms-word.when I click to remove in my [B]add or remove programs'[/B] list,it says "[B]The language type is not supported by your system[/B]",I also used ccleaner to remove,but couldn't get …

Hi I'm using MS Visual Basic 2005 Express Edition and need to open an Excel File. I'm using the following code [code] Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim xlTemp As Excel.Application xlTemp = New Excel.Application xlTemp.Workbooks.Open("C:\Documents and Settings\TAP\Desktop\Post\Test.xls") End Sub …

I am exporting data to excel but inserting rows is very slow about 2 seconds per row, the line of code I used sucsessfully in VS 2003 was "oSheet.Rows(oRow + 1).Insert()". I am now using VS 2008 to excell 2007 and as well as the previous code I have tried …

hi, I open a Existing excel sheet and do something and then want to close this excel sheet and open a new excel sheet and work on it. Code:manip.vb OpenFileDialog1.Filter = "Excel files (*.xls)|*.xls" If OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then ExcelDoc = New ExcelEx(OpenFileDialog1.FileName) Else Exit Sub End If ExcelDoc.close() GC.Collect() …

hi, I open a Existing excel sheet and do something and then want to close this excel sheet and open a new excel sheet and work on it. Code:manip.vb OpenFileDialog1.Filter = "Excel files (*.xls)|*.xls" If OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then ExcelDoc = New ExcelEx(OpenFileDialog1.FileName) Else Exit Sub End If ExcelDoc.close() GC.Collect() …

I have the code for transferring data from the datagridview to the excel spreadhseet.. my datagridview has colored data in it and I want the excel spreadsheet also to have the colored data. i get the error "property access must assign to the property or use its value vb.net error" …

well recently I had to repair my windows and now I'm unable to access outlook; [code] The application failed to initialize property (0xc0150002). Click OK to terminate the application. [/code] If anyone could tell me how I can copy the emails to a removable usb drive or a way to …

I am trying to open an excel spreadsheet using vb.net. The data has to be fetched from a datagridview.. the datagridview has colored data in it and i want it to appear colored on excel spreadsheet too.. How do i get it colored ? [CODE] Private Sub Button4_Click(ByVal sender As …

Hi there, I am new to this site and a little lost, so to speak. My name is Jaco and I am from South Africa. New to computer technology and used to work for a company dealing with SQL and reporting. I used to write the company reporting from SQL. …

Hi I'm new to Visual Basic and writting code for excel. My first attempt at writting a piece of code is to format a range of cells to display a particular date and time format. dd/mm/yy hh:mm. My problem is that I have written the code that uses a drop …

I share my laptop with the GF and she uninstalled some Java items from it. We have an old IBM thinkpad wih Windows XP and we seem to have lost Word, Excel and probably a few other ms applications. I have spent a couple of days searching the web and …

Hi everyone I'm having a problem trying to load a VBA program through C#. I'm creating an application in order to load Excel (so far so good), and I can even paste some information from one of my arrays in a spreadsheet.... My question is, how can I run a …

This involves an Excel file that is being controlled by another program. I have written my own excel file with vba that works with this Excel file. So basically, the program opens up an excel file, then the user opens up my excel file in the same instance of the …

Hello all, I bought a new HP slimline with Vista. I installed Office 95, but found out it wouldn't open files I created with a later edition. I tried to uninstall it, but the software won't uninstall. I did have a Office 2002 Cd, so I tried to install that …

Hi FOlks can any one share the code snippet of opening any format of microsoft office document in IE browser, on a click of a button Kindly do share the JSP and server side eventing too.. Thanks RK