XP Macro Incompatibility
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: XP Macro Incompatibility

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    England
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Having a few problems running a Excel 97 macro within an XP environment. The macro

    Workbooks.Open FileName:= _
    "C:TestSL09" & Format(Date, "mmdd") & ".csv"

    was created in Xl 97 with NT4 SP6 but when i try to run it in Xl 97 with XP, I get the following error:

    Method of Object Workbooks failed

    Any ideas?

    Thanks

    Matt

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Im no VBA guru but i can say this XP is supposed to answer all problems it does not, also causes other issues.

    I would suggest re write in xp or record the code needed,, you say 97 in xp thats not as supposed to be shpuld match ie XP with XP thats the way Microsoft released these..

    There are compatability with XP and 97 VBA, im searching this and some code fail regardless what others say .. object rings bells as does change Directory for some reason, i recall there are a few odd bits..

    I hope a guru programmer will edit you code and it will work its not a big issue just a tweak,,,, sorry im not that good with source codes.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    858
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

    Matt,

    Here is the first thing to try:

    Run this macro on both the XL97 and XLXP systems:

    Sub TestIt()
    Msgbox "C:TestSL09" & Format(Date, "mmdd") & ".csv"
    End Sub

    See if one of them is failing to put the leading zero in the date.

    Also - this board is going to put a pair of slashes where I typed just one slash.

    Bill
    View a collection of recent Excel articles in the Excel Daily News

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    England
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Bill

    Have tried the macros both with the same result, the leading zero appears.

    thanks

    Matt

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    England
    Posts
    212
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Having tried a few other things, I have found out the problem is opening CSV files that are on the network. The macro code appears to be OK, it will open XLS files quite happily on the network, it will even open CSV files locally but will not open CSV files on the network. Have installed all Excel 97 components, perhaps there is some option that I need to enable. Does anybody have any other ideas?

    thanks

    Matt

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi mate

    not much help but some heart, XP im having fum with Win that is and Excel im finding it hard to say Win or Excel to blame.... E97 and Win XP sounds like agro from what i see XP Win reallyneeds to go with Office XP worst Office 2000. why dont know guess made that way, time will help us but for now.. a pain.

    I have issues with vba in XP Win + Office from Win 95 and Excel 97

    with application


    and calculate..

    this drives XP mad??? why..

    also protection in VBA , seems some code changes, cant see it..


    I have issues where If missing for no reasons, and with blocks, and all came down to where i added

    end case.. ie before default back to network settigs

    user profile, where to save docs, page setup..

    ??? odd i take time to revert back to default on compleation of VBA, XP hates this ???

    little help but , maybe help...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com