Search results

Hello Forum, I need to update 40 line charts every month. Each charts will have 3 lines (Actual, Budget & Forecast) plotted from Jan till Dec. Due to intercepting lines, Data Labels will overlap each other which will not be meaningful. Hence, I need to have Data Label for Start of the year...

Its amazing to see some great answers. I was also trying to find some solution. But I could only think of a simple solution as below. In Wingdings Font, letter "J" will give you this Smiley symbol. So, you can simply replace "Yes" with "J" and change the font from Calibri to Wingdings which...

Thanks for your kind words Gaurang. You are most welcome.

Hi Gaurang, Please find attached the file with 2 formulas like "Clean & Trim" if your issues are only with blank columns and more number of blank spaces. I have done based on the assumption that your client's file format will remain the same always. I have pasted the formula only for 250 rows...

Great. Thank you so much Somendra.

I have uploaded the file for more clarity.

I would like to know the Cell reference of the formula where the result is matching. For eg. if the Vlookup formula is matching the cell C58, I would like to know that cell reference instead of the value. Is there any way to find out the same? Please help. Regards, Ramnath

We are conducting monthly survey and based on whether customer has a complaint or Feedback or Appreciation, we need to send a customised response to each one of them. It would be easy, if there is a drop-down at the end of each rows where the response can be categorised. Once when all the...

Hi Vijay, Application & Database are already in shared drive. But I know the problem is in the Excel sheet where I populate the data from Access database. The screen is flickering continously and Processing 1% to 100% is happening even if I press Ctrl + Break. If I solve this issue...

Hi, I have a peculiar problem. I have created a userform and populating data in to it from Excel which is from a Access Database query. When I open the Excel file the form shows up and data is populating in a second. But if someone else is opening the same file, once when they click the "SHOW"...

Hi, I wish to know if there is a formula in excel to find out similar sounding words even if the spelling is wrong. We need to match 2 names in database where there are spelling mistakes. Nothing is working out to know whether its just a spelling mistake or altogether a different word. Any...

Hi Vijay, I donno how to upload attachments. Otherwise I should have sent it to you. I did exactly the same way like what you told, but in a different way by not using VBA but through Excel formula. I am storing the values retrieved from Access in a second sheet first row and have a formula in...

Dear all, I have a new challenge before me to track changes in the Access Table which is controlled by an Excel Form. I browsed the below code and works perfectly well if the form is in Access. But I have the form in Excel. Can anyone help me in modifying the code to track changes in Excel...

Hi Vijay, Thanks a lot for your kind reply. I got it right. Its only one record. Regards, Ramnath

Hi Hui & Friends, I want to identify an existing record in Access and update a range of Blank fields with some value in Excel. I tried for nearly 2 days but in vain. If anyone can help, it will be great help. To give you more information, This is like a stage by stage application flow. 1st...

Hi Vijay, I browsed a sample code from online and changed 2-3 lines to fit my requirement. This is working fine now. Hearty thanks for your kind help. I am posting this for others benefit. ------------------------------------------------- Sub commandbutton1_click() Dim fs As Object Dim...

Hi Vijay, Thanks a million for your immediate reply. I have to apologize that I have not mentioned that it is a PDF file. Brief process is as below: A Form with Upload button will be given to some 10 users who have to browse their scanned pdfs and the same should be saved in my default...

Hi, Can anyone help me with a simple vba code which i can use to browse a file and once when selected the file should be saved in a default folder. Regards, Ramnath

Hi Guys, I got the magic code which works now. rst.Open "Select * From Auto_Finance where [Auto_Finance].[APPL_ID] = '" & APPL_ID & "'", cnt '" & APPL_ID & "'" this made the difference. Thank you so much xld & Dan for your valuable time. Regards, Ramnath

Hi xld & Dan, Here is the code. Sub Import_Inputbox() Dim cnt As New ADODB.Connection Dim rst As New ADODB.Recordset Dim xlApp As Object Dim xlWb As Object Dim xlWs As Object Dim recArray As Variant Dim strDB As String Dim fldCount As Integer Dim recCount As Long Dim...

Hi xld, I tried it just now. But its not working. I am just getting the column headings and 0 record. Can you please help? Regards, Ramnath

Hi, I need to query access Table and retrieve matching records by matching a variable supplied by the user through input box. The problem I face now is after several days of attempt to frame a SQL query, I couldn't get the result. I have given the statement. If anyone can help it would be of...

Is there any way I can post the file? the file size is 4 MB.

Hui, Thanks a lot for your usual support. Just one quick question. Will this code dynamically adjust the form size according to screen resolution or it will provide a handler to drag as we like? Regards, Ramnath

Dear Hui, I have designed a small application using VB Form in Excel. I have protected all the Modules, Excel Structure & Excel Workbook to prevent the user to get in to my workings. I have got some 4 buttons in the front screen to do the job and I am getting the below error message just...