Search results for query: *

Hi, Is there an easier way to change the OLE link of a drawing file using Excel macro. I have used the "Sendkeys" command, but it didn't work. Any help will be appreciated to enhance my knowledge. Thank You very much son56

Hi Danyul, I have only used the FileCopy command. The reference file (target), which has an object that is linked to the excel workbook is my reference. Obviously, if I create a copy of that file, the same link will be created. Is there a way to copy the reference file with a different link?

Hello, If I have an Excel Workbook with a macro which creates a file, a reference/custom file type which is linked to the Workbook, for example, the reference file's data or text is linked with cell range A1. What should I do to create another file of that type from the same Workbook which is...

I have created an excel workbook which would create a copy of a given AutoCAD file (drawing or template) with blank data. I want the data (text: for title, date, designer, etc.) to be entered and edited through Excel. There are several worksheets in Excel workbook including the Main Sheet. The...

I'm automating the use of AutoCAD with Excel. I want to create a macro in excel which would generate a drawing file from a given template (custom drawing). The drawing should have an incrementing filename. (Ex. aaa.dwg, aab.dwg, aac.dwg) Each of the drawings data will come from the data in...

I'm automating the use of AutoCAD with Excel. I want to create a macro in excel which would generate a drawing file from a given template (custom drawing). The drawing should have an incrementing filename. (Ex. aaa.dwg, aab.dwg, aac.dwg) Each of the drawings data will come from the data in...