'This stores the name of the file that contains the data. 'I know that there is DATA(0,0) but I have not used it to make it easy. 'So the first piece of data cells(2,1) will go into DATA(1,0). 'The data file I have supplied has a header in each column located in row 1.
'If you have 10 variables in a data set then Dim DATA(10000,9). 'If you have only 1 variable in a data set then Dim DATA(10000,0). 'ie I have used 3 columns of data in the Excel Worksheet, so Dim DATA(10000, 2). 'The second variable in the array ie 2 is the number of variables in each data set less 1. 'If more data sets are supplied in the data file, increase the 10000 to a larger number. 'The data array here allows 10,000 sets of data. 'This means that Master Layer objects can obsure variable data. 'Remember that objects on the Master Layer are always on top of objects on other page layers.
#CORELCAD FORUM HOW TO#
'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).
.gif "corelcad forum")
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)
