sourcewb

Hello In UserForm I have a ListBox, I would like that ListBox’s data source were coming from separate spreadsheet called “test” Address to this spreadsheet would be kept in cell A2 of “data” spreadsheet where ListBox is created on. In addition I need user to be able to double click on UserForm...

HI, Not able to hide Worksheets (2nd Time) in following code. Although with first occurrence i.e. Sourcewb worksheets get hide. But with SourcewbA code all the worksheet remains unhide. I tried to even close first and then open second file. Dim Sourcewb As Worksheet Dim SourcewbA As Worksheet...

Hi all, I am using the below VBA to import another excel sheet and then delete the original from its location. I need to modify it to be a static name plus the date in the this format "22_03_2018" which will update everyday to current day. So what is in the below now called "Download.xls" will...

Hi I have been running a code which opens an excel file whose name changes each day. The naming convention of the file is essential "Input file-[date]-[time].xlsx". Given the time can vary, I have used the * character to specify the file name: filesource_path = "N:\Input files"...