LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Excel 2007 problem with macros

I was somewhat a little wrong...

Opening Excel 2003 version in 2007 opens fine, but if I try to apply the
macro, apparently I get errors...

I had a line object with a macro assigned that copied a sheet to another
copying simultaneously some values from the previous sheet to the new one...
It also checks for existing names, and if the new name exist it stops,
otherwise it renames with then new sequential name...

I also had the combo box that had a macro attached that renamed the sheet
manually... Basically this to make my accountant monthly work...

When copying the data to the new sheet it copies the sheet to a new one...
It doesn't copy the combo box, and the line objects are copied out of it's
previous place or not copied at all...

After this if click the macro to copy again to a new sheet it shows the
following error:

Run-time error '-2147417848 (80010108)':

Automation error. The object invoked has disconnected from its clients.

If I click debug it points me:

Sub NovaFolha()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim array_aux() As Variant
ActiveSheet.Activate
a = ActiveSheet.Name
B = Range("f4")
= Sheets(a).Copy After:=Sheets(a) --- This is the line selected by
debug...



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Query Wizard problem with Access 2007 extensions Showdad Excel Discussion (Misc queries) 0 December 4th 08 05:57 PM
Macros for Excel 2007 JHL Excel Discussion (Misc queries) 3 November 7th 08 04:06 AM
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macros in Excel 2007 Michelle Excel Discussion (Misc queries) 3 March 7th 08 01:35 PM
Macros in Excel 2007 Graham Excel Discussion (Misc queries) 8 April 6th 07 10:59 PM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"