Hi,
I'm a very basic user and over time have developed an invoicing system for my business which is much faster to use than other small business accounting software.
I would like to be able to write a "Market Update" (which incorporates a clipart image) in a text box in one Excel file, ( "Market News Flash") then simply press a Quick Access Toolbar icon when using the invoice file for each customer (" Invoice Template").
I tried using the record macro function however this did not work. I then tried to modify per suggestions from internet etc (non-specific). The code used is:
Windows("Market News Flash.xlsx").Activate
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlNormal
ActiveSheet.Shapes.Range(Array("Group 8")).Select
Selection.Copy
Windows("Invoice Template.xlsm").Activate
ActiveWindow.WindowState = xlNormal
ActiveWindow.WindowState = xlNormal
Range("B35").Select
Selection.Paste
Range("B33").Select
ActiveWorkbook.Save
End Sub
The resulting error is "Run-Time 438 Object doesn't support this property or method" Too be honest I thought this would be a basic copy/paste macro but 2-3 hours later I'm still struggling.
Would greatly appreciate any help.
Cheers from Oz
Bookmarks