2,270 Topics
I have an app in VB w/ Excel that uses the Microsoft Solver feature. In order to ensure functionality of the Solver I run the line: Application.Run ("Solver.xla!Auto_Open") when starting up the program. I have now discovered that for some reason, after running this line, a listbox (that is totally …
Hi I have ms-office 2003 on my comp and want to continue using that ... but some of the friends have started using ms-office 2007 (which i dont like) .... so the problem is that the format of excel file is different(.xlsx) and wen they send files i m not …
hi all, sorry if this is the wrong place to post this - i couldn't anywhere more suitable... i have made some fairly complicated diagrams in powerpoint 2007 using line art. i then save the graphic as an emf file and import it into my main word document. these emf …
Hello, I'm trying to open an existing Excel file, and read in some cells. When I run the program to test, it gives me "Compile error: Variable not defined." when it gets to the line: "Set ExcelWS = " (in red). ExcelWB is defined, but not ExcelWS. I followed examples …
I'm writing an app in VB with an excel worksheet. At one point I need to solve a set of equations that are not explicit, so I need a numerical solver program. Excel's Solver is supposedly designed for this purpose; however my past experience is that it is very fickle …
Hi all Im developing one application where i need Ms Exell as my database and vb as fornt end i dont know how to use exel as data base? Plz help me out..... thnx regards.. Pgmer
Hi All, I am need of using a excel file as a standard template and then use a list of .csv files to populate certain rows and columns of this standard template and save it with a different name so that I can always reuse the standard template and it …
Hey all, I have recently become interested in trying to automate various MS Office applications using C++... I was writing some macros in Excel to update some databases that I work with, and decided it would be cool if I could sort of wrap the entire process in a C++ …
>how do you get the band titles to appear on each page of a cross-functional >flow chart? I did not 'insert' page [becuase it creates a seperate tab] but >rather changed my page size to create a continuous flow chart. And the >functional bands are only on page 1. I …
hi, I have to make complex report. i have to join many tables in single report. & when i will click on 1 button that time it should be export to excel. each tables should display in individual grids. in excel within field. is it possible.plz help me
One of our clients is complaining that multiple people are having difficulty opening Microsoft Office Documents (new and old filetypes, .doc and .docx, for example) in a timely matter over AFP or SMB. This occurs in both Office 2004 and 2008. The clients (running Leopard) are accessing these documents from …
Background : This is a quote system that i am trying to improve! Currently i have a Mircrosoft excel database set up that collects all the quote information. My problem: How can i save to a specific point in an excel spreadsheet (for example save directly to c7 without ruining …
Been two weeks chasing this issue - formatting the drive would have been much quicker, but now it is a point of honor. Running Windows XP on a Toshiba Qosimo G 10 (I know already - two mother boards) Media Center Edition Version 2002 Service pack 2 MS Office Pro …
Hi, I've set up two pop3 email accounts on microsoft outlook 2007. For some reason when i go to internet email settings-> more settings->advanced for one of the accounts, i DO get the option to keep a copy of all emails on the server. But for my hotmail account, when …
We have recently determined that people have be altering some of the logs at work. These logs are kept using Microsoft Word on the Microsoft 2003 Office Suite. Other than password protecting the log, is there a way of preventing people from altering entries that have been made? Any ideas …
Hi When trying to open excel files (which could previously be opened) I get the following pop up "Please wait while windows configures microsoft office xp professional with front page" I have never had this before? I am using XP home with Service Pack 2 Any advice Thanks
Hello all, Ok what I'm trying to do is that I have over 400+ .doc and each one is very similar but a little difference and I'm trying to modify only 2 fields that is in every document(which is a revision number and rev. field to enter in more data …
Within Access, I am trying to use code to save a currently open and active Excel workbook to a calculated location and filename and then extract values from various cells. I already have code that can open an Excel file that is at a known location and filename but haven't …
hi, I want to export data to Excel from Dataset and DataGrid and format the output excel file like "Auto Fit" for coulns, Bold headers and also control the Cells. Please dont suggest using Interop Calls. I understand that we can use the RenderControl to write to the [COLOR=#008000]htmltextwriter so …
Hello Everyone, I am encountering a problem, please read below. I have a VB application installed in a system that has MS office 2007. This Vb application generates a word document i.e MS 2007 version. The problem happens here, when this 2007 version word document is sent to another system …
After downloading & installing the latest recommended Windows updates, most relating to MS office 2007 security updates, my pc displays an error box upon startup as follows: Box title: SRV #001 Contents: CLED Error with an "OK" option. While this box is displayed, no mouse movements are able. If I …
An Excel file was saved yesterday with filters set on 4 columns. On opening it today, an error message was issued, saying that problems were encountered in the area of Autofilter. Any idea on the reason? Above all, is it possible to retrieve the data of the sheet in some …
I have Windows XP Pro on my home computer, with Office 2003. Recently, the spell check on Word stopped working and the error message [B]"Cannot find proofreading tools for English(US). If you have the proofreading tools, try installing or reinstalling them..." [/B]was displayed. I tried to see if spell check …
I am interested in buying 5 or more pieces of Office 2003. I am not looking for volume license. Can some one let me know from where i can get it.
Hi all, I hope this question is in the correct area of the site. If not, someone please advise. I am creating Excel pie charts using C# Excel Interop. My problem is that my charts (plot area, I suppose) are never in the horizontal center of the chart area. However, …
Hi There In an Excel Macro. I am trying to install a manual Page break in an IF Statement, if it results in a 'Yes'. What I am missing? Please help. Best regards, Broxy. Sub PM3() ' ' PM3 Macro ' ActiveCell.FormulaR1C1 = "=IF(RC[1]=""yes"", ActiveCell.ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell)" End Sub
Hi guys, One of my users are having a problem with Word 2003 on a XP pro sp2 machine. Whether the user highlights a line of text in a document and clicks on bold every word in the document turns bold, whether its in the highlighted text or not. I've …
I have P4 system and win xp , and i want to use speech option in ms word ( TOOLS--> SPEECH ) , initially ms word asked for cd but after installtion nothing happend , they did not ask me for voice tunning like micro phone ??? how i can …
any one here can tell me this, I am doing the coding like this,, but only excel file is opening not the complete spreadsheet on which i have done work is opening,,it shows path error while running, check n answer to my question coding is below: Imports Microsoft.Office.Interop Imports System.IO …
Sir, i am using P4 system. it was working fine.but yesterday it self something is happend, what happend i am not able to get please can u help me resolve the problem problem is while opening microsoft word (msword) file it converting to some other format after that that text …
can any one help me in the following problem i have created a exe file in visual basic. in my application if i click a command box a excel file will open. the excel file is accessible in my system. but if the exe file is executed in any other …
When I start PowerPoint at work, all of the premade slide templates are there when I start working. When I start PowerPoint at home, the image of each template takes about 15 second to appear in the task pane, so it is several minutes before they are all visible. Why …
I’d like to find a freeware product that will unequivocally reveal the product keys to Microsoft products such as the operating system and Office. Belarc Advisor reveals serial numbers, and not always the product key. I’ve also tried ProduKey, but this will not reveal the product key to Office products. …
Hi, need your thoughts or any ideas/solution behind this weird problem, Scenario: In outlook 2003, a message is saved as draft. User sends email message to a sender(s) but when checked from the sent items list, the “To” field does not show the name/email address that the user sent to. …
Hey I hope someone has seen this before because I have spent way too long in failing to solve it. I am using VWD 2008 express edition. I am trying to add a reference to the Microsoft Word 10.0 Object library. I won't work. I get this strange error: A …
Hi All Does anyone know if when using Outlook switches ( in particular /c ipm.appointment ) it is possible to set the subject line and and message body ? Thanks
Hi Im currently using MS Office Outlook 2003 with my ISP service provider's email (my_email@shaw.ca). I recently signed up for a gmail account (my_email@gmail.com) & would like to access my gmail account with Outlook but I would like my gmail acount to have its own seperate folder, just like the …
Perhaps someone can help me... I'm trying to figure out how to transfer Access data to Word documents so that the data for each contact will transfer with a command. Does anyone know how to do this?
Hellow every one I need to embed office word editor in my web page as activex control (HTML Editor) so any one has idea about how to implements such thing please let me know Regards
Spell check acknowledges miss spelled words but the suggestions are grayed out. I have tried a detect and repair of Office. I even went as far as reformatted the hard drive and the same thing when I install Office 2003. Any ideas on how to fix this?
Hello, I am new to the community and was hoping to find an answer to my problem. I have created a few powerpoints in 2003. I followed the same routine as in the past, however when I save as webpage the placeholder is darker than it was before when I …
My client suddenly cannot sen or receive emails with his POP email accounts. I reviewed his inbos and other folders to bad or large emails to delete but ther really isn't any. I removed both emails accounts and recreated them them one at a time but that did not fix …
I have Microsoft Outlook 2003. When doing a "reply to all", it automatically puts my e-mail as one of the recipients. This doesn't happen to my colleagues. Do you know how to stop this? Thanks so much! Lisa
I am a novice and I need some big help. I can no longer use IE as no matter what site I try to access I am redirected to either "http:///" or "http://ca.search.yahoo.com/search?p="NAME OF SITE ENTERED"&fr=chr-nick I downloaded Hijackthis and the following is the scan results. Can anyone please help …
good day peoples i am james higgins i am currently microsoft office certified in word powerpoint and excel i plan to go and get vocational training in A+ and mcse certification i already know some things about fixing computers and will post a problem with a computer i have at …
HI I see by looking at these threads that I am not alone! However, this doesn't make it any less irritating. I would really appreciate any help to get rid of this! Here is my Hijackthis log: Logfile of HijackThis v1.99.1 Scan saved at 10:08:07 PM, on 2008/03/19 Platform: Windows …
ok bare with me here, not sure if this is the correct forum section but I will give it a go. First some background. Some time ago I signed up for Microsoft Office live business website...it was free and all that good stuff so i went with it. I ignored …
Hi all, Have a slight annoyance with outlook 2003 shared calenders. Permissions are set for a particular user to view around 4 calenders and edit etc however when she goes to view the calender she can do so but it doesnt put the persons name onto the calender when viewing …
I have a user on Word 2000. She regularly inserts jpeg files into Word. This has worked fine in the past. Today, it would not insert the image. Instead it would just insert the image file name in place of the acutal image. I've tried inserting/copy, paste from the camera …
macafee managed to lock up my computer, and outlook express. When I'd uninstalled it and finally got back into O.E., I found all my folders moved to Windows explorer, and I can't move them back, or open them. Move commands don't do anything. Any ideas? Thirdrail
The End.