OberonPlace.com Forums  

Go Back   OberonPlace.com Forums > Members List

platesigns platesigns is offline

Junior Member

Visitor Messages

Showing Visitor Messages 1 to 1 of 1
  1. platesigns
    28-08-2012 15:51
    platesigns
    Hi

    Can someone help with step 5 and 6 below ?

    Thanks





    STEP 1: COPY SELECTION FROM EXCEL
    STEP2 : RUN PASTE SPECIAL MACRO
    STEP 3: RUN THE CONVERT TEXT MACRO
    STEP4: RUN THE FONT CHANGE MACRO
    WITH LINE SPACING
    STEP5: ON LINE ONE, CAN WE USE A MACRO
    TO PLACE THE CURSOR AT THE SECOND LETTER
    PRECEDING THE FIRST NUMBER AND HENCE CREATE
    A NEW LINE
    STEP6: FOR EVERY LINE THAT FOLLOWS AFTER STEP 5,
    AFTER THE FIRST 3 LETTERS, THE MUST BE 3 POINT SPACE
    UNLESS ITS AN i IN WHICH CASE IT MUST BE 4 SPACES

    *****after paste special in corel draw******

    CANE WEIGHBRIDGEK1-01-03-100
    -ELEELECTRICAL CONTROLS AND CABLES
    -INSINSTRUMENTATION
    -SU1STRUCTURE

    *******this is the final result i want to end up with **********

    CANE WEIGHBRIDGE
    K1-01-03-100
    -ELE ELECTRICAL CONTROLS AND CABLES
    -INS INSTRUMENTATION
    -SU1 STRUCTURE

    ****codes for some of the steps above******************

Statistics

Total Posts
Visitor Messages
General Information
  • Last Activity: 14-12-2015 21:17
  • Join Date: 28-08-2012
  • Referrals: 0

All times are GMT -5. The time now is 02:48.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright © 2011, Oberonplace.com