ans

Hello Sorry for the long code, I need some assistance. The mkdir function creates a folder based on "Fpath" which is constant and 'Fvariable" which changes basis user form entries if it does not exist. Basically, in the userform, the user enters a series of equipment numbers that define fpath...

Hi again, I'm a self teaching newbie and am having issues with the workbook I'm creating. I'm trying to set a pivot table date based on the answer given in an input box but I'm not having much luck. Below is what I have come up with, any help would be greatly appreciated. Sub...

In this following bit of code, when I run a powerpoint.quit and try to run a messagebox after, the powerpoint doesn't quit and stays on front with the messagebox and Excel behind? I'm assuming it doesn't actually quit until the sub ends, how can I resolve this so powerpoint fully quits and...

I have this bit of code for a sheet I'm having an issue with. The code is in a template and then the template is saved with a different name. The part of the code in italics ran fine by itself but then when I went to add code to exit the sub IF the workbook name is not equal to Billing...

Hello wonderful helpers, I have a VBA code I'm trying to write that will allow users to click a button and that will save and close the workbook every time but if it's the final save for the end of the day will look at cell M6 to see if it's empty or not. If it's empty I need the sub to exit...

Hi all, I'm updating a time in motion sheet at work. I have a worksheet full of command buttons which all input information into worksheets named "1st" through to "31st". These worksheets need to be password protected so that users can SEE the info contained within them, but not be able to EDIT...

Hi everybody! After a while I'm still not into VBA, please, I need to check some range, if it's sum is greater then zero then run code normal, if it's equal zero then skip bunch of code to Exit Sub. Sub Macro1_OCISTI_PODATKE_SA_IZVJESTAJA() ' ' Macro1_OCISTI_PODATKE_SA_IZVJESTAJA Macro ' ' Dim...

Hi! I was able to create an invoicing excel file because of the help of all you awesome people from this forum. But I would like some help again. Please don't hate me if I am confusing, since I am confusing my self too, with what I want to happen. So is it possible to like Source...