+ Reply to Thread
Results 1 to 7 of 7

I have a macro that work properly in Win32 but not in Win64!!

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    Toronto,Canada
    MS-Off Ver
    Excel 2010
    Posts
    60

    I have a macro that work properly in Win32 but not in Win64!!

    Hi everybody,

    I'm trying to transfer an excel/2010- based program from a laptop(Win32) to a desktop(Win64). All Macros are working perfectly except one Macro which is not working and I get the debugging message "Run-Time error "1004" and yellow highlighting of the line "ActiveWorkbook.SaveAs Filename:=Path......

    the Macro I'm using is:
    Please Login or Register  to view this content.
    I do not know where is the problem?, is it Win32 Vs Win64? or something else?.Is there any idea?
    Thanks in advance
    Last edited by Leith Ross; 06-22-2013 at 05:35 PM. Reason: Add

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: I have a macro that work properly in Win32 but not in Win64!!

    Hi Karim,

    Just a blind shot..
    Check for any special character in Range (E5, E3, F3, H3)
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: I have a macro that work properly in Win32 but not in Win64!!

    Please Login or Register  to view this content.
    Please click the * below if this helps

  4. #4
    Registered User
    Join Date
    03-19-2013
    Location
    Toronto,Canada
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: I have a macro that work properly in Win32 but not in Win64!!

    Thanks Debraj Roy & JasperD for reply.
    What do you mean by special character?
    Actually, two ranges are just customer names , one range is a date of birth and the last one is a function (=Today() ).

  5. #5
    Registered User
    Join Date
    03-19-2013
    Location
    Toronto,Canada
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: I have a macro that work properly in Win32 but not in Win64!!

    Hi JasperD,

    Unfortunately, this code did not work and I got the message: Compile error: Expected:List separator or)

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: I have a macro that work properly in Win32 but not in Win64!!

    Hello karimretina,

    Have you created the folder Records on your desktop's "C:" drive?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: I have a macro that work properly in Win32 but not in Win64!!

    Perhaps:

    http://msdn.microsoft.com/en-us/libr...(v=vs.90).aspx

    "The full path of the Microsoft Office document includes the drive letter or server name, and all characters and folder names up to and including the name of the document. The entire path cannot be longer than 242 characters in Word, or 218 in Excel."


    Is your folder structure different on the new machine? How long are the customer name values? Does the total number of characters in the full file name exceed the limit?


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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