+ Reply to Thread
Results 1 to 4 of 4

GetLongPathName - VBA7 / 64 bit version?

Hybrid View

mc84excel GetLongPathName - VBA7 / 64... 01-12-2015, 06:53 PM
Leith Ross Re: GetLongPathName - VBA7 /... 01-12-2015, 07:13 PM
mc84excel Re: GetLongPathName - VBA7 /... 01-12-2015, 08:05 PM
Leith Ross Re: GetLongPathName - VBA7 /... 01-12-2015, 08:26 PM
  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    GetLongPathName - VBA7 / 64 bit version?

    I cant find a 64 bit version of API GetLongPathName. Am I missing something?
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

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

    Re: GetLongPathName - VBA7 / 64 bit version?

    Hello mc84excel,

    Private Declare PtrSafe Function GetLongPathName Lib "Kernel32.dll" Alias "GetLongPathNameA" (ByVal lpszShortPath As String, ByVal lpszLongPath As String, ByVal cchBuffer As Long) As Long
    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!)

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: GetLongPathName - VBA7 / 64 bit version?

    Quote Originally Posted by Leith Ross View Post
    Hello mc84excel,

    Private Declare PtrSafe Function GetLongPathName Lib "Kernel32.dll" Alias "GetLongPathNameA" (ByVal lpszShortPath As String, ByVal lpszLongPath As String, ByVal cchBuffer As Long) As Long
    Thank you +1

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

    Re: GetLongPathName - VBA7 / 64 bit version?

    Hello mc84excel,

    You're welcome.

+ 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. Get code that works on excel version 2007 to work on version 2010
    By Agent1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2014, 01:23 AM
  2. MDAC version and ADO version (Run-Time error '430')
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2014, 01:48 AM
  3. [SOLVED] Macro to determine version of excel version
    By dare2join in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 01:21 AM
  4. Replies: 3
    Last Post: 06-16-2005, 11:05 PM
  5. Replies: 1
    Last Post: 05-11-2005, 11:06 AM

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