Hi,
I have only found one macro that has ever worked near how I want it to, however it exports all the data including the blank rows to csvExport selected field to CSV.txt. Is there a way for it to disregard these when exporting? Also it would be great if the export filename included the date from a cell within my workbook.
Any help is most gratefully received.
Thanks in advance..!
R
How about deleting the blank rows before you run the export macro
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thanks for that Alan..
My selection has data around it, and the blank cells have formulas, and the selection area is linked to other sheets, so I thought it best to somehow delete the blank rows in the csv export or have a macro to only export rows with values. I require this as I will be uploading the csv to a program that will stop if it gets to a blank row.
I was unable to get the macro you supplied to work. It said "overflow".. I am a complete novice at this, and appreciate your time & answer.
Kindest regards
R
Did you install the VBA using this method shown below? If you have formulas in cells, then the rows are not blank and will not be deleted.
A thought: When you export to the CSV file and you open the CSV file, do the "Blank" rows appear without any data or formulas in them? If that is true, then you could run a delete empty row macro on the CSV file before you send it to your third party application.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
I have just tried this in the csv export file and it works perfectly.. Many thanks for that.. I don't suppose there is a way of exporting the macro so it is in the csv file along with the data..?
Probably not, but if you create a personal.xlsb file you can store the macro in that file and will be available to you in any file you open. Here is a link on how to do that.
http://www.rondebruin.nl/win/personal.htm
This is how I keep all the macros I use regularly. It is a common practice among experienced Excel users.
good luck.
Alan
Great stuff..! Cheers Alan.. You have really helped me out..!
Thanks
Ryan
You are welcome and thankyou for the Reps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks