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:
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.![]()
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
Would greatly appreciate any help.
Cheers from Oz
Bookmarks