How do I go about removing specific instances from a string. For example, I've got this string [32m50[0m/[33m2[0m/[31m2[0m and I want it to reads as 50/2/2 by removing instances of [31m, [32m, [33m, and [0m
View 2 RepliesI am Tring to Make this work but I do not understand the Colunms as objects Part. Here is what I got
[Code]...
I want to look up a value in column B and if the value of the cell in column b matches my searched value i want to look up a value in another column. If both values match the values i am searching for, i want to exit the while loop.
If there is no row that contains both my values in the range of cells, that contain any value in column b i want to exit my while loop.I am literally crying, because i just can't get this done.As you can see i am trying to do this via a for each loop.
there are so many things that didn't work so far...the rows 3 to 6 are filled, but rows 7 to 10 are empty. row 11 is filled.the counter returns the value for counter, that shows, that only not empty cells or rows were counted. I just don't get it. A already wrote, that if the cell.value is nothing, counter shoul be incremented, but this didn't seem to work.I also tried the findmethod in vba, but couldn't get it to work.
my code:
Code:
Sub GetSumme()
'====================================================================================================
' Dieses Sub summiert die zu kaufenden und verkaufenden Mengen. Wichtig f�r den korrekten Start
' im aktuellen K�stchen ist der Wert, der in "bearbeitet" steht. Das ist ein fortlaufender Wert, der
[code]....
I have a excel report with one sheet called "Export Report". I then add 4 more sheets and rename them accordingly.
I then need to search in "Export Report" in column A, but unknown row for the word 'Definitions' and then once found I have to copy 'Definitions' and 10 rows belows it, to the sheet called "Definitions"
How can I achieve this? At the moment I am stuck at the point of finding the word 'Definitions'. I get error Exception from HRESULT: 0x800A9C64 at this line:
LastRow = xlApp.Workbooks(1).Worksheets("Export Report").Cells(xlApp.Workbooks(1).Worksheets("Export Report").rows.count, "A").end(Excel.XlDirection.xlUp).row + 1
[Code].....
It appears that when one creates an instance of Excel, using CreateObject, (Late binding), the suggested Excel closing function (with GC.collect etc) does not work. I have tried several suggestions, and the only one that works is process.kill method. Do you see any problem in using this? BTW: the reason we are using late binding is that we cannot use Office PIAs....not sure which version of Office would be installed on the client site. We work with O2003, but the client might still be at 2000 or 2002.
View 7 RepliesI am having a hard time find out a way to paste the content from a text file into excel.I am able to read the entire content from a text file and put it into a string. After retrieving the info from the text file,I would like to open an excel template and paste the text file content into the excel sheet.
View 5 RepliesI am using Outlook 2003, VB 2008 and Win XP.I am storing user ID's in the User1 field of the Outlook Address Book. This is working find I want to Find all Address Book items with a value in User1 [code]This will find an Address Book item, even if the User1 field is not blank. When I debug, the first entry found has OlContactItem.User1 = Nothing.If I set User1 to a value (for example Id # is 1234, so I set User1 = "1234"), I can find just the one Address Book item with:[code]How can I find just the Address Book Items with User1 is blank?
View 1 RepliesCode:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim oWord As Word.Application
Dim oDoc As New Word.Document
[Code].....
i got this from m$ site as well
any one see whats wrong?
[URL]
I'm inserting data into excel sheets and after i fill each sheet I want to sum a column so select the data and add a formula to a cell. However when the sheet is opened the cell contains the formula as text instead of the sumation value. I tired several ways but here are a few different meathods that both end up with the same undesired result.
Code:
'Meathod 1
oSheet.Range("H2:H" & (dtEntries.Rows.Count + 2).ToString).Select()
oSheet.Range("H" & (dtEntries.Rows.Count + 2).ToString).FormulaR1C1= "=SUM(R[-" & (dtEntries.Rows.Count).ToString & "]C:R[-1]C)"
[code]....
I would like to "get" a text from outlook message, using VB.NET shared add-in.
First, I've made VBA script and it worked well. Here it is:
Code:
Sub Macro1()
Dim msg As Outlook.MailItem
Dim insp As Outlook.Inspector
[Code].....
text formatting in word document. i want to select a specific text in a document and format it.
Here's what i've got
Quote:
With WordApp.Selection.Find
.Text="word to find"
.Font.Color = Word.WdColor.wdColorBlue --> supposed I want to color it blue
End With
I am exporting text to a worksheet with fixed column widths and there instances where the text in the cell does not fit and will obviously overlap to the cell on the right.
I'd like to prevent that overlapping by reducing the font size of the cell if it is necessary. The problem is how to check if the text does not fit.
is there a way to extract all the text from a Word Document in VB.NET without actually openning the file? I'm asking since it is a very time and memory consuming operation to open a word document, select all, assign it to a variable and the close the file.I have a routine the opens all emails in a mailbox and analyses the body and subject object for regular expressions. I would like to do the same for the attachment, if it's in Word. if it's not possible to extract without openning the file, can anyone give me the best way to do it so that the routine doesn't destroy my server memorywise?
View 2 RepliesIn VBA I am able to search a text in an excel range like this:
Code:
Workbooks("Book1").Activate
With Worksheets(1).Range("C1:C10000")
[code].....
I have upgraded to Visual Studio because of the jobs I am to carry out. So I am translating all the codes from "VBA" to "VB.NET" (Visual Basic 2008)But I haven't been able to use "Find Method" in VB.NET. I am using Microsoft Office XP Standart Edition (2002 Version). I downloaded and installed Office XP PIAs. After that I referenced them in my project. I used the code Code:Imports Microsoft.Office.Interop.ExcelBut I can't do what I want Now, how can I use "Find Method" in Visual Basic 2008 to find a text in an excel range in one of my workbooks?
have a code with a progressbar to import data from text file. My problem is after first loop, a progressbar gets error.
Code:
Sub import_mgf()
Progressbar.Show vbModeless
Progressbar.Caption = "Process status"
[Code].....
I have written an automation addin in Excel with C# (addin.dll). To use the addin, I need to 1. register it using "regasm /codebase c:...addin.dll"2. select in ExcelOptionsAddInsExcel AddinsAutomation the respective addin from the list
I would like to automatize 1) and 2), so that the user just needs to run an exe-file in order to use the addin. 1) should be no problem, but how can one automatize 2)?
Ok basically what I need to do is the following:Read FirstExcelDoc (attached)For every row in that: Retrieve data from sql server db based on info in the Orange columns of FirstExcelDoc Let's say I retrieved data elements A, B, C, D, and E from sql server. Then I need to enter those same data elements A, B, and C in another excel spreadsheet (which has formulas etc) After inputing A, B, and C in that spreadsheet, read a couple of calculated fields and compare those results to data elements D and E retrieved originally from SQL Server DB. Finally, output the results in the Blue columns of the FirstExcelDoc spreadsheet for that row.Loop through and do the same thing for row 2 of the FirstExcelDoc and keep on until you see "END TEST" in the FirstExcelDoc.
I'm looking for a method of doing this efficiently. I have read several articles over the past few days as well as those from Mike R. but just need some direction to get started on this.To start of I'm looking for whether to read the entire FirstExcelDoc spreadsheet or just read the info for first policy number(2nd row) and process it and write out the blue column info for that row and then loop through and come back and read the second policy number (3rd row) etc... Please attach a code snippet for either way of reading the data.
I'm using excel via interop in application.Sometimes users kill application that created excel instance and that results in excel instance sitting in memory without any chance of disposing it.First I tried to tackle this using ROT(running object table) looks like not all instances of excel are registered there.Than I tried to somehow mark excel process after it is started via interop.[code]This works as long as excel is visible but in my case excel window is invisible.All I need is to somehow mark process that started via automation with the parent PID, so that later I can kill it if parent does not exist.
View 19 RepliesI have successfully automated a PowerPoint Metrics presentation with VB.Net. However, since there were many complicated calculations, it took quite some time to make the 120+ slide presentation - so I recently tried to revamp the application to be multi-threaded.
[Code]...
I've got VS2008 and Office2010, but I don't have Office2007. Therefore, I have the Word14 Object Library but not the Word12 Object Library. Will the code that I create for Office2010 automation also work where clients only have Office2007 or will they have to upgrade their office suites?
View 1 RepliesI am looking for a way of automating the generation of a text document which includes a table and an image. My client has requested, however, that it be in Open Office format. I have played around with AODL for a while and have been able to create a file with the text within the table but some things are still bugging me.One such thing is column width. Another one is aligning an image.I find the problem with AODL is that it is not very intuitive to use and there are not so many examples available.
View 2 RepliesI have been pulling my hair out trying to fix this.
[Code]....
We have a vb program which is run on our server by scheduled task every day. The program opens about 30 excel files, refreshes the data connections, pivot tables and then saves the document in another location.
This may run fine for a couple days but sooner or later the process starts crashing, usually with this error: RPC_E_SERVERFAULT.
My question is, Is it expected that continually opening/closing/refreshing workbooks will inevitably cause the Excel object to crash at some point.
I am trying to read two text files and write in differents tabs.
Code:
Dim xl As Object
xl = CreateObject("Excel.Application")
xl.Visible = False
Dim i As Integer
[CODE]...
i was wondering if someone could give me the final explanation on what i might be doing wrong here.I spent a lot of time reading around the net and the forum about how to add Threading capabilities to a VB project.
Nos, i've got .NET 4 installed, and i've added the system.tsr and mscorlib.dll files as reference in, say, Excel 2007 (see screenshot).However, when i try to make a thread with anything as basic as "Dim Thread1 As System.Threading.Thread", i get a user-defined type not found error.Indeed, when i use the object browser to see what's in the System file, theres nothing remotely linked to any Threading, and in the mscorlib file, nothing under "Threading" either, just a few Thread related functions, but nothing defining a data type
I've developed shared addin for Microsoft Word. I distribute this addin with my application and using Inno setup for installation. The Inno setup installs my application and then runs "myAddin.msi" file in order to install addin.
how to uninstall this addin programatically?
Right now, in order to uninstall addin, the user has to to it manually through control panel.
how do i use the webbrowser to display the word or excel docs. just like the pdf viewer... i tried the webrowser1.navigate but it didnot work, if it does its opening a new window, im using office 2010..
View 4 RepliesHow do I use the webbrowser to display the word or excel docs. just like the pdf viewer. I tried the webrowser1.navigate but it didnot work, if it does its opening a new window, I am using office 2010.
View 1 RepliesI've made Add-in for Word 2007 in VS2005.It worked well with Word 2007 and now it works well with Word 2010 32 bit.However it doesn't work with Word 2010 64 bit. The installation is successful, but the ribbon button doesn't show up.
Do you have any experience with add-ins for Office 64 bit?
I'm having an issue where my excel.exe process doesn't close until I close my .net application. I'd like to avoid using Process.Kill() if at all possible.
Code:
Private Sub WriteRowsToXls(ByVal rows As DataRowCollection, ByVal xlsPath As String, ByVal showStatus As Boolean, Optional ByVal AddTotals As Boolean = True)
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
[CODE]............
This method references a couple of other methods I use for repeated formatting tasks, I'll include those methods below. (I added the FinalReleaseComObject into the other methods after reading Mike's thread but the issue persists)
Code:
Private Sub SetRangeValidation(ByVal rng As Range)
With rng.Validation
.Delete()
[CODE]..............
Method SetRangeAllBorders does about the same as these other methods but my post is too long to add it. The only other things not shown in these code snippets are a few string variable that are defined in the class, studentWS, studentsWSPW, paymentsWS and paymentsWSPW My App creates an instance of the class, loads some data, runs the method above, and then sets the class to nothing. I'm using .NET 3.5 automating Excel 10