Search Results

Search found 6489 results on 260 pages for 'office automation'.

Page 47/260 | < Previous Page | 43 44 45 46 47 48 49 50 51 52 53 54 | Next Page >

Office Interop addins installer?

- by jimbojw

I have three C# Solutions in Visual Stuido 2008, one each for Word, Excel and PowerPoint using interop to hook various events. In each Solution, I have exactly one class, the one created by default when using File - New - Project - Visual C# - Office - 2007. Now that I have my addins working properly, it's time to create an installer. I understand that I may also have to distribute the PIAs. I would like my installer to register itself such that it can be uninstalled via the normal Add/Remove Programs mechanism. My organization is somewhat standardized around WiX for creating installers, but I'm open to any suggestions. How do I produce an MSI or EXE capable of installing my addins? GUI/wizard for the installer is not necessary. I'm happy to RTFM - so far all the tutorials I've found only explain how to create the project and do some of the coding. Maybe I'm using the wrong search terms? Thanks in advance for any help!

Read the article
Microsoft Office Access error

- by CREFLY

Hi All While I am running on MS Access myapplication.mdb, I am always getting this error "Microsoft Office Access Has encountered a problem and needs to close. We are sorry for the inconvenience, send error to report , don't send...". I tried to create a new application.mdb then to import the database, the form and the modules but I couldn't because I'm getting the same error while I'm importing most of the modules. P.S.: I'm trying to import the modules one by one but for the majority of the modules I encounter this error. I tried to open an old version of myapplication.mdb then to import the updated modules but just when I selected the damaged application to import the updated module I got this famous error directly... Any help will be highly appreciated...

Read the article
Trouble with creating WPF window extended on the title area (like Office 2007/2010)

- by Rikker Serg

I want to make WPF window extended on the title area (like Office 2007/2010). I implemented DwmWindow (see DwmTest.zip) where I put required stuff. Commonly, it works fine except one disgusting thing: the window appears as white rectangle (see DwmIssue.png) and after a few second this rectangle disappears and the content of the window is shown (see DwmIssueCorrect.png). This bug is essential only for my window. If I remove this lines it works fine (without it aero will not showed on title): HwndSource mainWindowSrc = HwndSource.FromHwnd(handle); if (mainWindowSrc != null) mainWindowSrc.CompositionTarget.BackgroundColor = Colors.Transparent; NativeMethods.MARGINS margins = new NativeMethods.MARGINS(0, 50, 0, 0); NativeMethods.DwmExtendFrameIntoClientArea(handle, margins); How can I eliminate this white rectangle? (To run a sample DwmTest.zip WinVista/7 with DWM enabled and .NET 4.0 is required. To compile sample you will need Visual Studio 2010)

Read the article
running Hadoop software on office computers (when they are idle)

- by Shahbaz

Is there a project which helps setup a Hadoop cluster on office desktops, when they are idle? I'd like to experiment with Hadoop/MR/hbase but don't have acces to 5-10 computers. The computers at work are idle after hours and are connected to each other through a very high speed connection. What's more, data on these computers stays within our network so there is no privacy issue. In order for this to work I need a fairly light weight monitor running on each machine. When the computer has been idle for X hours, it will join the cluster. If the user logs on, it has to drop out of the cluster and return all CPU/memory back. Does something like this exist?

Read the article
Excel file reading with 2007 office connection string.

- by p-vasuu

Actually in my system having 2007 office then i am reading the 2003 .xls file with using the 2007 connection string string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Filename + ";Extended Properties=\"Excel 8.0;HDR=YES;\""; data is not reading. But if the first row first column data length is lessthen 255 then the following first columns data is cutting up to 255 character. If the First row first column is morethan the 255 character then the following first columns data is reading fine. Is there any back word computability is there?

Read the article
C# exporting e-mails to excel on widndows forms using microsoft.office.interop.excel

- by shin

I need to export some data to excel in my forms aplication, so i used microsoft.office.interop.excel and everything is ok except one thing. When exporting client's email I would like to make it an mailto: link. excellApp.Cells[row, 16] = "mailto:"+client.Email; doesn't work Whend I add hiperlink when exporting www field it looks like this: excelWorkSheet.Hyperlinks.Add(excellApp.Cells[row, 14], client.Www, Type.Missing, Type.Missing, Type.Missing); How can I export an email to have similar effect coz right now I have only simple fields withou any action...?

Read the article
OpenOffice/Libre office xml filter import

- by marechs

I'm using OpenOffice to convert documents to pdf/xls; Main system where usually is running Openoffice is Linux; There(in openoffice) is such thing as XML filters; A have package of those filters and usually to import this package I using(from launched openoffice): Tools-XML Filter settings -open package; It's like little converting server, but there is one problem - system needs X server to be running; So is there a way to import this XML filter package to Openoffice(or Libre office) from command line?

Read the article
Programming in a noisy office [closed]

- by John Isaacks

Can anyone recommend any techniques or advice for working in a noisy office? I know some people wear headphones and listen to music but I prefer silence. I work in a room with 4 others, there are no walls between us, we just each have our own desk. There is usually always someone talking, or on the phone, or on the intercom. Has anyone else had to deal with this? What did you do? What would you recommend?

Read the article
Can't change text color in Microsoft Word 2010

- by Wesley

I have Microsoft Office 2010 32-bit running on Windows 7 32-bit. When text is highlighted and a color is selected from the mini-toolbar or the ribbon, the text does not change color. If I change the color for multiple words, and select a different color for each word, the toolbar and ribbon will reflect each of the different colors that I chose, however it is not displayed in the document. So it appears that Word is aware of the text color and not as if it is simply not applying the change. What may be causing this inability to view text colors and how might I fix it? My only troubleshooting attempt so far has been to perform a repair installation of Office. EDIT 1 I created a document, typed a word, selected it and changed the color. I then saved the document as HTML. The text did not change color. This is the HTML in the document: <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> <meta name=ProgId content=Word.Document> <meta name=Generator content="Microsoft Word 14"> <meta name=Originator content="Microsoft Word 14"> <link rel=File-List href="Document_1_files/filelist.xml">  <link rel=themeData href="Document_1_files/themedata.thmx"> <link rel=colorSchemeMapping href="Document_1_files/colorschememapping.xml">  <style>  </style>  </head> <body lang=EN-US style='tab-interval:.5in'> <div class=WordSection1> <p class=MsoNormal><o:p> </o:p></p> <p class=MsoNormal><span class=GramE><span style='color:red'>blah</span></span><span style='color:red'><o:p></o:p></span></p> </div> </body> </html> EDIT 2 I recorded a macro and did the following: Typed a word Selected the word Changed the color. Oddly, I had some strange issues while the macro was recorded. I could not select text with my cursor. I had to select the text with control a and then apply the color change. I then couldn't deselect the selected text. Nonetheless, the text showed that it had a different color in the toolbar, but the color did not display in the document. Here's the macro: Sub Change_Text_Color() ' ' Change_Text_Color Macro ' ' Selection.TypeText Text:="Test Text" Selection.WholeStory Selection.WholeStory End Sub EDIT 3 I opened WordPad and created some text and was able to successfully change the color. If I copy and paste the colored text into a Word 2010 document, the color is lost. However, if you place the I-beam in the text and then look at the color selection drop-down menu on the ribbon or mini-toolbar, you can see that the proper color that the text should be in is highlighted. Edit 4 I uninstalled the entire Office 2010 Suite, rebooted and then reinstalled the suite. No change in behavior. Edit 5 Text cannot be colored in Excel either.

Read the article
Automatic incremental SQL Script generation for incremental, nightly builds when using Team Build in

- by Steve Johnson

hi all, hope that everybody here is OK. We are using VS 2008 as development tool, TFS 2008 as version control as well as build automation. Some of our developer use dbpro for databases changes and some use SQL Server management studio. I am trying to automate build for Web Application built using C# and VB.Net. Our scenario is such that we have a central database to which our web application connects. Whenever we supply our clients with a new functionality or a bug fix, we supply them incremental builds. The SQL script is checked into source control for every incremental build when they have made and tested there changes on our central DB Server. I want to generate Differential script that can be run at the client as an incremental update script. Now to come about it is a problem. Sometimes our developers tend to forget the database change-sets and the script in the source control is missing an SP or a two. Also, sometimes we need to insert default data into some of the tables that have strict stringent values and not test values. Like a table that contains Services provided by the panel, we add a new service name, signature, credentials and service address, etc etc in the ServiceTable. Besides this many other tables may have test data that may not be needed. If we use DataCompare, it will generate changeset for required data (important for client to enable certain services) and our test data that was added to the database as a result of our testing of the functionality or bug fix. Currently i am using SQLSchemaCompareTask (from Visual Studio 2008 Team Database Professional Power Tools API) in the TFSBuild.proj file of the build definition for TFS 2008. Using SQLSchemaCompareTask, the script generated contains database names like [dbo]. etc which are not desired as the script fails when run against SQL Server 2000 databses (Some of our client still use SQL Server 2000) databases as teh backend of the application. Also default data can't be generated by this process. To overcome this problem, i have to come up with a solution that can compare databases and generate script automatically that does not have to be manually reviewed again before being sent to the client. Please suggest effective methodology of such SQL script generation and suggest whether two different databases may be used or something ? Is there any toolkit or api that can enable build automation for SQL Server databases? Thank you all. Regards Steve

Read the article
Can't Set Crystal Report Selection Formula Programatically

- by eidylon

Hello all, first, I can't stand Crystal! Okay, that's off my chest... Now, we have an old VB6 app we maintain for a client, which uses the Crystal Automation library to programatically change the record selection formulas in a bunch of Crystal Reports 8.5 reports. There are two reports which are ALMOST identical. I had to change them recently to add another field from another table. When I added the table in to the reports though, while it added it in the visual designer, it did not add it in the FROM clause of the SQL statement. So, I manually edited the SQL statement to add in the additional join. KO, works great. If i run the reports in Crystal preview mode, they work exactly as expected. Now, the users went to test the changes from within the VB app. One of the reports works fine and dandy. The other report however, is failing to set the selection formula as expected. The code sets the selection formulas using the function PESetSelectionFormula. I verified that the string being passed in to the function as the new selection formula is correct via a step-through examination of the variables. The call to PESetSelectionFormula seems to be working okay, and is returning a value of 1, which as near as I can find anywhere indicates success. (The other report, which is working fine from code is also returning 1.) However, the report is failing with an error: Error Code: 534 - Error detected by database DLL. The code, for debugging purposes dumps out the SQL string currently being used by the report. The SQL coming out of the report is: SELECT ... FROM ... WHERE ORDER BY ... As you can see, the WHERE clause is blank, which I would imagine is why the database DLL is upchucking on this statement. I don't understand why the automation library is not setting the WHERE clause even though the call to PESetSelectionFormula is being passed a valid string and is returning success. I thought perhaps it was because I had manually edited the SQL in the report to add the table it wasn't adding, but I did the same thing in the other nearly identical report, and that one is working fine. Anyone have any ideas why PESetSelectionFormula might report success but not actually do anything? P.S. I have already tried doing a Database Verify Database from the menus, and that said the report was all up to date and did not help at all.

Read the article
Windows Batch Script Question

- by Scott

So I need a Windows Script that I can tell it a directory to go through and it will parse all sub-directories and while in each subdir, will archive all files with a certain file extension and keep it in the same subdir, then move onto the next one. What's the best way to go about this? Perl Automation Scripting, AutoIt? Any sample code you guys can give me?

Read the article
How do you write your QTP Tests?

- by Josh Harris

I am experimenting with using QTP for some webapp ui automation testing and I was wondering how people usually write their QTP tests. Do you use the object map, descriptive programming, a combination or some other way all together? Any little code example would be appreciated, Thank you

Read the article
Sharepoint Wikis

- by Keng

Ok, I've seen a few posts that mention a few other posts about not using SP wikis because they suck. Since we are looking at doing our wiki in SP, I need to know why we shouldn't do it for a group of 6 automation-developers to document the steps in various automated processes and the changes that have to be made from time to time. Thanks.

Read the article
WndProc(ref Message m), Prevent minimize Games, Send key strokes.

- by Stanomatic

Overview: I am going to create a touch application that interfaces with games and other apps. This concept is similar to the app found on touch-buddy.com but I will be using C# and WPF instead of how the application is written in Perl. I have a few challenges I would like to evaluate. The touch-buddy app uses two approaches while interacting with games; 1. Client mode (Same machine runs both game and touch-buddy). 2. Server / Client mode where a separate box sends commands to the game machine. The reason I believe for this method was to circumvent the issue with games minimizing. In Client only mode I am faced with the issue where I touch a screen OTHER than the main screen where the game is viewed and then the game minimizes. Not all games have this behavior but I would like to conquer the games that do minimize and prevent it. Is it possible to keep a game front and center Focused and prevent minimizing utilizing C# WndProc(ref Message m)? I have been experimenting with WndProc(ref Message m) where I created a win form and when I press minimize on my own Win form and it will close an instance of notepad. This proves to me that I can capture a message, prevent that message from bubbling up and then send a message to another application. I then tried to click on notepad with my touch screen and keep my win form application in focus and not minimize. At this point I am unsuccessful. I need more time understanding message codes. Is this the right approach? Can it be done? Should I look at other libraries such as Windows Automation? Key input is my other concern. What is the best way to send key strokes to other apps/games. Should I tap into DirectX, use some kind of send key, Automation Framework? Can any of these handle the multiple key strokes that some simulation games require? I appreciate any links and or insight you may have. If you have gone down this path for any reason I would love to hear your comments. Stan

Read the article
Watin: file upload ...without file selection window?

- by user526186

with "file upload" HTML like this: <input name="input_name" type="file" size="40" /> ...there is no way for users to directly enter text into input area for security reasons, correct? file selection window pops up instead. In Watin automation project, we are wanting to bypass the file selection window and place filename directly in text entry area - but we are not finding a way to do this. How can this be accomplished? ...or perhaps it cannot be done?

Read the article
Les périodes de publication d'Office 15, IE 10 et Windows Phone 8 connues, la roadmap de Microsoft dévoilée accidentellement

Les périodes de publication d'Office 15, IE 10 et Windows Phone 8 connues, la roadmap de Microsoft dévoilée accidentellement Les probables dates de publication des versions finales de certains produits majeurs de Microsoft sont désormais connues. La fuite d'une feuille de route de l'entreprise prévoit la sortie de la suite bureautique Office 15 en début 2013 et le lancement de la mise à jour Windows Phone 8 à l'automne. La roadmap a été publiée accidentellement par Martin Visser, directeur général de la startup SharePoint et mo...

Read the article
Microsoft Office 2010 est en pré-commande, sortie officielle le 12 mai pour la nouvelle suite de Mic

Mise à jour du 19/04/10 [Les commentaires de cette mise à jour commencent ici] Microsoft Office 2010 est déjà en pré-commande Sortie officielle le 12 mai pour la nouvelle suite de Microsoft très axée Cloud et collaboration Microsft Office 2010 est disponible en pré-commande en trois versions : Famille et Etudiant (139 Euros), Famille et Petite Entreprise (379 Euros), Professoionnelle (699 Euros) - lire par ailleurs "

Read the article
Microsoft Office 2010 est en pré-commande, sortie officielle le 12 mai pour la nouvelle suite de Mic

Mise à jour du 19/04/10 [Les commentaires de cette mise à jour commencent ici] Microsoft Office 2010 est déjà en pré-commande Sortie officielle le 12 mai pour la nouvelle suite de Microsoft très axée Cloud et collaboration Microsft Office 2010 est disponible en pré-commande en trois versions : Famille et Etudiant (139 Euros), Famille et Petite Entreprise (379 Euros), Professoionnelle (699 Euros) - lire par ailleurs "

Read the article
Copy and Pasting Web page Content into an Office Application.

- by gcc

I want take information from any website and paste it into Libre Office (text and images). Firstly, I want record the name/URL, description and some basic information from each website. Afterwards, my intention is to copy/paste the web-page content into LibreOffice in order to analyze it. Can Libre Office do this and is it my best option? if not can you recommend a tool which is available for 12.04?

Read the article
Hyper-V VMs hanging 10 minutes after startup

- by Ken George

Hyper-V running under a fresh install of 2008 R2 DC 2 VMs both running 2008 R2 STD One VM has SQL 2008 Server w/ SP2 and Office 2007 Enterprise w/ SP2 Othe VMS only Office 2007 w/ SP2. Approximately 10 minutes after reboot the Hyuper-V host the VMs will hang Hang = answers pings, but no RDP connections and Hyper-V console session is non responsive Disabled Hyper-V and had no proble with 2008 R2 DC host. Started the three Hyper-V services and 10 minutes later was hung again. Hardware is HP DL380 G4 2 socket, 48 GB, Internal SAS controller 1.5TB C drive VMs .VHDs are on external SAS controller on a 1.5 TB RAID5 volume. Nothing in event log on either VMs or Hyper-V host. Ken

Read the article
MS Word - Keeps requesting user to save Normal template

- by MikeT505

We have Small Business Server 2008 setup on a couple of our clients networks and we have the following issue. Whenever they logon, Microsoft word automatically opens and requests them to save their changes to the template 'Normal'. It constantly happens, we have a mixture of Win 2000 and XP machines and it seems to happen more often on XP than 2000. Any idea why this might be happening and how we can resolve it, it's just frustrating for the end users. PS: This is happening on Office 2000 and Office 2003.

Read the article
How to re-add a missing font

- by WEFX

I recently upgraded from Office 2007 to 2010, and that went fairly smoothly. However, afterwards, my Calibri font was gone, so my Word and Outlook started using the next available font in the list... Comic Sans! I browsed to Control Panel Fonts, and saw that there was no longer a Calibri listing. I know that one way to recover a missing font is to just copy the missing font files from another computer. In my case, the four files I needed were: calibri.ttf, //regular calibrib.ttf, //bold calibrii.ttf, //italics calibriz.ttf, //bold and italics However, once I attempted to copy-and-paste these files to my computer, I realized these files were already on my problem computer; they never really got erased. I don't know why they aren't working in Office, and they aren't listed in Control Panel Fonts.

Read the article
excel cannot open the file xxx.xlsx' because the file format is not valid error

- by Yavuz

I have difficulty open opening word and excel files suddenly. Only particular office file give me the problem. These files were previously scanned by combo fix and I believe they were damaged. The error response that I from office is Excel cannot open the file xxx.xlsx because the file format is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. This is for excel and a similar kind of error response comes for word. The file looks fine. I mean the size vise... Please help me with this problem. I really appreciate your help and time....

Read the article
How do you customize Excel 2010 keyboard shortcuts?

- by Sam

How do you customize Excel 2010 keyboard shortcuts? This article from microsoft.com provides instructions for "Microsoft Office 2010" but seems only apply to Word, not Excel. http://www.microsoft.com/athome/organization/compshortcuts.aspx In Microsoft Office 2010: Click the File tab to open Backstage view, and then click Options. Click Customize Ribbon and then, next to the Keyboard Shortcuts heading, click Customize. You can enter the new key combination here. Here's the dialog it points to shown in Word: But here's the same dialog shown in Excel: Notice it looks almost exactly the same but no "Keyboard Shortcuts: Customize.." button. So how do you customize the keyboard shortcuts in Excel?

Read the article

Search Results

Search found 6489 results on 260 pages for 'office automation'.

Page 47/260 | < Previous Page | 43 44 45 46 47 48 49 50 51 52 53 54 | Next Page >

- by jimbojw

- by CREFLY

- by Rikker Serg

- by Shahbaz

- by p-vasuu

- by shin

- by marechs

- by John Isaacks

- by Wesley

- by Steve Johnson

- by eidylon

- by Scott

- by Josh Harris

- by Keng

- by Stanomatic

- by user526186

- by gcc

- by Ken George

- by MikeT505

- by WEFX

- by Yavuz

- by Sam

< Previous Page | 43 44 45 46 47 48 49 50 51 52 53 54 | Next Page >