First of all, just as suggestion, take a look at the Forum Rules.the first is
more of a recommendation than a rule, since violating it doesn't get you banned
from the group, but it COULD make it take longer to get an response:
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
Because, to ME no issue posted is urgent.It doesn't affect MY job.And no one is
waiting for results from ME.Therefore, seeing "Urgent!!! Urgent!!! Urgent!!!"
simply wastes my time.
In the past, I've set my email filter to move anything with "urgent" in the
subject line to my Junk folder.But since I've become responsible for another
site, I've had to "relax" my email filters.
In the mornings, before I begin my day I often like to take the time to see if
there's a question I can contribute to.Messages that choose to spend more time
describing how "urgent" their issue is instead of spending the time describing
the issue suggests to ME that question will be incomplete and spend more of MY
time just to get to the issue at hand and therefore get moved to the bottom of
the list.
In your case, you've added a specific requirement:"Only copy paste , no copy
paste special"
This requirement forces the macro to utilize the system clipboard to copy the
entire cell content and formatting to the clipboard and then copy it from the
clipboard to the new file.
>From a programming perspective, this is "sloppy" and potentially utilizes
>system resources that may be insufficient.In addition, if the macro must run
>for any length of time, if you happen to select something from another window
>(like checking your email while it runs) then you run the risk of accidentally
>copying something to the clipboard that then gets incorporated into the
>running macro.
Nevertheless,
What have you attempted?have you Googled anything?Choosing another file to open
is accomplished with a FileDialog.Many examples are available.
Creating a macro to copy/paste is a simple use of the macro recorder and some
modifications to clean it up a bit.Depending on how it is to be used in the
future.
Based on the "Urgent" need, and the limited description of the issue,Is this a
classroom assignment that you're hoping that this forum may be used to complete?
If so, I'm sure someone here would be willing to help you work through how to
accomplish the assignment rather than simply do the assignment for you.
sorry if I've spent time I COULD'VE used to write code but instead vented my
disappointment.
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
On Monday, December 11, 2017 4:52 AM, rathi rupenzala
wrote:
Hi team,
Please help to code to pick a file from the folder , and just copy paste the
data to the current/active workbook.
Only copy paste , no copy paste special
--
With Regards,Rathi Alageshu.--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you
