Engineer Joe
Well-known Member
- Joined
- Jun 10, 2005
- Messages
- 549
I don't have a clue how to do this in VBA, or even if you can, but here is what i'd like to do:
I want to make an excel file on our network 'available offline'. I'm going to put the code in the addin install event.
The reason is that I have made alot of 'HELP' Pop-Up userforms that have quite a bit of graphics and it has made my addin 5 meg bigger. I'd like to only load these userforms if the user actually hits the help button. I'd like to put all these userforms in a 'help' excel file that is only accessed when necessary. The only problem is that alot of the people using it will not be on our network at the time they are using it, thus I cannot specify a filepath to the same file on the network unless I make the file available offline to them. If anyone knows how to do this in VBA, then that would be very helpful. Thanks.
jpc
I want to make an excel file on our network 'available offline'. I'm going to put the code in the addin install event.
The reason is that I have made alot of 'HELP' Pop-Up userforms that have quite a bit of graphics and it has made my addin 5 meg bigger. I'd like to only load these userforms if the user actually hits the help button. I'd like to put all these userforms in a 'help' excel file that is only accessed when necessary. The only problem is that alot of the people using it will not be on our network at the time they are using it, thus I cannot specify a filepath to the same file on the network unless I make the file available offline to them. If anyone knows how to do this in VBA, then that would be very helpful. Thanks.
jpc
