+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, VBA with Excell in Technical; Hi, Getting to my witts end with this problem. its with a office 2010 install looks like its on all ...
  1. #1

    Join Date
    Jul 2010
    Posts
    575
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14

    VBA with Excell

    Hi,

    Getting to my witts end with this problem.
    its with a office 2010 install looks like its on all our comps now we get the following errors VBA.png
    Now i did config office with OCT before deploy but didnt see that i had done anything that would have caused this. However i am open for all sugestions as I cant find the answer.

    I have logged on as Admin and gone to control panel > programs > and office > change> and office tools are installed along with VBA. So it has to be a setting somewhere???

    Please help

  2. #2

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,781
    Thank Post
    3,288
    Thanked 1,054 Times in 975 Posts
    Rep Power
    365
    Daft suggestion but when you save the excel workbook are you going

    File --> Save As --> Excel Macro Enabled workbook ( *.xlsm )

    Then attempt to re open said workbook and try the vba code

  3. #3

    Join Date
    Jul 2010
    Posts
    575
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14
    This is happening when SIMMS is generating the report file in xls but now its also with some maths files that they have got from national strategys website that end in xls format ?

  4. #4

    Join Date
    Jul 2010
    Posts
    575
    Thank Post
    67
    Thanked 26 Times in 21 Posts
    Rep Power
    14
    Anyone got any ideas on this. I have logged on a machine removed ranger then removed office. then installed office from the disk and still getting the same error?

SHARE:
+ Post New Thread

Similar Threads

  1. Help with Excel Chart
    By TechSupp in forum General Chat
    Replies: 3
    Last Post: 9th November 2009, 12:19 PM
  2. Problem with Excel Replacing leading zeros
    By chris-t in forum Office Software
    Replies: 4
    Last Post: 28th August 2009, 01:15 PM
  3. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM
  4. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 10:27 AM

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
  •