Dear Expert
Can you please modify the following code to do the following
1- only export range of data from Column A : column G
2- date in column D export it as text but in format DD,MM,YY
3-export all data in the same format
4- if can add line to show confirmation message that saved
HTML Code:
Last edited by mazan2010; 03-17-2018 at 01:40 PM.
How about
Please Login or Register to view this content.
it copy data without format
and also copy date as 43094 but i need it text but like dd,mm,yy
Last edited by jeffreybrown; 03-22-2018 at 07:06 PM. Reason: Removed full quote
and can make message pop that if there is any file present in the same location and if you need to replace or give me choice to add with another name
and also can in this message show how many row have data
How aboutPlease Login or Register to view this content.
it give me error like in attached photo
Last edited by jeffreybrown; 03-22-2018 at 07:06 PM. Reason: Removed full quote
What is the error message & is col D in the original file actual dates, or just text that look like dates?
i don't know when i run macro its give me this errorOriginally Posted by Fluff13
yes column D is my date column starting from row 2
Can you please upload a test file?
please see my attached file
and there is problem after i activate the file i found the file size increase i don't know what happen
Thanks for the file, the problem was that you have blank rows.
TryPlease Login or Register to view this content.
its work now but the problem is size of the exported file is large around 25 mega
in my original file in range of row 300 have array formula but only data value can be range of 50 row ? its the problem or what ?
also count of the row have data give me incorrect number in my example the data only in 49 row but it give me 88 row?
Last edited by jeffreybrown; 03-22-2018 at 07:06 PM. Reason: Removed full quote
Does it work as expected on the test file you supplied?
yes but in my original file with lot of array formula and other normal formula give me incorrect count
Hello mazan2010,
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
HTH
Regards, Jeff
Ok, tryPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks