Search results for query: *

Hi I'm trying to unzip files using VBA from within outlook, but can't get it to work. This is the code I'm trying Sub UnZipaFile() UnZipFile ZipedFileName:="c:\123r5w\work\accounts\qhop0903.zip", _ TargetDirectory:="c:\accounts\", _...

Thanks, I'll give it a go and get back to you on how I got on. Regards

Hi Can anybody help me Is it possible to programatically in Excel VBA to set up a reference to the "Windows Script Host Object Model". I could ask my users to do it manually, but it would all go horribly wrong. Your advice would be much appreciated Corbie

Forgot to say thanks, works fine Many Thanks Corbie

Hi Is it possible to zip an excel file straight from VBA? I want my application to zip up a file and e-mail it out automatically. Managed to sort the e-mail part but so far am stuck on the zipping!! Any help would be much appreciated Paul

Hi Just press alt f11 within outlook, this will bring the editor up. This just insert modules as normal Hope this helps

Thanks, I get the idea now. I was going round in circles for hours, should be ok now.

Could anyone please help me with this simple printing problem which is driving me crazy. I'm reporting on a number of cost centres with each cost centre having 4 columns. I want to print six costs centres side by side each page. Fine , loop through and at each 4x6=24 column print a page. The...

Hi I'm trying to add a menu item to the toolbars in MS Outlook with following Code: Sub testbar() Dim customBar As CommandBar Dim newButton As CommandBarPopup Set customBar = CommandBars.FindControl(ID:="Tools") *** Set newButton = customBar.Controls _ .Add(msoControlButton)...

My company has 200 retail outlets that each prepare their own management accounts, They each send a download to head office consisting of a column of 500 numbers which is then consolidated into huge spreadsheet and then 100 or so reports are generated from this. All this is done in 123 release...

Thanks guys. It would seem that access is the way to go. Could you point me in the way to some descent sites so that I could learn more, or would it be best to post the question in the access forum Thanks again Corbie

Hi need help on deciding best way to consolidate a large amount of data. My company has 200 retail outlets that each prepare their own management accounts, They each send a download to head office consisting of a column of 500 numbers which is then consolidated into huge spreadsheet and then...

Thanks, with a little modification to suit my situation it has worked perfectly and will save me hours and hours of boring manual saving. Thanx again

I need to automate saving outlook attachments to folders based on their subject. (thats only the attachments, I don't meen just moving the message to another outlook folder). (ie receiving accounts download information via e-mail and then consolidating them in excel -at the moment I save each...

Thanks, works fine

Can anybody help. I need to write a UDF that given a range (part of a row) sums every 4th number. Any Ideas Thanx

Thanks, sorted it now

When I add a menu item to the worksheet command bar it disappears when I go to a chart sheet ??? Any ideas Paul

Yes - Worked great - Thanks alot Corbie

Thanks guys - I'll try your suggestions out and get back to you