1. P

    Stuck, Need Help (please). Trying to export unstructured text from PDF to import into Excel separating/placing text into specific columns

    Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...
  2. F

    Best way to automate the reformatting of this?

    I don't know how to best deal with getting my example onto this post, so forgive the copy pasta. Below is an example of how my company's system exports reports in Excel (there is no CSV, or un-formatted option for export). So, the employee's name is sort of randomly inserted at the top of...
  3. R

    Create .TXT Subsets based on existing Excel data using VBA Macro

    Hello Guys, I need to create Subsets for the data which I have, which is dynamic, using Excel VBA. I have data in the form of table, whose column headings are Code, % & Transaction ID as the below table. Code % Transaction ID 1001 42.10% 455152 1001 42.10% 455153 1001...
  4. G

    Exporting to Web-page problem

    Hello to everyone, after weeks of unsuccessful attempts I kindly ask for an opinion. It concerns exporting the print area of XXX.xls Sheet1 to web page (.htm); the xls sheet contains data and images (jpg, gif …. imported from the outside). Well, with an old Excel 2003 (on Windows 10) there are...
  5. X

    VBA excel code - to update spreadsheet based on the date

    Hi All maestros of excel VBA, I am writing here to receive maybe some help, advise how to write a right code. Given: I have my excel macro sheet .xlsm in which i am trying to pull data from the archive folder based on the date. For example in .xlsm file in the cell B1 I have a date. In...
  6. O

    VBA: how to skip a RANGE of columns when exporting to .TXT?

    Dear community, I have an Excel table to be exported to TXT in Unicode encoding with data separated by tabs (these 2 criteria are important) and i want to skip the range of columns: from C to G. Everything that is before C and after G should be exported. Which VBA code will be able to do that...
  7. S

    Export/Save images loaded to userform to a specific folder

    Hello, Can I please have your help to create a code that allows me to export image1 and image2 to a folder name that changes based on every new entry. The images will be loaded to the user form by click the image shape in the userform. I would like to export or save the images on the a folder...
  8. N

    VBA for saving values in one column to text file

    Hello, New to the forum. I've learned a lot just reading. Wondering if someone can help me with the VBA code below. It DOES save the whole worksheet to a text file, but I would like it to also Only save content in Column K Skip over blank cells in Column K Sub saveText()...
  9. S

    Export excel sheet as PDF to an existing folder

    Hello, I am looking for a code that allows to export an excel sheet as PDF that has name TARA-19-001 to an existing folder that was previously created with the same name in the following directory C:\Users\SSF1590\Desktop\TARA Project\Folders . The name of the file will change every time a new...
  10. kpasa

    Export Table as HTML with Formatting AND Filter capabilities

    Is it possible to export a table with filtering capabilities? I know it's possible to get formatting, but I cannot figure out if filtering is possible.
  11. S

    [VBA] export selected range as PNG with enhance resolution

    I found the following code in exporting selected range into PNG. It works well. However, the displayed image is a bit non-smooth, especially the font. Is there a way to enhance the export resolution? Thanks. Sub CommandButton56_Click() Application.ScreenUpdating = False...
  12. lockarde

    Exporting Userform design and code to import in VB

    Hello all, I've recently created a userform within excel to take care of some quick calculations I regularly have to do. After getting it all set, I thought, why not make it a stand alone app, instead of having to run excel everytime? I tried exporting the userform, and I get two files, one...
  13. S

    Exporting & Importing Macro with VBA

    Hey all, I'm trying to move a module to a new Workbook and assign it to a shape I can Export/Import it but when I assign it I'm assigning the macro from the Original, not the New Workbook. The New Workbook's name will change each time it's run. I don't know how to code a variable into the...
  14. dispelthemyth

    Extracting modules from a different workbook via VBA? (corrupt file)

    I have a corrupt file that i cant expand the project view on meaning i cant get to the point of seeing the modules and right clicking to export (it is password protecting and i am able to enter the password successfully) Is there a way to export these modules using VBA when inside another workbook?
  15. A

    Poor Resolution of Exported Chart

    I am using Excel VBA to copy some cells containing text (with formatting), copy them as a picture, paste the picture into a chart, export the chart as a .jpg file, and load the picture into a UserForm. This works beautifully when I use my home computer to remote desktop into my work computer...
  16. F

    Export only filtered data to new workbook

    I have a workbook which contains data for all of our vendors. It is set up to filter every sheet based on a dropdown on the first sheet. I would like a ‘button’ to create a new workbook containing the formulas, buttons, formatting, etc. from the original - but only with the selected data. I...
  17. 2

    MS Access auto/scheduled report export.

    Hello All, Is it possible to run MS Access report export (to MS Excel) by a user that does not have MS Access? I need to share report that uses data over ODBC to multiple remotely located users. Not all of them have MS Access. I was wondering if there was a way they could run export that would...
  18. S

    Automatically Reorder 77 Columns based on row 1 contents

    We have a system with an excel export, but the columns are not in the order we need, nor are they even in the same order each time we perform this export. Is it possible to redefine the columns in Excel with some VBA? I would want this done based on the contents of A1 through CY1. These...
  19. L

    Export Excel chart to pdf with layers

    Hi Everyone, I was curious if anyone knew of a way to export an excel chart to PDF of which will include a layer for each data series. The ultimate goal is the ability to send a client a series of charts which they will be able review and turn on/off the different series, some of which overlap...
  20. mikecox39

    Getting spreadsheet to someone without XL

    I need to the data on a spreadsheet to someone who probably doesn't have access to XL. It though about printing it out, then scanning it back in as a jpg file but that seems lame. There must be a better way. I looked for an "export" option but only found a "share" option but the receiver...

Some videos you may like

This Week's Hot Topics