export

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...

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...

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...

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...

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...

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...

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...

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()...

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...

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.

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...

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...

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...

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?

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...

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...

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...

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...

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...

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...