Search results for query: *

Hi, I need a macro that changes an active documents print settings for MS Word 97 so that the following is selected: - 1 sided printing - Page 1 Tray 1 - Page 2 Tray 2 - Page 3+ Tray 4 Is this possible? thanks

I have a small macro I have written to take data from excel to populate word and have a slight problem. Here is a sample of the way I am doing it: wrd.ChangeFileOpenDirectory _ "\\BTBEAPDAT01\DATA_BEACON_HOUSE\NCC\Tier3 RP|Damian Templates" wrd.Documents.Open FileName:="T66 TV Payment...

Please can someone help me, I can't seem to get a bit of my code to work. Here is what I have: For polroutine = 0 To 4 PolNo = polarray(polroutine) If PolNo = "" Then GoTo polcont2 'enter policy no backoutchk = MyScreen.getstring(2, 3, 7)...

I would like to know if this is possible. I have gathered info in excel and I would like to be able to open a word template that has autotext entries eg 01 & F3 will you get inputboxes for some info to be input and then 02 & f3 ... etc. Under certain circumstances depending on the info in...

I am taking text from Attachmate and putting it onto word. If I have this: a = TextA b = TextB c = TextC inputtext = a & Chr(13) & b & Chr(13) & c wrd.ActiveDocument.Fields(1).Select With wrd.Selection .InsertAfter Text:=inputtext End With I want to have b inserted as bold, is this...

Some of the work I do involved completing excel sheets with data. I had written a VB that took info from certain parts of a work book and populated the info required, however I can no longer do this as the these excel sheets have now been placed on our company intranet in the form of Adobe...

Hi, Please can I have help in converting data taken from attachmate from capital letters into small letters. I have this that Calculus kindly provided a while ago which does it except for the first letter but not sure how to make the first letter small also! For X = 2 To Len(freq) If...