LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
QB QB is offline
external usenet poster
 
Posts: 57
Default Problems with switch to 2007

I create a xls in 2003. It worked great!

We are now migrating to 2007, On my PC (once again) everything run smoothly.
But when others run it they get errors left right and center! I started
stepping through my code to try to resolve the problem(s) but am now more
confused then ever. For instance, I use the code below to delete a worksheet

Dim DstWkb As Workbook
Dim DstWks As String

Set DstWkb = ThisWorkbook
DstWks = "Project Info"

DstWkb.Worksheets(DstWks).Delete

and it generates an err.number = 9??? and yet it does delete the worksheet?!
Why does it work without issue for me and yet generate errors for others,
even though it works fine even for them (just reports errors)?

Thank you for your guidance,

QB

 
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 - How can I switch the data on vertical and horizontal Beach Lover Charts and Charting in Excel 1 March 26th 10 06:00 PM
What is the VBA for the Excel 2007 "Switch Window" command button? ND Pard Excel Programming 6 March 4th 09 10:39 PM
Can I switch from Office 2007 layout to the old 2003 layout? samanthajade Excel Discussion (Misc queries) 3 May 11th 08 09:40 PM
Excel 2007 - Switch vertical and horizontal axis? Beach Lover Excel Discussion (Misc queries) 3 February 13th 08 03:41 AM
In Excel 2007 how to switch off macro with a macro Micky Excel Programming 2 September 24th 07 11:17 PM


All times are GMT +1. The time now is 03:23 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"