export

I have the below code to select a range of cells and export it to a text file; however, the cells I am selecting contain formulas and after I export and open the text file I only get "#REF..... I think I need this to maybe paste the values instead? Please help... Sub ExportRangetoFile()'Update...

Hi there, I am trying to export data from a website example: https://www.flashscore.com/baseball/usa/mlb/ When I do, the data pasted from excel is shown vertically and not horizontally as on the website. Is there an easy alternative to get this data from the website to excel in a similar...

I've got the code below to save a report as a PDF at the click of a button. The button works fine, but whenever it is clicked, the report is also printed out. Does anyone know why this would be and is there a way to stop it from printing? Private Sub Command271_Click() Dim ReportName As String...

Hi Guys, Is it possible to export one column ("AT") from each sheet except for Master and Info from an Excel file and save as .txt file for each tab with the tab name as the file name in same folder? The row numbers are different in each sheet. They vary form 3 rows to 350 rows. Thanks Asad

Hi all Me again So I have another one that doesn't give me any errors, but it is also not executing the code. It gives the correct msgbox and filename but when pressing save absolutely nothing happens. It doesn't actually execute the code. Not sure why. Private Sub CommandButton3_Click()...

Hi all I am very new to VB and its mostly thanks to forums like this and a bit of internet searching. I have a Run-time error 424 - Object required issue Let me explain what I'm doing: I have a commandButton that actions SaveAs PDF The one button has to only export 2 specific sheets to PDF...

Hi Guys, Anyone who can help me how to transfer multiple tables from Access to Excel with specific file name and sheet name into a single workbook only? The code works fine for exporting a singe table but the code stops at "Set xlSheet1" 'SET UP EXCEL Dim FilePath As String Dim...

I run an export every month from Quickbooks - it is for accounting actuals for my company. It's a horrible format and not meant for external users. I'd like to create a more user-friendly template where, when I export the data, it automatically populates into my template as well. This would...

I have a very large table of 3 million records that I need to export out of ACCDB in chunks of 500k records at a time. They are sorted in a particular order so their Primary IDs are not sequential. I can easily export out the first 500k by setting the Top Values property to 500,000. Is there...

I cant figure out how to get a sub to 'Here is what I have: Sub ExportDeptOneKPI CallKPIPrint ("Dept One") End Sub 'This calls the below but how do I get the name in the spot with the ???????: SubKPIPrint (PDFPrint as String) Worksheets (PDFPrint).ExportAsFixedFormat Type:=xlTypePDF...

Hi everyone! I'm having some difficulties to find the correct code to do this. The workbook is pretty basic, it has a unique userform to enter data. I need an inputbox to prompt the user to specify a date and export it to a text file. All the data from the userform goes to one sheet ("CAE") and...

I am opening a CSV that is in the same folder as the macro workbook. I am getting an error on the Workbooks.Open line If I hit debug the file opens and the code continues. I can throw an On Error Resume Next in there and that solves it, but what is causing the error in the first place? Dim...

I'm thinking of upgrading from Office 2010 to 2019. I need to know if I'll still be able to read and edit docx / docm and xlsx / xlsm files created with Office 2010 read/edit in Office 2019 and files created in Office 2019 (Except new funcitons, of course) read/edit in Office 2010, without any...

Good afternoon everyone! I need to export multiple charts from multiple sheets to just one PDF file, but until now I couldn't do that. I only can export PDFs separetedely. Does anyone has a code to do that?? I've searched a lot in google and forums, but I wasn't able to find anything that could...

Hello all, I have several databases that hold different segments of an items history. 2 of these databases have parts of the information. I run this in Access and I get a table with my specs. I need to export the Excel file of this and then attach the database to update the query. When I...

I'm trying to export an Access report to a specific location with the file saving with a specific name that is linked to a form in the Access database. I have the below code. The problem is with the strSubject line. I'm not sure how to get the information from the form (the form is DateRanges...

Hello, I am building a user form which will be used for data input in some sheets in the workbook. In order to export the current progress without closing the form, using save as dialog, I want to export the workbook (copy sheets to a new workbook) using vba by clicking a button. But all I can...

So I have a file I export daily and currently I have my workbook perfectly but I have the columns of the export file in the specified order to work with my script when I pull the data from the exported file. What I am wondering is if it is possible to select the columns in the data file that...

For a couple of years, I've been using a macro in Excel on Windows 10 (running in Parallels on my Mac) that will export each worksheet in my workbook to a separate PDF, saving all of them in a Desktop Folder on my Mac called "ExcelPDFReports" . . . here's the code that works perfectly: Sub...

So I have over 1500 VCF files that I need to export to an Excel spreadsheet I tried the conventional Windows Import > Export way but it seems to be taking forever to convert just a few files Does anyone know of a free tool or a convenient way I could do this quickly? I am running Excel...