+ Reply to Thread
Results 1 to 17 of 17

Cross-Computer Macro Issue

  1. #1
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Cross-Computer Macro Issue

    So recently I created an worksheet for our field personnel, in this worksheet there is one vba-function, and three subroutines. I sent the sheet out, and the field guys have been filling the sheet out and sending it back to me.

    After working great for a few weeks, now when they send the sheet back, the vba function does not work (#Value not #Name?) - the code is still there, so there should be no reason it's not working. When I call the field guys they say it works fine and they can see all the numbers on their end, but after emailing I see nothing but #Value.

    Any ideas as to how to fix this? I have already been through the obvious such as making sure we have the same excel version, checking for the same references etc.

    There is no reason it shouldn't work - alas here I am

    Thanks for the help

  2. #2
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    Also, the 3 subs work, but the buttons to launch the subs don't work, so its as if the developer/vba quit talking to the excel sheet for some unexplainable reason

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,095

    Re: Cross-Computer Macro Issue

    Have you tried stepping through the code in the function?

    You can do that by putting a breakpoint on the function header with F9 and then returning to the sheet and hitting F9 to calculate.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    Yeah I tried that, with the new broken worksheet it doesnt step through at all. In that its like the sheet isn't communicating with vba anymore

  5. #5
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    And when I try to delete any of the tabs it immediately crashes excel

  6. #6
    Registered User
    Join Date
    05-14-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Cross-Computer Macro Issue

    Hi, have you updated your PC? I had a similar issue and this fixed it.

    See here, if it sound similar?
    HTML Code: 
    http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/
    Good luck
    C

  7. #7
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    Thanks Mr. C, I thought that to, so yesterday I ran through that workflow, and it didn't seem to solve the issue, super weird right?

  8. #8
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    Also, if this helps, we are running excel 2007

  9. #9
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    And windows 7 professional

  10. #10
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    bump for new crowd, really have no idea why this isnt working. Tested with my personal computer at home (which runs 2010, so not even the same issue of excel) and was able to read/write/see everything fine both there and when sending it back to the original computers.

  11. #11
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,746

    Re: Cross-Computer Macro Issue

    Hi betherzy

    Do you get any error message(s)?

    I too run Windows 7 with Excel 2007 (and other Versions of Excel). I'd like you to post your File such that I can test it. If it works on my Platform we'll look at your settings.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  12. #12
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    Thanks John, No error messages, just doesnt see the Previous_Sheet function,

    please see attached - day 2 on unrecognizable. I wouldve deleted more of the sheets, but any attempt to delete a tab results in an excel crash
    Last edited by betherzy; 03-09-2015 at 12:37 PM.

  13. #13
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,746

    Re: Cross-Computer Macro Issue

    Hi betherzy

    Your Code performs as expected on my Platform (Office 2007, Excel 2007).

    Only two things come to mind:

    ActiveX Controls have been disabled
    Open your File in Excel
    Click on the Office Button
    Select Excel Options
    Select Trust Center
    Select Trust Center Settings (Right Hand Side of Window)
    Select ActiveX Settings...this is what mine looks like...what do yours look like?

    If you've changed the Settings, save the File and exit Excel.

    Open Excel and your File...do they work now?

    Activex Setting.jpg

    The other thing that comes to mind is addressed in the following Link. Since you're not getting an error message I'd assume this is not the issue but, look at it.
    http://excelmatters.com/2014/12/10/o...ivex-controls/

    Let me know how you get on.

  14. #14
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    Hey john,

    ActiveX Settings is the first thing I checked out, rechecked it and our settings are indeed set the same.

    I have also run through the activex reset workflow multiple times and that did work either.

    The sheet really works on your computer? I tried this same sheet on a personal computer at home and it did not work there either.

  15. #15
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,746

    Re: Cross-Computer Macro Issue

    Hi betherzy

    I've tested the Code on two machines and it performs as expected on both platforms. Sorry, have no idea where else to look.

  16. #16
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Cross-Computer Macro Issue

    John,

    No worries, that's good news then that the worksheet works elsewhere

    Appreciate the help, rep added

  17. #17
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,746

    Re: Cross-Computer Macro Issue

    Hi betherzy

    I'm sorry I was unable to help. WHEN you get it fixed, please post the Solution to your Thread. It'll benefit all of us.

    You're welcome...glad I could help. Thanks for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Will it do any harm to the computer if I ignore the Overflow issue in Excel 2002
    By kwfine in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-03-2014, 07:53 AM
  2. flat file for computer issue logging purposes
    By runt1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2010, 03:07 PM
  3. Auto Filter on my home computer differs from my work computer.
    By Sbova0226 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-08-2009, 03:04 PM
  4. Cross platform issue
    By redcow in forum Excel General
    Replies: 1
    Last Post: 11-10-2006, 12:10 PM
  5. A Ruby/Excel issue - Cross posted from Miscellaneous
    By seabird20 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2006, 11:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1