+ Reply to Thread
Results 1 to 9 of 9

macros wouldn´t work on other PC (same excel version)

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    29

    macros wouldn´t work on other PC (same excel version)

    good time of a day everyone!

    could pls anyone advise why a macros I recorded in my xls file wouldn´t work on other PC (the user has the same version of the excel - 2010).

    the code is simple - I added the ¨forms control button¨(not ActiveX controls) and recorded a macros that copies info from certain columns and pastes the content as values in different columns. I was using the recorder, tried saving it both in personal macrobook and ¨this workbook¨only, even äll open workbooks¨. the code is as follows:

    Sub ivansamsonov()
    '
    ' ivansamsonov Macro
    '

    '
    ActiveWindow.ScrollColumn = 2
    ActiveWindow.ScrollColumn = 3
    ActiveWindow.ScrollColumn = 4
    ActiveWindow.ScrollColumn = 5
    ActiveWindow.ScrollColumn = 7
    ActiveWindow.ScrollColumn = 8
    ActiveWindow.ScrollColumn = 9
    ActiveWindow.ScrollColumn = 10
    ActiveWindow.ScrollColumn = 11
    ActiveWindow.ScrollColumn = 12
    ActiveWindow.ScrollColumn = 13
    Columns("AM:AS").Select
    Selection.Copy
    Columns("Q:W").Select
    Application.Run "PERSONAL.XLSB!Macro11"
    ActiveWindow.ScrollColumn = 12
    ActiveWindow.ScrollColumn = 11
    ActiveWindow.ScrollColumn = 10
    ActiveWindow.ScrollColumn = 9
    ActiveWindow.ScrollColumn = 7
    ActiveWindow.ScrollColumn = 6
    ActiveWindow.ScrollColumn = 5
    ActiveWindow.ScrollColumn = 3
    ActiveWindow.ScrollColumn = 2
    ActiveWindow.ScrollColumn = 1
    Range("Q2").Select
    End Sub

    then when I send it to my colleague and try using this macro button I get an error declaring that the path to the macro is not found or smth like that. I also tried saving the xls file as ¨macro enabled¨format, nothing works, others can´t use it. can anyone help me with this? really important trick to master for me. many thanks in advance!

    cheers
    Last edited by ivansamsonov; 01-19-2014 at 06:41 AM.

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: macros wouldn´t work on other PC (same excel version)

    where is this file residing ?

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Registered User
    Join Date
    03-27-2013
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: macros wouldn´t work on other PC (same excel version)

    could you please tell me how I can figure out that?? to be honest not quite sure how all the storage process works? it is supposed to be stored locally on my PC , right?

    tho, when I go to the VBA editor by hitting alt + f11 I can see that this macro is located in the folder named ¨VBAProject (1.xls)¨- 1.xls is the name of the file itself

  4. #4
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: macros wouldn´t work on other PC (same excel version)

    try something like this,

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-27-2013
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: macros wouldn´t work on other PC (same excel version)

    lol do I get it right I paste it into the code?

  6. #6
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: macros wouldn´t work on other PC (same excel version)

    this is the code that is causing the issue in your file

    Please Login or Register  to view this content.
    now make sure that this file (PERSONAL.XLSB) is in the same folder as the file that is calling this macro.

  7. #7
    Registered User
    Join Date
    03-27-2013
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: macros wouldn´t work on other PC (same excel version)

    many thanks, man! help really appreciated

    tho to be honest I decided I need to read a bit more about the concept of storage/working of these things called macroses, 'coz I just can't get where I should look for the storage path, neither can't find where the programme would save all of the macroses..I've been looking for it for more than an hour and still couldn't manage to understand how all of this works

    anyway, this either has something to do with our local IT settings or settings of settings in excel programme set on my computer, 'coz when I did the same macro only on a different PC (PC of the colleague sitting next door - actually I tried it from 2 different PCs) and sent the files to myself - both of them work just perfectly. that's what amazed me. the same code but not working on someone else's PC when done on my PC and working the other way around

    anyway, thanks. I feel like I need to get to know the basics first, at least in order to understand the advices/questions given here

    such a shame lol I thought I know excel good, what a disappointment.

  8. #8
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: macros wouldn´t work on other PC (same excel version)

    @ivansamsonov,

    you are in the right place as far as getting to know excel and vba is concerned. Spend more time looking at issues that are posted on this forum and try your bit to solve the op's issues and i bet you will start enjoying it.

    The great thing about failures is that you will not repeat the same mistake again , so welcome and hope to see you around.

  9. #9
    Registered User
    Join Date
    03-27-2013
    Location
    Kiev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: macros wouldn´t work on other PC (same excel version)

    thanks a lot Mr. xlbiznes,

    I shall do that for sure! first of all I am already enjoying it and secondly since around 85% of time of my work is taking place in this very program it is just essential for me not a big fan of time wasting, so I'll need to master all those tricks you guys are writing about over here..! cheers and thanks again

    p.s. labeling teh thread as solved right away

+ 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. Save 2007 workbook to work WITH macros in 2003 version
    By clairebelle in forum Excel General
    Replies: 3
    Last Post: 01-23-2011, 12:42 PM
  2. Macros work in one version of Excel 2003 but not in another version of Excel 2003
    By John_Carroll in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-27-2009, 09:30 AM
  3. Macros from German excel don't work with English version
    By Klaus Heinrich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2005, 01:05 PM
  4. version compatibility of excel macros
    By AFlannery in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2005, 09:05 AM
  5. [SOLVED] How do I get hyperlinks, from previous version of excel, to work .
    By jeffreymiller1966 in forum Excel General
    Replies: 0
    Last Post: 03-25-2005, 12:06 PM

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