I need to laser engrave on the outside of a 1 inch round piece of glass.
Is there a way to export a query into word/excel and then have the data be added to word art?
We have been doing this manually which is awful.
Any help would be appreciated.
I need to laser engrave on the outside of a 1 inch round piece of glass.
Is there a way to export a query into word/excel and then have the data be added to word art?
We have been doing this manually which is awful.
Any help would be appreciated.
a single line?
many records?
It would be a list, 2 fields and no more than 15 records.
I presume you are exporting a single phrase like 'Winner 2018'?
I don't want to get involved with the detail and I don't know about Word, but in Access VBA to create wordart in Excel, do the following:
1. create an excel object
2. create a new excel file
3. use code to create the wordart shape, fonts, styles etc (the code required can be determined by recording a macro in Excel to create your wordart object)
4. use code to populate the shape with the required text.
5. save the excel file
Note this is not an 'export' as such, merely creating something in Excel. Also, if you activate the excel library you will get intellisense which should make it easier to convert the code. You might want to make a note of the values used to create your wordart and store these as profiles in an Access table
A simpler alternative would be to create your wordart in an excel file and save it, then use access vba code to open the file and just populate the wordart text.
Ah a later post. Principle would be the same, but you would loop through the list
For example code manipulating WordArt objects review https://technet.microsoft.com/en-us/.../ee692903.aspx
Should be possible with Word automation.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.