Hello, could you please help me with this.
I just want my userform to use the data source of it from closed workbook.
Macro Book.xlsm is working okay but it needs to open the data source to be it work fine.
I've attached the sample.
Hello, could you please help me with this.
I just want my userform to use the data source of it from closed workbook.
Macro Book.xlsm is working okay but it needs to open the data source to be it work fine.
I've attached the sample.
Last edited by patel45; 03-16-2013 at 03:49 AM.
If solved remember to mark Thread as solved
Hi patel, where should i paste the code? also, the closed workbook has multiple sheets. i'm new in vba
Last edited by puuts; 03-16-2013 at 04:07 AM.
why not open the data file ? i's the best solution for a beginner, otherwise you have to make many changes to your code.
Do you want read only the data ? not change them ? in that case need to open the file.
Last edited by patel45; 03-16-2013 at 04:55 AM.
It's because there are so many users that will used the userform. The main sheet(userform) will saved in the Shared drive and the date source will saved in my personal drive. We have too many systems/tools that were open and i that's why i want closed workbook as data source. Thanks for your reply.
******up******
Why would you save the data in your personal drive?
How will other users access it?
If posting code please use code tags, see here.
Hi Norie, it's because the data source is too large and we are not allow
to saved files in our main shared drive that are too large. Other users were also have
an access in my personal drive. I want the userform
to link the data source in my personal drive and it should be in close workbook.
Last edited by puuts; 03-16-2013 at 06:11 PM.
*****up*****
Fyi forum rules suggest waiting about 24 hrs before bumping. If you are in a hurry, pay sites might provide an alternative
*****bump*****
you have been asked not to bump your posts so frequently-bumping more frequently in response will not help you so please stop
Josie
if at first you don't succeed try doing it the way your wife told you to
Hello Joseph,Mokko,
sorry for spamming
Hello forum, is there anyone can lend me a hand on my problem, I'm stuck on this
Hello, can anyone help me on this?
Other users will not be able to access the workbook if it is in your drive, you're going to have to find another solution I'm afraid
Hi Kyle, thanks for reply. Actually other users have an access in my personal drive.
Is that a good idea?
Doesn't it make more sense to put the file in a folder/drive that everybody who needs it has access to?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks