#export

  1. A

    Export specified sheets to a new workbook using a browse box VBA. Keep the pivot data source issue.

    Dear community, Context: I am currently working on some macros that should do the following : 1. Open a (raw data file -.csv) as a new sheet in my .xlsm workbook -> Done 2. Refresh 9 pivots based on the file uploaded with point 1 (update data source of all pivots). The current setup is one...
  2. B

    Text too long while exporting to .xml or .txt files

    Hi, I want to export over 500 cells to separate .xml files. I wrote a macro in VB which is working (code below) but the exported text inside the exported .xml file is cut. The full text should have ~11500k characters and the exported one is ~8200 characters. I am missing the end part of the...
  3. A

    Excel VBA - Export data from webpage

    Hi. Good day everyone. I am writing a VBA application for an excel workbook, which contains information regarding multiple funds of multiple fund managers. In the worksheet, there is a "Update" button. When clicked, it grabs the returns and other information from the webpage and place them...
  4. N

    VBA to get Excel data and produce XML file

    Can you help me on the below? I have 2 tables in Excel. (images) I want these tables to be exported in XML in a certain format (see code below). <?xml version="1.0" encoding="UTF-8"?> <cbc:CBC_OECD xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:stf="urn:oecd:ties:stf:v4"...

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