sdate

Hello, Im attempting to zip files based on a date range. I want a pop up to record the date range and zip accodingly. Here is the code i've written in vba for access. I would love your help. Thanks. Sub CreateZipFile(sPath As Variant, zipName As Variant) Dim ShellApp As Object Dim MyObj As...

I have and error when writing some VBA. I have had to use formatting to get code to work but get the error list seperator erorr. the code eroe ocus when I add the parameter fo the search range using a between dtaes for nmedd range on peadsheet, the code is SubMacro1() ' ' Macro1Macro '...

Hi Everyone, I want to create a macro that asks the peson to insert tow amounts into a messagebox or any kind of popup box then filters by this? I know how to use userforms so that would do me fine. I currently use this Sub Filterby1() Sheets("Master").Unprotect 'Password:="august"...

Good morning! I'm trying to create a loop that operates with a specified date range and interacts with host explorer. I need it to advance the start date by one until it goes past the end date and then stop. Here was my first go at it, but stepping through eventually led to a "Run-time error...

Trying to filter worksheet on date less than 6/5/2018 using the below code. Perplexed.... Thank you for any help. Sub DateLessThan()Dim Lastrow As Long, i As Long Dim ws As Worksheet Set ws = ActiveSheet Dim sdate As String sdate = 6 / 5 / 2018 Lastrow = Range("A" & Rows.Count).End(xlUp).Row...

I have a created a little calculator which calculates various sums and deductions for a given month which works well. My problem is we often work with periods of up to 15 months. I want to be able to load in two dates for e.g. 21/03/2017-20/06/2017 and then on each submit it loads the next set...

I get a compile error: Wrong number of arguments or invalid property assignment error when I try to convert todays date to a string using the following code. I'm probably overlooking something obvious but I cannot figure out what it might be. Public Sub LooperDrive() Dim sDate sDate =...