Search results for query: *

Hello, I have two objectives: 1/ I have an index on excel on sheet 1 in a daily file. When the user clicks on any field in the index for example AUDJPY rate they are taken to the sheet2 for example and the cell with that rate. 2/ My second object. I have a system which is downloaded onto...

Hi, The IF line was reading cell to see if there was a value and if clicking again takes value out I thougth but now I am confused. To be honest I am not quite sure am still trying to learn vba. rgds JL

Hello, I have some questions on intersect code. I am trying to make the following code put a matched in range s2:s500 when a user double clicks on the cell. I would also like this code to be in workbook so when a user open excel the code works. For intersect code is it possible to change the...

Hi, On the forum link you sent I found the following code for Lotus emailing. Using this code there is no excel link message when I open the attachment. On the original code I sent a blank workbook but still got the message so was not sure which part of the code was causing the file to be...

Hello, Thank you very much for your help I will check test the code at work tomorrow. re question 3. I have opened the file in its saved location ie outside the notes session and there is no link it seems something is happening when it is attached to the notes session causing the file to be...

Hello, to clarify question 1. I want the subject line in lotus notes to be the same as the file name. ie if my file is report_05OCT09 I want the subject line of the email to be the same but in the code example I have posted I am unable to tweak the code to be the same as the attachment...

Hello, I have the following code which attaches an file to an email and sends to a distribution list. The problem I have is that I want the email to pick up the same name as the file attachment. It can change the code to factor in a different attachment name due to date stamp. I wish to also...

The original thread was a result of the macro recorder but regardless its resolved.

Hello HarleyQuinn, The intended code is for a bigger macro which calls a file saved into a share drive. the vba code opens the file manipulates the data and saves to a new location. because the file changes daily i am using the condition in vba. if i used conditional formatting in the file it...

Hello, I am writing a code which will check if price in column L is lower than column Y or greater than column Z. The following is aimed to loop through the ranges and turn the interior of cells in L red if the condition is false. If I could have some tips on how to re write the code for the IF...

Hi HarleyQuinn, I now have the code working. this is what i am using For Each c In Sheets("FXT Deals").Range("H1:H" & LASTROW).Cells If c.Value = "JPYAUD" Then c.Offset(, 21).Value = "Market Convention is AUDJPY-within range" End If...

Hello HarleyQuinn Your suggestion is working the problem is that for the condition or Each c In Range("H1:H" & LASTROW) Select Case c.Value Case "JPYAUD" then in range("AC2:AC" & LASTROW) i would expect to see "Market Convention is AUDJPY-within range"...

Tnx HarleyQuinn, please excuse my ignorance ( i am still vba green) what wouldi need to dim c as? cell?

Thanks for the tip Combo. I tested the condition on one cell which worked fine i just need to work out now how to check and apply for the rest of the cells. thank you JL

Hello thanks for the tips I have amended the code to the following but a mismatch error on the case JPYAUD=empty the lastrow is = 12 in this example (ie it is selecting the whole range of data I want checked. Sub TEST() Dim LASTROW As Integer LASTROW = Range("A1").End(xlDown).Row...

Hello I am trying to select text in a range and if the case is met then have a statment placed in a second range. The problem is I can see the selection of range works but for the case nothing seems to fire. Could I have some pointers on my error please. Here is my code. Sub TEST() Dim LASTROW...

Thank you kindly for your help gents. The code has been tweaked a little to the below which is returning the correct file path: Dim FichierSch As Variant Dim hour_temp As Integer Dim min_temp As Integer Dim hour_last As Integer Dim min_last As Integer Dim x As Integer hour_last = 60 min_last...

Thank you for the great suggestions. I have input the code but get a runtime error on Workbooks.Open(Filename:=Filename). _ RunAutoMacros Which:=xlAutoOpen the error is showing that the path as filename="I:\Reports\FXreport2608_.xls but today the file has saved at 9:32am ie...

need to write a code that can open a file which is saved to a common drive a number of times per day using yesterday`s business date with a time stamp. The file format is saved as `FxData2608_09_26.xls`. (09 & 26 are hour and minutes respectively)The problem is that the file is never saved at...

Hello, Could someone help with code for DTPicker. I am trying to vba code a calendar using DTPicker. If there are any good references with examples someone could share that would be great.