The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Deploying my blood, sweat, and tears to coworkers.
Drez
Registered User regular
Registered User regular
So I went to school for programming but never really used it. Putting aside an irrelevant history lesson, I am now re-acclimating myself to programming and have been teaching myself VBA, mostly for Excel, but also for Access as well as Powerpoint. For the last six months or so I've worked on automating a number of processes as my current place of employment.
My question is whether or not there is a simpler/better way to deploy my code to people within my department than manually installing (read: importing) my .bas files to some kind of personal macro workbook on their system. It is cumbersome to do this, especially if I need to install it for multiple persons, and if I need to update something, I need to manually update everyone's system. Not to mention, most non-programmer folk (especially accountants) find this process excessively intrusive almost to the point where you would think they are technophobes.
Note: I am not an IT guy. That is to say, I don't work in IT, am not able to do administrator-y stuff within the network, and am not even a local administrator on my own machine. I'm just some guy, you know? But seriously, without having some kind of skeleton key to my company's (very strict) network, is there some method I can use to seamlessly deploy easily-upgradeable macros to multiple people, or am I pretty much boned?
My question is whether or not there is a simpler/better way to deploy my code to people within my department than manually installing (read: importing) my .bas files to some kind of personal macro workbook on their system. It is cumbersome to do this, especially if I need to install it for multiple persons, and if I need to update something, I need to manually update everyone's system. Not to mention, most non-programmer folk (especially accountants) find this process excessively intrusive almost to the point where you would think they are technophobes.
Note: I am not an IT guy. That is to say, I don't work in IT, am not able to do administrator-y stuff within the network, and am not even a local administrator on my own machine. I'm just some guy, you know? But seriously, without having some kind of skeleton key to my company's (very strict) network, is there some method I can use to seamlessly deploy easily-upgradeable macros to multiple people, or am I pretty much boned?
Switch: SW-7690-2320-9238Steam/PSN/Xbox: Drezdar
Drez on
0
Posts
What about setting up a share on your workstation that you can "publish" to, which is what everyone else works off? Then you don't need to interrupt them just to make updates at least. Or are you locked out of sharing off your own computer too?
It's not the ideal place for a share, but it's better than everyone's local hard drive.
I CAN do that. I can put .bas files on a share. But, again, people don't know enough to know how to import them to Excel.
Access is easy. With Access I can build a front-end for multiple people to access simultaneously.
Excel is tricky because I don't want to use a form. I want to give everybody either a macro or a shiny button (tied to a macro) that they can run against a sheet they receive each morning.
In other words, the macro needs to exist independently of the source because it is a new data feed every day.
I wrote the macro. Now I just want to know how to deploy it to everyone without importing my macro and installing a fucking toolbar on each person's machine independently.
Just told my coworkers to open the file and leave it open while they were using their other sheets. Macros from one workbook will run in an unrelated one, so it was easy from there.
If you need to, set the sheet to protected, put a password or something on there if some non-geek thinks it's cool to hit the save button on it, but if they aren't complete fools it shouldn't be a problem.
Haven't done anything with Access or PowerPoint in a similar fashion, but looking at the macro options in them you should be able to do basically the same thing, just create a blank access and powerpoint file that has the macros saved within them.
Then you just update the file that has the macros, and boom, everyone has the new stuff the next day. (and if you need them to get the new stuff now, tell em to close and reopen it.)
Backlog Wars - Sonic Generations | Steam!
Viewing the forums through rose colored glasses... or Suriko's Ye Old Style and The PostCount/TimeStamp Restoral Device
This is a good idea, except half of these goobers don't even know what a macro is and I'm not about to embark on that kind of training.
So is there some way of installing, by proxy, a toolbar?
I guess I could have a macro actually create a toolbar when the workbook opens. Actually I hadn't thought of that. Thanks! You've helped!