export

Good morning, At the non profit organization I work for, we use Blackbaud for fundraising purposes and we use Daxko for our membership software. We are able to get an export from Blackbaud that we can use to import data to Daxko, but Daxko requires a certain setup with columns and data which...

I have workbook names in sheet1. I would like to run the macro "Data Export" in each of these workbooks instead of macro below. If A new file/s files are added I need to amend the macro below each time There could be between 15 -20 workbooks on which to run the macro Sub Export_TB() 's()...

Hi to all, I have an excel file and I want to export the contents of text cells (range C2:D5) ... in a file.gcp (is a text file)....maybe someone has a VBA code ... to export values from range C2:D5 like this: MYTEXT A-z,1.00,2.00,MYTEXT Z-a (where 1.00=C2 and 2.00=D2) MYTEXT...

Hi, Need help to create macro to export certain selected sheets as separate pdf files. Steps are: 1. An excel file is open 2. It contains several sheets 3. It also contains a sheet named "Index" 4. Column A of the sheet "Index" contains name of some of the sheets form the same file. 5. Need to...

Hi guys, I’m fairly new to VBA, and would appreciate your help with the problem I have. (will look forward to learning lots through the forum going forth!) I have 12 xls files and 16 xlsx files that that get updated in the same folder every week. (same pathways to make Macro to work). Now...

I exported data to excel and while doing so it asked me if I wanted to save the steps, which I did. I would like to add a button to a report to run that saved export. Is there a way to do that? There are many users and a button on a form is easier than trying to teach everyone to use the Ribbon.

Hi Everyone! I'm digging around the ole Google world to see if something is possible or if software exists. I current can export a file from a vendor and it contains information that I want to import to another vendor. The issue is the column names do not match so I have to stop and tweak the...

Good evening, I manage a nursing shift roster for about 160 odd staff. I use excel to build and publish the roster and am currently looking at trying to export to a google calendar (or similiar). We use text code for the shifts (i.e. E = 0715-1545 & LM = 1445-2315). Currently the shifts are...

Hello guys, I am using excel for listing jobs I do for my clients, and I would like to know if it's possible to export the data and separate it to each client's record in the last month. I do it manually by filtering to view the last month and a specific client each time, and it takes a long...

I want to export a list of all folders on our FTP server to Excel. Can I do this and, if so, how?

I am using the code below to try and export my userform listbox contents to a new workbook. However, I am getting the error as I commented in the code. I dont know where I am going wrong with this code. Need help please! <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit...

I am trying to separate my file into multiple files based on an index sheet with two columns: the sheet name and the name I would like to save the new workbook as. Can anyone help create VBA code that will reference columnA (new workbook name) and export all sheets (based on their name in...

Hi All Can anyone point me in the right dircection to be able Export Multiple Userforms to PowerPoint or Excel as Screenshots using VBA? If its possible! I have the below code that will export the current Open Userform to an Excel Worksheet, but unsure how to adapt for a set of Userfoms...

Hi all, I'm trying to write a macro that saves a sheet as a unique name, varying upon the value of a specific field. For example a name I would be after would be "JR Export MAR". This is what I have so far, however it is't working. Sub Macro1() ' ' Macro1 Macro ' ' Dim Filename1 As...

I have a workbook used to create budgets for clients. Sometimes they want to have a copy of the budget in excel so I need to export the budget to another workbook that only copies values in cells, row and column height and width and cell formatting but not the formulae in cells. Some text...

Hello, I have a table that I need to export and save as a CVS file. Initially I had a code to export and save the table as a new excel file, with an specific name, but now I need to save data to csv format. I already tried but I was not able to change the vba code… Sub NewFILE()...

Hi, I have code to export a series of charts from a dashboard to images. The intention is to then disply them on TVs around the building I have code that will do that (HTML) but the charts are tiny :( They are nicely laidout for the dashboard but I need larger images for the TV Is there a...

Hi everyone, Is there any VBA code that allows me to make use of a userform and it will populate a new excel file with the headers selected? It will look and work like the picture above, where the different check boxes are linked to the different columns (headers) and user get to choose...

Hi, I have a multisheet workbook. One of these sheets contains various formulas. I want VBA to : export this one sheet to another file make that all fields in this file are values, so no formulas password protect the new file At the end of the VBA script, I wish that the new file is closed...

I have 20 worksheets, named page 1 to 20,with data. To enable me to export a selected number of pages to a .pdf file, I have given a certain range a name. Example, page1 cells A1:G10 and cells A100:G110 the name is Page1 but ( Page1_A1:G10,A100:G110 when viewed in the name manager) I then...