I'm pretty new to macros, but thought I could handle this... I cannot!
I'm trying to create a macro which will do the following actions:
1) open a file named C:\Users\bfrah\Documents\My List.xls
2) select Sheet named USED and select columns Z through AE and Copy them;
3) Close this file without the prompt to save;
3) Now paste the data into the open document, Sheet named USED, into columns Z through AE
Not good with VBA but this could get you a start
open excel
Please Login or Register to view this content.
Press Alt+F11 to open VBE Editor
At the top you will find Insert----> module
In module COpy paste above code
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks