detect

Hi Everyone, Hope all is well. I require code to create folders in a specific drive. The code must do the following: Go into folder path \\Server\Main Folder\Data Loads\ - If today is the 1st March, I have to save 5 files in a folder "February 2015' in a subfolder "20150228". So always the day...

Hi. I have table with many rows of data, and I'd like to have certain cells copied in the same row when data is entered in a specific column in that row. This is what I have so far: Private Sub worksheet_change(ByVal target As Range) If target.Column = 29 Then Thisrow = target.Row If...

Hi all, i am trying to populate a listbox with all the opened workbooks. But i can't seem to be able to do that. These are my codes Sub test() Dim wb As Workbook Dim myArray() As Variant Dim counter As Variant Load frm_SelectPrompt For Each wb In Application.Workbooks...

Hi, My company has a web system giving links to all our forms. My form has some functions which seem to be happier if they are run in a "proper" Excel instance, not from the broswer. Is there a way for the worksheet iteself to detect the application it is running within, and warn the user if...

Preamble: As with one of my previous posts, this has turned from a question into a tip, as I think I just found the answer while posting! (I'm using Excel 2003 today at home; but have not yet tested it on 2002, which I have at work). Scenario: I have a Worksheet with Autofilter enabled. It...

Hi everybody, I need to check and tally 2 different list of products. Here is an example of it: <table dir="ltr" border="1" bordercolor="#05ad00" cellpadding="2" cellspacing="1" height="154" width="448"><tbody><tr><td align="center" height="4" width="14%">Fixed Database </td><td...

Hi All :confused: I have a workbook with numerouse MDX queries. To refresh everything I can just hit the refreshall button and wait ... to code this I can code the refreshall. What I want to do is automate this and then close the workbook. The problem is detecting when the sheet(s) have finished...