'I provide the Master Layer to show one way of how to have non-variable objects on each page. 'This document has a Master Layer that can be removed from the Object Manager if not needed. 'The Sub FILL_COLOR and all references to it can be deleted if you do not want a uniform colored background. 'You can strip away many of the unnecessary comments. 'In your particular use you may not need all the options. 'This VBA procedure is long because it has many comments & there are options. I looked into posting on a different forum/section, but this one was the only related section that actually had people visiting it.
I figure there is enough info here to do what I would like to do, but its all "Greek" to me.
Here is the sample VBA done for corelDraw. I hope that a script like this might be easy for someone here to whip up for me.I would appreciate it a whole lot!! Another idea would be to have a user box come up asking how many cells down to check before it closes the script(8 of 96). If it detects a cell with no info it will finish the script. Then it would check A2, and paste it to a different loacation(x=500, y=0.300) ect, ect. If it does, it would copy the contents from that cell and paste it to a location on my corel template(x=0.500, y=0.100). I was thinking it would go something like this: I already have my Corel template open, when I start the macro it would open the excel file(same location) and check to see if cell A1 has any info. The Excel file is pretty simple with 1 column and 96 rows, but not all 96 cell will always be populated. this is what I am trying to do: I would like to create a VBA macro within CorelDraw to grab info from an Excel spreadsheet that I have already created. Hi guys, I am new to VBA scripting, and I was hoping to get some help here.
0 kommentar(er)
