I have a macro that prompts a user to open a file and then it copies the data
I need the code amended to select a specific workbook "Sales Data by Branch.xlsm"
Please Login or Register to view this content.
See full code
Please Login or Register to view this content.
It would be appreciated if someone could assist
Why not just Workbooks.Open if you know the name and path of file?
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Try below code ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
I tried using
Please Login or Register to view this content.
I get a run time error "object doesn't this property or method
Kindly amend
Thanks
Howerd
Nope...As per post 3
Many Thanks for the help nankw83
My apologies Sintek, I overlooked Post # 3
Glad to help & thanks for the added Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks