Hey guys! i am relatively new to using VBA but I have fair experience in C and Matlab. I was wondering whether anyone could help me out. I want to write code so that at the push of a button you can browse and find an ascii file. Select it. and then it will go into the sheet of a excel file that you chose in the code.
Any suggestions or code would be awesome!
Thanks
Glen
Look at this link
http://www.mrexcel.com/forum/excel-q...lications.html
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 Alan. So here is where im at. It works except i need a way of getting the file name when i select the file as well as the path name. As currently it is not working when it gets to which sheet to post in section. Any thoughts?
Please Login or Register to view this content.
Last edited by alansidman; 04-22-2014 at 08:01 AM. Reason: Added code tags
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks