Copy from notepad

[aviadht]

Can i copy values from "Notepad' using VBA ?

Thanks,
Aviad

 

[Andrew Poulsom]

Why don't you just open the text file in VBA?

 

[aviadht]

I want the VBA to open a notepad from the desktop and then copy "All values". In the end th vba will paste it in an excel sheet.

Is it possible?

Thanks,
Aviad

 

[Andrew Poulsom]

Why don't you just open the text file in Excel, or use a Query Table?

 

[aviadht]

what is a query table ?

 

[Andrew Poulsom]

what is a query table?

It's what's created when you retrieve external data. Look here:

http://office.microsoft.com/en-us/e...ry-to-retrieve-external-data-HA010099664.aspx