[office-suite] Forum Topics

I have 2 excel files with the same visual basic macro code. The old file macro run fast but the new, macro code have some change in column number to get other detail, run very slow, while it still give an exactly result. How can I make it run faster??? …

Hi all ! I have a .TXT file with around 500 lines, I need to append to each end of the line,right after the last charcter a question mark, I dont want to do it manually. is there an option to do it with Word or another Office component? thanks …

Hi i'm currently in the process of completing a project on midi files and i am having trouble with visual basic programming its the first time i have used it and i am on a dead line. I need to open a midi file as an excel file i am …

hello, i have to open excel file from vb application. i want to update excel file from vb if i modify some value from vb application. but i dont want msg from excel that "Do you want to save changes in this file?" please guide me Thnaks n Regards from …

open office: 1. how to set labels bottom margin? 2. how to set all labels to be right to left typing? 3, 4 followed very frustrated. my labels paper sheet are: A4 105X35 mili each label 2 columns 8 rows 1. there is no bottom margin that should be like …

Hi to all, I have a VB code to draw chart on excel sheet and then export it as a gif image.. The code works fine.... But a progress bar while execution of export function is there.. I don't need that Porgress bar.. Any way to do this, if any …

pls help me.. how do i open a ppt or pps thro vb in such a way that the file name is given by the user, that is the file name is not specified in the code, it will be accepted in a textbox. how do i write the code …

I am banging my head against the wall here. A few days ago, I opened a copy of my resume and word went [i]nuts[/i]. "The macros in this project are disabled. Please refer to the online help documentation of the host application to determine how to enable macros." Fortunately for …

Hi, I have to create Graphical charts and text format reports from Visual Basic 6. This will run as a batch program. The data is extracted from different databases in SQL Servers. Pls assist for writing Graphical Charts and text's into MS word from VB6 Code. Thanks & Regards. Ruth.

How can I track if a received message from Outlook 2003 has been edited? How would I know if a message was edited? thanks.

In the process of reinstalling office 2003 i'm getting a installation error: file not found. A required installation file CR561401.CAB coulnd not be found. Then it ask for the windows disk and when i put it in and put it on the office11 file it doesnt take it. How can …

How do I change the value of a bookmark in Word 97 from VB

Recently bought a new computer after old one crashed. New one is a Dell with Intel Dual Core processor and Microsoft Windows Media Center installed. I reinstalled my Office 2000 Premium software and am trying to update it. When I click to scan for needed updates, it stops after scanning …

Custom form could not be opened do want to oulook form instead. Please assist

Hiii... ALL I Have A Problem For Sending All of my Reports on Mail Which I have Received From Last 6 months So There Are Appx. 160 mails I have to send (Forward) to my Boss. So any one Can Tell Me, Is There Any Way So that I Can …

How will the daylight savings time change effect Microsof Outlook's calendar?

I am trying to control the input of data into a Word 97 document using a VB form to collect the data. How do I then best transfer this data into the correct locations on the document.

Hi to all- I'm new in these parts, my first post. Also, I'm probably the lowest-tech guy on the forum (which will become painfully apparent very soon). I have a power point presentation that I use with clients. After presenting a couple concepts, I have to shift to a software …

Hi All, I have a problem to solve.I am importing 200000 records(.txt) in notepad into excel but when it gets to 65000 records it truncates telling me that not completely exported.I now write a code in vb editor(excel) trying to count every 5records and export to excel.Please, have a look …

When you compose an email in Outlook 2003 you can select VIEW > Options and set Attachment Format to MIME. By default this setting says Default. How can you set this so that every message says Attachment Format MIME.??? Cheers

hello, I am working in asp.net2.0 and C#.I want to create,open a word document on click of button.i am working with ms office 2003,so i added ms word 11.0 library object from com reference. but the namespace microsoft.office.interop.word is not imported. Is their any another way to work with word …

A friend has given me a licence for the above but I can't find a setup for it. Does anyone know where I can get it If so please quote the web address, email, etc :?::?::?::?::?::?::?::?::?::?::?::?::?::?:

I have no problems opening contacts, but when I use the search tool in Outlook 2003 it will find the contact and then tell me "cannot open this item". Any ideas.

Hello! I'm fairly new to VB, but I have some C, C++ background. I'm trying to open an existing Excel Document, and add data in specific ranges from Text box inputs in my VB program. However I cannot seem to be able to do this. The closest I've gotten was …

[B]I am developing a information sharing application in asp.net. I would like to open new MSWorld Document through c# coding in asp.net.[/B] [B]so I have added reference "Microsoft world 11.0", but still unable to import namespace " Microsoft.Office.World;". What can I do for solve my problem. pls help me as …

:)I have the problem that i cannot send emails from my pop3 addresses on my website to any Hotmail accounts,they keep being thrown back. Here is an example of the returned email.>>>>>> [COLOR=SeaGreen]barbarajleat@hotmail.com SMTP error from remote mail [URL="http://help.wugnet.com/modules.php?name=Private_Messages&file=index&folder=inbox&mode=read&p=1107#"]server[/URL] after MAIL FROM:<info@spainisyummy.com> SIZE=3266: host mx4.hotmail.com [65.54.245.104]: 550 Command rejected for …

Hello My Girlfriend has an Exchange e-mail account. Or i should better say 2 accounts. One at a University and another at her new job which she will start full time at the end of the semester. Her University account was easy to set up in outlook express since all …

I am working in visual studio 2005,i want to open a new word document on click of button,for that i have added microsoft word 11.0 than also i am unable to import ( microsoft.office.interop.word )namespace.So any one can help me to import this namespace as soon as possible. Thanks in …

A user is trying to send an email as another user ( they are a delegate with the correct permissions). When they select "TO" they want to be able to view the contact list of the other user. They can view the other users contacts but cannot view them from …

I'm tryin to refernce a cell and use an IF formula to turn the data into what I want to see. any help would be greatly appreciated

I have a seemingly simple problem that I can't seem to resolve. I am using a macro in Lotus 1-2-3 to print multiple worksheets. I have added columns and rows to a few of the worksheets, so I need to modify the printing range in the macro so that all …

Could anyone help me with a procedure to display a timer in xls (e.g a count down)? Also, could you please tell me what event method causes a macro to get executed upon starting a workbook? I want my macro to get executed without the user pushing any buttons. Thank …

Hi, I’m trying to set up a database type program in excel using VBA, you may find yourself asking “why not use access” the answer is the boss wants excel. Believe me every day that I work on this thing I cry, sad…sad little tears :cry: Anyway I’ve got it …

Hey anyone know if it's possible to attach a file into the body of the message instead of up under the attachment bar? It was possible in outlook2000? 2nd Can you creat a view that you're confortable with and then set all folders to that view, I tried creating a …

Hello. Random hyperlinks have been appearing in some of my Excel spreadsheets. I've run virus scans, spyware scans (including AVG AntiSpyware) and they've come out clean. I've also cleaned my registry with Eusing Free Registry Cleaner. Here is my Hijack this log. Please let me know if you see any …

I am using Office 2003 and recently when I open most word documents the view is zoomed to 200%. No matter what I try I cannot get these documents to open in the normal view. Any suggestions?

hi i need to write a function which will accept a datarow array as an argument and generate a report (in excel format) which contains all d data in datarow array....n ineed to return back the path name where the generated report is stored. It would be of gr8 help …

HI everyone, I'm running outlook 2003 (exchange enviornment) and when one of my users tries to send en emial, she gets the following error, "interface not supported" Any ideas? Any advice/help would be great :))

Hi, This is my first post and I'd be grateful for any help. I have a bar chart to which I'd like to add a secondary axis. I followed the instructions in Help within Excel (as well as from other sources) but when my Format Data Series box popped up, …

I just got done trying to uninstall Office 2007 Beta 2 on my WinXP Home system, since I just received my Office 2007 retail software. When I tried to uninstall, it gave me a "Error 1402, cannot open registry key UNKNOWN/.xlb/PersistantHandler" blah blah blah message. It rolled back the uninstalling …

I can't delete a message in my Outlook Outbox with a 32Mb attachment. I accidentally sent it to one of my email addresses and tried to delete it immediately. Now it keeps trying to send repeatedly. All my efforts have failed so far in trying to remove it.....

Hi, I am designing a new template form with several fields of diferent type. Is there any way that when a person press the send button, triggers a macro or something similar in order to validate if all necessary fields of the temlate have been filled ? Thanks, Pedro Redondo

Hi, Using Outlook 2003 Pro, non-exchange environment. Previously I was able to use the tracking on Meeting requests to tell if people had accepted/declined meeting requests. That function does not seem to work anymore. I send a meeting request, and even if the recipient responds, the tracking status does not …

Greetings, Hope I'd be able to get some advice here. My system has been laggy recently - especially with MS Office applicatioins. Thanks in advance. [code] Logfile of HijackThis v1.99.1 Scan saved at 9:28:14 AM, on 1/22/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.5730.0011) Running processes: …

Hi, I am trying to write a VBA macro to save an excel file as a tab delimited txt file which allows the user to input their own filename. The ability to automatically add the current date would very useful but not essential. I have limited VB or VBA experience. …

I wrote a code in VB.NET to access Microsoft Outlook Folders.When I want to see the contents of the Address Book it shows a Pop up box "A program is trying to access e-mail addresses you have stored in Outlook.Do you want to allow this? If it is unexpected, it …

How can we do this in VB.NET? //create two structures to hold our Main Window handle //and the Button's handle HWND WindowHandle; HWND ButtonHandle; //this window's caption is "Microsoft Office Outlook", so we search for it's handle using the FindWindow API WindowHandle = FindWindow(NULL, "Microsoft Office Outlook"); //the Button's Caption …

I have Microsoft Office 2003 Professional Edition installed on my old computer. If I try to load it on my new computer, I can enter the product key and it does install it. When I try to use the programs it says that I have to register it, which I …

I have been using a program that I wrote years ago. It is an Excel sheet that collects data from a MS Access database using queries. Everything was fine until this year (2007) My old queries work but none of my new ones.So I made a copy of and old …

Hey guys, I'm in sales and I'm having a very hard time trying to figure out how to do something in Outlook that I really need to do. I would like to know if there is a way (via customized view or search folder or something) where I can easily …