+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
MIS Systems Thread, Macro + Excel 2007 + SIMS in Technical; Thanks for eveyone's help!! I've removed all the lines that Excel 2003 did not like and now have 1/2 a ...
  1. #16
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    128
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13

    Talking

    Thanks for eveyone's help!! I've removed all the lines that Excel 2003 did not like and now have 1/2 a macro that works. All i need to do is record the rest and tag it on.

    Brilliant!! As for "pulling" the image, there was no need to. If you are as familiar with SIMS as I am, you would have noticed that the names are that from the Capita Training Database, Green Abbey!

    Our friend Stan Acton is top of the list

  2. #17

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Quote Originally Posted by ChrisH View Post
    Excel 2003 will not support .ThemeColor as a font property no doubt. Comment the lines out by putting an apostrophe before it. This is setting a colour for the font in that range.
    Chris is right, you need to go through and comment out any lines that start ".Theme", that should fix your problem (you comment lines out with the single quote as before with the "On Error" statement).

    If it still won't work after that, post what you have so far and I'll have another look for you

    EDIT:
    Just a few seconds too late lol. Oh well, the offer still stands if you need any more help

  3. Thanks to LosOjos from:

    SteveB (3rd March 2010)

  4. #18

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Quote Originally Posted by SteveB View Post
    the names are that from the Capita Training Database, Green Abbey!

    Our friend Stan Acton is top of the list
    I take it you receive your support from SMIS in Smethwick then?

  5. #19
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    128
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    No, we are the Support Unit for SIMS in Worcestershire.

  6. #20

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Quote Originally Posted by SteveB View Post
    No, we are the Support Unit for SIMS in Worcestershire.
    Oh I see, I forget how far the Midlands stretches when I'm in my bubble in Sandwell lol.

  7. #21
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    128
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    Quote Originally Posted by JoshJohnson View Post
    Oh I see, I forget how far the Midlands stretches when I'm in my bubble in Sandwell lol.
    hehe, you are so far north, you must have a nosebleed . .

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [MS Office - XP] Excel Macro - If Cell Value
    By ahuxham in forum Office Software
    Replies: 0
    Last Post: 18th December 2009, 10:27 AM
  2. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  3. Excel 2007
    By wesleyw in forum Windows
    Replies: 0
    Last Post: 22nd June 2007, 03:31 PM
  4. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 10:27 AM
  5. Excel Macro - Edexcel GCE Exams
    By steve in forum Educational Software
    Replies: 0
    Last Post: 16th May 2006, 02:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •