mapped

  1. V

    Want to change Chart Y axis values based on chart data points

    Hi All I have the below raw data and i want to create a Stacked column chart in excel 2010. I have created the chart but only concern is the values of Data points is not aligning to Y axis bar. Can anybody tell me how to attach the excel file which i did so that it will be helpful to you to...
  2. E

    Excel Macro exporting to sheet as pdf to sharepoint

    I am new to VBA and have to complete a task for my manager about saving sheet as a pdf into sharepoint (if firstly can be done) which creates a folder at the location with the same name as the saved PDF and saves the pdf there.Now where it gets harder for me is at the location in sharepoint...
  3. J

    Map drive to a local folder using vba

    Hi all, I've done a fair amount of searching and trying different methods myself; however, I am unable to map a drive letter to a local folder on my machine. This thread shows how to map to a network drive, and it works well for actual network locations...
  4. J

    Drive mappings and opening files

    Came across an interesting situation. when i have a network drive mapped by name (I.e. \\servername\share) i can open a spreadsheet with no problems. however, if the network drive is mapped by IP address (I.e. \\10.1.1.1.\share) it tells me the file is corrupt. Very odd i must say. This is...
  5. JackDanIce

    VBA, VLOOKUP possible in EVALUATE function? Results not as expected

    Hi, I have a two column VLOOKUP table, which currently I'm passing to a dictionary object to replace output with mapped data. I'm trying to see if I can reduce the amount of code by using VLOOKUP within EVALUATE, so far have tried: Sub test() 'F5:F8 With Cells(5, 6).Resize(4)...
  6. P

    Find drive letter of a mapped drive

    Hi, I know there is a way to do this, can't find it in the forums. Basically, everywhere at work is mapped to the same network drive, but it isn't dictated which letter they have used. So, for example, my V:\ drive may be the same as someone else's S:\ drive. I need code to check all mapped...
  7. M

    Network path in footer

    I know how to get the file path in the footer by using &[Path] but I was wondering how to get the network path. Instead of: S:\share\pathname\ I wanted to get \\server-1\share\pathname\ because different people's S drive would be mapped to a different server depending on where they are...
  8. N

    Ignoring of a fixed attribute when exporting XML data

    Hello, I'm experiencing a problem with export of XML data from a mapped spreadsheet (MO 2016). Every values that are mapped as per *.xsd file are correctly compiled into a xml file. Unfortunately, the values of attributes that are in *.xsd file set to be fixed do not show up in the resulted...
  9. S

    Search Mapped Drives for File Name

    Is it possible to have vba search through all mapped drives for a file name and open that file? I am trying to make a previously written code bullet proof by giving the users the ability to have a file that the macro uses saved anywhere rather than force them to remember to save it to a...
  10. A

    Zip of multiple PDF files on the basis of employee name

    Want small help from vba experts, have data with multiple clients mapped to employee in Excel which later I am saving in . PDF file format of every client mapped on the basis of employee for I. G. Client1_emp1 Client2_emp1 Client3_emp2 Client4_emp2 Now want to zip on the basis of emp and send...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top