Search results

Dear Friends, I am importing a .CSV file into my project, then after editing and alteration through VBA code, I export it in .TXT format. Till here everything is going fine. What I want is that, when a user exports the file, the FileDialogSaveAs box, must have the initial file name or say...

Do we have any easier way ? Please suggest Regards Achal

Dear friends, Thank you all for your kind efforts to answer my question. Your answers were quite helpful. I have tried a little easier way and it worked for me. I put a text box named txtexpdate, on the form and in the query ( design mode ), in criteria I have put this : Like "*" &...

I am extremely sorry about creating the confusion. Let me explain you. I download the csv file. Sort by INSTRUMEN & EXPIRY_DT. I require the rows with the “INSTRUMENT” = FUTIDX & FUTSTK and “EXPIRY_DT” = ( The date of last Thursday of month, in this case, current month’s date is 25-06-2015 )...

Thank you namliam for your guidence... ! Regards Achal

Yes Sure vbaInet, Attached is the file I download every day. 1. Sort by first column "INSTRUMENT" then sort by "EXPIRY_DT", Then delete other rows, then delete the columns "A", "D", "E","J","L" and "N", then change the date format to "mm/dd/yyyy" and then cut the column DATE and pase it on the...

Dear vbaInet, The file I download for edit is of .CSV format and I tried a lot but the attachment window says every time : Invalid file & does not get attached. I tried to cut down the file size by deleting rows and from 2.05 mb to made it 100 kb but still it did not help. Pasted all the...

vbaInet, Thank you for your valuable suggestions. I have tried a lot but it was not working so I started making a database in access. But I will surely try to find the answer in excel too. Regards Achal

Hello vbaInet, First of all thank you for replying. And yes, I have tried to do it in excel but the I thought of Access as the CSV file I download, the numbers of records it contain are ever changing. More over, I have 5 / 7 dates including 3 / 4 current months date and some next and next to...

Hello, I have a CSV file and want to convert it in a text format with some filtered data and with some formatting. This is an everyday task for me. So I made a table and imported the data in to it by the command : DoCmd.TransferText acImportDelim, "fo Import Specification", "fo"...