Need VBA Code to upload a file

[Shweta]

Hi All,

I have created a userform to upload the data from the notepad into sheet1 of my workbook.

I want when I press the command button named as "upload", all the data from the opened notepad get uploaded into my worksheet.

Can someone please help me out with a VBA Code on this?

Thanks,
Shweta

 

[Andrew Poulsom]

Why do you need Notepad? Can't you just open the file directly?

 

[Shweta]

Thanks paulsom for the quick response.

I am working on a payroll project in VBA.I have to upload the Attendence data that is in notepad into my file on daily basis.

I can just copy the data from notepad and paste it into my worksheet. But I want to do it in a impressive way.

There should a command button on my worksheet. When I click on that command button, a userform should be open. On the userform there should a option to upload the data. When I click on that it should ask for the path.

 

[Andrew Poulsom]

Look here:

http://www.dicks-blog.com/archives/2004/06/09/getopenfilename/