analyst

We have shared drives at work with macros in different excel spreadsheets. These macros work fine for my colleagues, but not for me. I am using the same excel file as them so I am puzzled as to why I get blocked with the error message ‘\USFIDATAFUTURES$ICEBNUBNU_MBCAA_YYYY01DD.csv’ cannot be found. Check your spelling, or try a different path.

when I copy and paste this link in my browswer, it’s fine and I can access the folder.

This is the macro in question, with the issue/bug in bold and highlighted:

Sub LoadMBCAA()
‘ ImportMBCAA Macro
 Dim Wb As Workbook
    Set Wb = ActiveWorkbook
    Set Wb = ThisWorkbook
    ‘ This macro will open the BNU MBCAA file of the day’
    Sheets(“BNU_MBCAA”).Select
    Columns(“B:L”).Select
    Selection.clearcontents
    Sheets(“Sheet1”).Select
    PathName = Range(“B4”).Value
    Filename = Range(“A2”).Value
    TabName = Range(“D5”).Value
    ControlFile = ActiveWorkbook.Name
    Workbooks.Open Filename:=PathName & Filename
    Range(Selection, Selection.SpecialCells(xlLastCell)).Select
    Selection.Copy
    Wb.Activate
    Sheets(“BNU_MBCAA”).Select
    Range(“B1”).Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
        Range(“A1”).Select
              ActiveCell.Copy
        Workbooks(Filename).Close
        Sheets(“SUMMARY”).Select

 

when I hover the mouse over the yellow, I see Filename = ”BNU_MBCA_YYYY01DD” under PathName I see the drive path and under FileName I see the file name. So I’m very puzzled as to why it’s not working and cannot get picked up.

if anyone can help, I will be forever grateful.

By: michael

88 thoughts on “analyst

  1. Shila Modugno

    I do like the way you have presented this particular matter plus it really does provide me personally some fodder for thought. However, coming from just what I have experienced, I simply just wish when the opinions stack on that folks stay on issue and not get started on a soap box involving the news du jour. All the same, thank you for this fantastic piece and though I can not concur with the idea in totality, I respect your perspective.

  2. rachel cusk mother

    Hello there! I know this is kinda off topic nevertheless I’d figured I’d ask. Would you be interested in exchanging links or maybe guest writing a blog post or vice-versa? My blog addresses a lot of the same topics as yours and I believe we could greatly benefit from each other. If you are interested feel free to shoot me an e-mail. I look forward to hearing from you! Awesome blog by the way!

  3. rachel cusk on becoming a mother

    I’m really loving the theme/design of your weblog. Do you ever run into any internet browser compatibility problems? A few of my blog visitors have complained about my website not working correctly in Explorer but looks great in Safari. Do you have any tips to help fix this issue?

  4. maids

    Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why throw away your intelligence on just posting videos to your blog when you could be giving us something enlightening to read?

  5. 1cover pre existing medical

    Appreciating the persistence you put into your site and detailed information you provide. It’s awesome to come across a blog every once in a while that isn’t the same out of date rehashed information. Great read! I’ve bookmarked your site and I’m adding your RSS feeds to my Google account.

  6. travel blogs to read

    I was curious if you ever thought of changing the page layout of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or 2 images. Maybe you could space it out better?

  7. hdfc travel insurance

    Howdy would you mind sharing which blog platform you’re working with? I’m going to start my own blog in the near future but I’m having a hard time making a decision between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I’m looking for something unique. P.S My apologies for getting off-topic but I had to ask!

  8. international family vacations

    Hello! This post could not be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thank you for sharing!

  9. langkawi blog

    With havin so much written content do you ever run into any problems of plagorism or copyright infringement? My website has a lot of completely unique content I’ve either written myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any ways to help stop content from being ripped off? I’d certainly appreciate it.

  10. travel insurance cover cruise

    Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your blog? My blog is in the very same niche as yours and my visitors would really benefit from a lot of the information you provide here. Please let me know if this alright with you. Thank you!

  11. lonely planet top 10 cities 2019

    Greetings! I know this is kinda off topic but I’d figured I’d ask. Would you be interested in exchanging links or maybe guest authoring a blog article or vice-versa? My website goes over a lot of the same topics as yours and I feel we could greatly benefit from each other. If you might be interested feel free to shoot me an e-mail. I look forward to hearing from you! Wonderful blog by the way!

  12. Blueberry CBD Lip Balm

    I was wondering if you ever considered changing the structure of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two pictures. Maybe you could space it out better?

  13. good family holiday destinations

    Hi! I realize this is sort of off-topic however I had to ask. Does managing a well-established website like yours require a lot of work? I am brand new to operating a blog but I do write in my diary everyday. I’d like to start a blog so I can easily share my experience and thoughts online. Please let me know if you have any recommendations or tips for brand new aspiring blog owners. Thankyou!

  14. ig

    We’re a group of volunteers and starting a new scheme in our community.
    Your website offered us with valuable info to work on. You’ve done an impressive job and
    our whole community will be thankful to you.

  15. Iva

    Hey just wanted to give you a quick heads up and let you know a
    few of the images aren’t loading correctly.
    I’m not sure why but I think its a linking issue.
    I’ve tried it in two different browsers and both show the same results.

  16. how to start a cleaning company

    I don’t know if it’s just me or if perhaps everybody else experiencing issues with your blog. It appears as if some of the written text within your content are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them too? This may be a issue with my web browser because I’ve had this happen previously. Appreciate it

  17. jimmie rivera vs marlon moraes

    I was wondering if you ever thought of changing the page layout of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two images. Maybe you could space it out better?

  18. page

    Valuable information. Lucky me I discovered your website by chance, and I am surprised why this accident did not happened in advance! I bookmarked it.

  19. Jame Nicklous

    What i do not realize is actually how you’re now not actually a lot more smartly-appreciated than you may be now. You’re so intelligent. You realize therefore considerably when it comes to this matter, produced me in my view imagine it from numerous various angles. Its like men and women are not involved except it is something to accomplish with Girl gaga! Your own stuffs nice. Always handle it up!

  20. Stephenie Cimo

    Hey there! I’ve been following your site for a while now and finally got the bravery to go ahead and give you a shout out from Humble Tx! Just wanted to mention keep up the great work!

  21. Buy Supplements

    Thank you for sharing excellent informations. Your website is so cool. I am impressed by the details that you have on this website. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found simply the info I already searched everywhere and simply couldn’t come across. What an ideal web site.

  22. mastermind toys jobs

    Hey there! I know this is kind of off topic but I was wondering which blog platform are you using for this website? I’m getting tired of WordPress because I’ve had problems with hackers and I’m looking at options for another platform. I would be great if you could point me in the direction of a good platform.

  23. Leonardguata

    I appreciate reading through your web sites. Regards!

    [url=http://bloggg.org/site-map/]http://bloggg.org/[/url]

  24. reference

    Hey! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no back up. Do you have any solutions to stop hackers?

  25. Duncan Mullenbach

    Attractive section of content. I just stumbled upon your website and in accession capital to assert that I acquire actually enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently quickly.

  26. John Deere Service Manuals

    Simply desire to say your article is as astonishing. The clarity in your post is just great and i can assume you are an expert on this subject. Fine with your permission allow me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please keep up the gratifying work.

  27. types of gallstones

    Superb website you have here but I was curious if you knew of any forums that cover the same topics discussed in this article? I’d really love to be a part of group where I can get opinions from other knowledgeable people that share the same interest. If you have any suggestions, please let me know. Appreciate it!

  28. creare site web bucuresti

    Hey there would you mind stating which blog platform you’re using?
    I’m looking to start my own blog soon but I’m having a
    difficult time selecting between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your design seems different then most blogs and I’m looking for something unique.
    P.S Apologies for being off-topic but I had to ask!

Comments are closed.