[office-suite] Forum Topics

I want to store the results generated out of SQL query into excel file ... how do I go about doing it? help

I could use some help - please!! I just installed the MicroSoft Office 2004 on my Imac and am now having major issues!! Fist time I started WORD it said all my fonts are corrupt - which i did find a "solution" to - doing a "safe boot" unfortunately since …

When creating a new message Outlook Express defaults to Ariel font at 10 point size. In Tools, Options, Compose I have it set for Mail and News to Times Roman at 12 points, but it still starts out with Ariel 10 points. Is there a way to force Outlook to …

Hello, I am writing a SAS program that retrieves data from an Oracle database and sorts it into multiple SAS datasets. I have been asked to output the datasets in a single Excel workbook with the different datasets on different sheets inside a single workbook. I am currently writing this …

Hi All, When I deploy an VB.NET application to manage documents formatted following Microsoft Office such as MS Word, MS Excell... But I want to store them by database as MS SQL Server or MySQL. Please help me do that. Thanks, Kinh

Have anyone here use MS Express Edition? I'm using VS.NET 2005 right now, and I'm planning to buy MS Express Edition. Please share your expeienced with Express Edition.

I'm having a strange issue with Microsoft Publisher 2003 on Windows XP. The problem is when I try to create a shape or text box, there is no border around it. When I try to customize the border in 'Format AutoShape' the Line Color always stays white, or blank no …

I am reinstalling Microsft Word 2000 and I lost my product key

hello, Could you please help me with the code for how to format a word document by inserting a page border using vb.NEt coding. I have already created the document using vb.Net but now need to insert a page border and a line at the bottom can you please help …

Hey guys how is every1 doing? Listen, here's my story we have a small network, we are using small bussiness server 2003 with exchange server 2003 the thing is... everytime i fix a signature for a user in outlook 2003, suddenly after a few days (sometimes more, sometimes less)... the …

[B]hi all[/B] The Microsoft Jet database engine has an internal limit of 255 fields per query. but my Excel sheet containg more than this. and i have to fetch all the fields of the excel plz help me how can i fetch the data .. [B]thanx in advance [/B]

I am trying to open powerpoint slide through webbrowser using vb6 when i use ppt2003 this piece of code works : WebBrowser1.Navigate2 "D:\Documents and Settings\testers\Desktop\ComparePPT\newgrp.ppt" WebBrowser1.AddressBar = True this opens the ppt file in the web browser. But if i try the same code in powerpoint 2007 WebBrowser1.Navigate2 "D:\Documents and …

Hi everybody, Help PLEASE!! I'm sure it something simple but I can't seem get my mind around it right now. I am exporting [URL="http://database.ittoolbox.com/groups/technical-functional/access-l/copy-excel-sheet-to-a-preexisting-workbook-1428747#"]data[/URL] from a current access form to an excel spreadsheet then I am copying that data to an existing excel workbook where the data will be used …

Hi Ok heres my question. Iam using outlook 2003 and iam able to have a cotomized template for new messages but is there a way to have a costomized template for reply and forward. Thx

Does anyone know how to distribute Outlook Calender Labels to Outlook 2003 clients in an Exchange 2003 environment. We all want to use the same colors for the labels in the Calender items. Thanks!

hi i want to implement auto filter for a column of an excel sheet .. can anybody plz help me.. plz help me.. thanks in advance.. :pretty: :pretty:

Yesterday night, microsoft released a public beta of vista. Once downloaded, it will give you 2 licenses which are good for up to 10 computers each. The licences will last for one year. They have a high demand right now and are bogged down, but you can try later at …

I have a user who wants to organize his sent mail in folders. The catch is he wants to be prompted each time he sends mail, so he can choose or create the folder. For example, if he sends Joe Smith an email about the new marketing brochures, he wants …

guys, i need help in using VB 6.0.can you help me to get a data from an excel file from ms access and put it in ms excel..pls help me guys..:'( here is the sample of the file in access: sum1 sum2 22321 123123 here is a sample of the …

Hi!!! could anyone please help me about querying in excel.. heres the scenario.. i have 2 sheets(sheet1,sheet2) sheet1 = contain the correct answer ex. col1 -- 3333 | col2 -- jose reyes sheet 2 = contains only tha code... ex. col1 -- 3333 (shuffled) (note.... record count is more than …

[COLOR=#000000] [/COLOR] [COLOR=#000000]Hi,[/COLOR] [COLOR=#000000] I have an excel file,having lot or micros, connecting to database, doing some complex calculation..inshot that excel file is itself an application.[/COLOR] [COLOR=#000000] Now I want to open that excel in VB.net form, on button click. I prefer to open that excel in vb.net form itself …

I am trying to write a code that will look through all available worksheets in a workbook and return the data. Currently my code is written to look for specific sheets and it creates an error when a worksheet is added or deleted. I would like a code that will …

Hi folks! I want my users to have signatures. We are using Exchange 2003 and Outlook 2003. Currently we have a complete chaos. Everybody signs his messages like we wants… complete pell-mell. Heads are pressing me. They want users to standardize the signature. Can anybody help me?

Questions: 1. How to create database on MS outlook using VB script/ VBA 2. How to run or to call VBA codes on outloook. 3. How to call personalized .oft file (outlook form template) on ms outlook environment when creating new message. Please help! Thanks!:'(

In Microsoft Word, I have a VBA textbox ("TBox") and some verbiage in a bookmark field ("BMark"). I want to link the bookmark field to the textbox's ControlSource such that the verbiage appears in the textbox (as the textbox Value). I've failed with multiple different entries into: 1) the Properties …

I'm just wondering, does Microsoft Office 2007 Enterprise have a backdoor? Is there anyway to remove it? I'm just curious

guys, can you help me to get data from a text file and putting it in an excel file? my programming language is visual basic 6.0 here is a sample data from the text file: ANO,BNO,TRANSDATE,TRANSTIME,ORIGINS,DESTINATION,CA LL_TYPE,OUTROUTE,INROUTE,CALLS,ACTUAL_MINS,COST 0498373386,[U]006623322001[/U],20070216,16:33:35,SRO,THB,IDD,IBEF7O,,[U]1[/U],[U]0.766666666666667[/U],-0.014413 0498373386,006623322001,20070223,12:59:40,SRO,THB, IDD,0241,,1,0.8,-0.01264 0498373521,0096265522113,20070207,11:22:59,SRO,JO, IDD,0241,,1,0.433333333333333,-0.019717 i wll get the underlined data, then i …

I need to know if anyone can help me with vb code. I have a shared excel file that many users will use. my form writes data in the next available row. But when the users save, a conflict error will ask to replace or keep data in the cell. …

i use thsi code for timer , but it shows the messagebox 50 times.. i just need the mesage box to be showed once only [COLOR=#008000]Dim conn As New OleDbConnection [/COLOR][COLOR=#008000]Dim dap As OleDbDataReader [/COLOR][COLOR=#008000]Dim cmdb As New OleDbCommand [/COLOR][COLOR=#008000]conn.ConnectionString = Provider=Microsoft.JET.OLEDB.4.0;DATA SOURCE= c:\ApptDB.mdb" [/COLOR][COLOR=#008000] conn.Open() [/COLOR][COLOR=#008000]cmdb.Connection = conn [/COLOR][COLOR=#008000]cmdb.CommandText …

Hi, Can somebody help me I am creating a macro in excel and I want to take input from user. user can give address of any column,row,cell and may be insert perticuler value.and after that I work on that data and response Excel User. Thanks in advane

I am using Entourage in Office 2004 for Mac. This is a new program for my home compuer but I use Outlook at work. Although I was not first aware of it, my Sent Items folder is empty. I double checked my Preferences for Compose and have the proper box …

I am having trouble! I set up rules for about 15 folders and they are working fine but when emails come into my inbox with the strike through, after I purge them, I don't know which folder has a new message. I used to get a number in () after …

Even in 1st email from Dani, I could not open the underlined blue items, and had to get the regular web site open in order to even get to ask my question. Cnet might send an email and on their screen showing "go to article" it would make a movement …

I am looking for a simple way to get data from an excel sheet and place it into a combobox (the excel data to be the default selection and the remaining options coming from my mdb database) and then update the cell data once it has been changed on my …

Hi , Some one help me in excel macro If the cell vale is other than 2480, 4465, 3140,2689 i want the entire row to be deleted. regards Victor

I'm keen to write a macro for Outlook 2003, but I can't get my head round the directory structure, (inbox, outbox etc). Where are these stored, on the hard drive or within the program? Any help would be welcome.

Hi guys, As the title explains i've got a problem with archiving in Outlook 2003. I've been archiving the same way for months and its always been fine but whenever i try and archive now, by going to file>archive it comes up with the following message: "Error while archiving foloder …

Hi, Where to compile my vb coding, Now i am opening a excel then doing to Visual basic Editor and compiling my macro. Thanks in advance for your help""""""""""""""""""''' Regards' Victor

Hey All, Working with Excel currently: I'm trying to figure out how to attach the active sheet to an email and send the email. I can save the document out just fine in the format that I want, now I need to somehow copy the contents of the sheet and …

Hi, Some one help me, I want create a new mail message with to address ,cc address and with the subject. I want standard message in the mail also. Please help in this issue. Regards Victor

hi how can i access outlook from vb.net. here the requirement is if i click on the mail button it have to be opened in the outlook please some one help me in doing this or else guide me in some correct way

Hi, Some one hep me, I want to open a selected mail from microsoft oulook in excel format. Will be very help full to me.............. Regards Victor

Hello, I am kind of new to programming in VB (and programming in general). I am trying to program a (what I assume to be simple) action of having a form when clicked open up a Excel Document. I need the path of the file it reads from to be …

I am trying to paste a row of numbers next to an autofiltered row and it will unhide everything and paste into all cells. I have tried to use the Visible Cells Only command but it is only good for copying, not pasting. If you can, i need help to …

Hi I have just started a IT course and know nothing at all about templates. I have been given a task to do, but not a lot of instructions come with it. I am using MS works work processor, and can find the template I want, but do not know …

Hello everyone! I need to do a regression analysis with excel bu one of my two data sets has some data missing because of inability to sample during that time period. Is it still possible to do the regression with the program? If so, how do i go about doing …

I am using microsoft outlook 2003 on windows xp with an exchange server. Anytime I want to reply, forward, create new mail or add something to tasks, calendar, or contacts I get an error message, "The messaging interface has returned an unknown error. If the problem persists please restart outlook." …

I have an old Business Contact Manager file from which I would like to retrieve some addresses. I am currently using Outlook 2003 but I don't have BCM anymore on my PC, so I can't open it. Where can I get that program so that I can read that old …

When I open either word or outlook 2003 I get the following: The add-in template is not valid (C:\...\Startup\~$bRun97.doc) Micrsoft help directed me to Templates and add-ins, however they indicated if this area could not remove the file then it was located in the Startup file. I've been unable to …

Sorry genuinely thick at this and don't like computers. I am lumbered with loads of projects in msp 2002. What I need is a simple code to put a button on an excel spreadsheet per project to access the project and produce a cumulative cost curve for all resources. If …