microsoft.public.scripting.vbscript - Microsoft Office Project
hi, i have a text file that contains a few hundred rows of data. i need to grap those words which starts with characters GG and which is 5 characters in length. eg. GGXXX, GGC3F, etc Can someone advise how can i achieve this? thanks
Hi all, I have a template to make a fax (or letter), when it is first ran it checks for a txt file using "System.PrivateProfileString", if it doesn't exist it shows a userform requesting user information (name, phone nr. etc.) and then put this information in the bookmarks in my document and store it in a txt-file. Now i also like to create a template i can use for a mail merge, and also use this info (from the text file) in this document. But i allready found that it is impossible to keep you bookmarks after a mail merge, they all get deleted. Is there a way to still get the info form the text file in my document without using bookmarks? Is this possible with fields? Thanks in advance, Rhayan
I am using vba in spreadsheet1 to open and count data from an excel spreadsheet located online (spreadsheet2). Once that data is counted in spreadsheet2, I want that value to be printed in spreadsheet1 where the macro was initially run from. I have the following code so far, but it will (obviously) print the data in spreadsheet2 rather than spreadsheet1: Sub openn() Dim Countt As Long Workbooks.Open Filename:="sample filename.xls" Countt = CountColor(Range("D4:GE4"), 45, False) + CountColor(Range("D4:GE4"), 10, False) + CountColor(Range("d4:GE4"), 8, False) Range("k53").Value = Countt End Sub How do I get it to put that value in spreadsheet1?
I have an existing TIFF file on disk. I need to be able to read the image compression information for this file using VB.NET. I am trying to verify that all files coming into my system are CCITT Group 3 or Group 4 TIFFs. I have found the methods to use to write Group3 and Group4 TIFFs, but I cannot seem to read the compression type of an already existing TIFF. Does anyone know how to do this in VB.NET? Thanks for the help. Regards, Corey Ellsworth