export

  1. T

    VBA loop through slicer and export multiple sheets to PDF (withoud hidden slicer items)

    Hi, I am using the below VBA to export to pdf based on a slicer. The main problem is that it is selecting those slicers that are not visible (no data). How can I have a loop with only visible slicers? HELP PLEASE! Sub Reporte() Dim sC As SlicerCache Set sC =...
  2. K

    Use excel to drive dropdown list in pdf

    I have a list of items in a spreadsheet which are maintained by a designated person to ensure they are current and applicable. I have created a pdf form which is pretty much empty apart from simple things like an email address, logo. I want a different designated person to open that form and...
  3. F

    Excel columns to multiple html files

    Hello everyone, I need your help. I have this table in excel: ID Something Else Subject Body file1 random Title1 Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. file2 random Title2 <!DOCTYPE html><html...
  4. D

    Need help with XML empty column

    This is part of my xml I can map everything just fine except <Lost_agreement /> After i export mapped XML, <Lost_agreement /> is missing. it becomes But <Lost_agreement /> part is crucial and must be. How can i achieve it?
  5. M

    Export Data with Macro

    Hi all, I can't for the life of me get this macro to work the way I need it to. I've gone through all the threads and I think I know what I need to do, but I'm integrating it wrong. So the intention is to copy the data in Potential Code (A6:T15) to the Data Dump sheet starting at A2 and then...
  6. R

    Export a textbox value as a text file

    I am trying to export the notes from a single textbox on a worksheet called "CONTENTS" to a text file. The code works well, but if I click "cancel" on the saveasdialog box, then it creates a text file in the location with the name "False". I'm assuming I need a statement to handle if cancel is...
  7. C

    Can I import an Excel Pivot table into Power BI?

    Hi and thanks in advance for any guidance on this. How can one export a dynamic (I can get static pivot tables) pivot table to Power BI from Excel? I exported two columns of data, summarized them with Excel to see what I was looking at, using groupings that are difficult to emulate in Power...
    • crezzy
    • Thread
    • excel export pivot table power bi
    • Replies: 1
    • Forum: Power Tools
  8. J

    VBA print to PDF - autofit to one page

    Good morning I have an issue with a piece of code where I'm unable to fit the pdf export to one page - the end column always spills onto a second PDF page. The code attached is part of a larger project, which all works fine, apart from this one export. I don't have much experience with page...
  9. R

    Save Current Sheet as PDF and Link that PDF in Access

    Hello! I am new to this forum and somewhat new to Excel/Access VBA. Have been able to find solutions to most my problems in this forum already except for this one. I have an excel workbook used for doing quotes. It's more like a form than anything. I want to use Access to store the quote...
  10. P

    VBA - Export Specific Column every 30 rows to .txt file

    Hi VBA Wizards, I have been battling to get this working. The purpose of this is that our customers need to enter a particular format to order in our b2b system. We have a problem with our ERP handling the .xml so limit the customer's orders in the b2b system to 30 lines per order. We would...
  11. A

    excel export to txt file without tabs

    hi Folks, I'm trying to make a post for a Fanuc milling machine. I've got most of it working now, except for one thing. The problem are the tabs behind the lines when exported to .TAP, the machine cant read these tabs. Is there an option to add to the code below so it leaves out these tabs? (I...
  12. W

    VBA Export selection of a Dynamic Array (FILTER) to new workbook

    Good afternoon, Is there anyway, using VBA, to export a particular range of data that's been populated with a dynamic filter from my current workbook to a new workbook? My current workbook has 5 sheets. I want to export a range of data from Sheet1 to its own workbook. In Sheet1, I have Columns...
  13. R

    Google Trips Export to Excel

    Hello everyone, I've recently become aware of the data that Google stores about your past trips/travel (not on Google Maps but the flight/hotel info extracted from Mail). It's on the /travel of Google website. Each trip is shown as a widget and you can click in to see the dates and travel info...
  14. D

    Export to PDF macro fails on Excel Office 365, not on Pro Plus 2019

    Hi, I have a button inside Excel workbook which exports certain pages to PDF with one click on a button. The Excel version I am using is Professional Pro Plus 2019 and my customers version is the same build, but an Office 365 version. If I hit the button in my version it works, but if my...
    • ddewilt
    • Thread
    • bad file name or number button error 52 export issue macro office 365 office professional plus 2019 pdf problem
    • Replies: 9
    • Forum: Excel Questions
  15. D

    Excel script to export chart in sharepoint

    hello to all. I am trying to create a script that extracts chart elements (in jpg) from excel to sharepoint. I'm currently using this script but without results: function main(workbook: ExcelScript.Workbook): ReportImages {...
  16. T

    format data

    Hello I am having a problem formatting data in excel, I am preparing this data to import into a database that i have created. the problem is as follows: the raw data i have is for multiple chocolate recipe's that are broken down into the following: Name of recipe weight of ingredients unit of...
  17. B

    Filter and save data as new workbooks

    Hi, Can you someone help me with below requirement. I have a worksheet with data until column Z. I have list of names as below in the column "AD"(strating from AD1) of same worksheet. Max Alex Harry Sam Sid I am trying to have a VBA code that loops through the list in "AD" and...
  18. J

    Macro Help!

    Hi I'm trying to create a Macro so from my worksheet by pressing a button it will export it as a PDF, but then save it based on 3 cell Values, C4, C6 & C8. C4 is a name C6 is a name C8 is a date I'm wanting it to save to a specific file location to: C:\Users\Vector\Google Drive\H_O...
    • JFORTH97
    • Thread
    • cells excel export export as pdf file name save macro pdf
    • Replies: 14
    • Forum: Excel Questions
  19. X

    Exporting Certain Cells to a New CSV - with Custom Headers

    Hello, Does anyone know how I could create a button in my workbook to export certain cells into a new CSV file? For example, here is some data: Cell A1: John Cell A2: Doe Cell A3: Irrelevant Cell A4: Irrelevant Cell A5: Manager Name Cell A6: Job Title I would like to be able to pull cells...
  20. A

    Exporting tabs in a range as values

    Hi, I have a file with a lot of tabs and have had a macro (below) thats always worked fine. It basically exports specific tabs into a new workbook with all the data in it moved across as values. However now I want it to export a number of tabs but rather then specifying the tabs in the code I...

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