Pick Date from Column A instead of current date.

Request for some insights on this please...

Thanks much!

I see alot of Format (Now)...
Try the following:

Please Login or Register  to view this content.

This was appended to the back of some other code I was using and appeared to work for me...

Thank you in the first place for looking into this.

However, I have a couple of questions:

Will this enable me to pick the date from column A of my spreadsheets?

Where exactly do I apppend this in my code?

The code I posted works fantastically, but it only populates the current date. My data sheets have varying dates in column A.

Thanks!

No problem. First, let me state that I am fairly new to VBA programming.

That said, I would think that instead of the Format (Now), this would be placed. For example:

Please Login or Register  to view this content.

changed to

Please Login or Register  to view this content.

Is this you are copying from?

So kind of you

I'll give it a try and come back. Just to double confirm the changed snipppet will now pick the date from Column A of my rows in the excel file. Is my understanding correct?

Thank you!

Honestly, I don't know. I'm just going off the requirement.

It is my understanding that the (Now) bit pulls from the current system date and time. With a second look at your code, it appears logical to remove that bit...

Ya, you seem to be correct on that bit. My actual requirements is to bee able to pull the dates from Column A.

Guess I'll have to wait for some more help.

Thanks anyways and good luck!

Add me as a friend if you like we'll live and learn...

I got this fantastic code from Tigeravatar (One of the great people) out here.

Just modified it to meet my other request. Could someone please help me to change the:

Please Login or Register  to view this content.

So that the code in Post 1 picks the date from Column A of my spreadsheets instead of the current date.

Thank you.

Hello Dears,

I need s little assistance. Can someone please put on the right path with a small customization I am requesting.

Thank you and have a fabulous weekend!

Rgds,
ILI

As always works beautifully. Thanks much Tigeravatar.

Marking it as solved....with joy

I do have a small request and need a last bit of input. How do I ensure that the CSV files that get created have a maximum of 100 entries?

So technically, If I have a file which has 1000 rows that needs to be converted into a CSV file. I need to create 10 files with 100 rows each. The naming convention to have the sequence number (1,2, 3...10) at the end.

That is all. Very much appreciative of your help and expertise.

Thanks a lot!

Works great. Thank you!

Regards....
ILI