Recent content by vijehspaul

if I remove the Do while loop, then error comes at AppActive ie line. Tried even removing that line, but error comes at ie.quit line. Please also suggest if there is any easy method to import pdf to excel. (text only )

Hello, I am trying to import some PDF files to excel using IE (open it in IE and copy-paste to excel ). My code is working for some pdf files. but for some it returns following error : The remote server machine does not exist or is unavailable Searched many forums to resolve this, but all leads...

Hello Masters, In my excel workbook, I have defined many named ranges. Most of these named ranges are dynamic in nature based on user inputs. Is there any way to find and use 'usedrange' of a named range in a form? I will explain: range("A1:A10") named as say 'index' The range will get...

Wow.... This fulfills my quest. Thanks a lot Somendra.... :awesome::awesome::awesome: I knew, that me like people who have very less coding knowledge also can find solution here. Great going guys.... :awesome::awesome::awesome:

Thanks SN152. But, i was looking for something else. In my original sheet, I can get the address of the cell from which the data should be filled. Dim rCount As Long With Sheets(3).Range("a1:z1") Set r = .Find(combo_cat.Text, LookIn:=xlValues) temp = r.Address but I am not sure...

Hi, I am trying make a excel form with two drop down selections (category, sub category) to get some data from user. Drop down - sub category is based on category selection. I need user to enter some amount in the space provided. When 'OK' is clicked i want the sub category and rate to be...

Thanks a lot Hui and Luke.

Hi, I have created a sample excel sheet (and attached) to explain my criteria. In my case, there are test cases with some sub tests and test cases result will automatically populate based on the sub test result. I would like to add expand / collapse options for the test cases with + / - signs...

Thanks Hui. Wonderful.

Hui, In my code below (in sheet1), I am trying to call/run a macro based on a cell value change. The below code is working for me if the source cell (B7) and target cells/range in macro (reset and playback) are in same sheet. But my workbook is bit large and have several sheets. So i want to...

I need to do 'Text to column' to that particular column. Thanks Smallman.

Got a solution. I modified the code as Dim address as Range With Worksheets(1).Range("a1:aa1") Set c = .Find("text to find", lookin:=xlValues) If Not c Is Nothing Then address = c.Address c.EntireColumn.Select Else MsgBox "Nothing to find" End If End With Share if there is a better way.. Thanks

Thanks Debraj

Hi, Below is my situation: Want to look for a word (text) and once find, i need to select the column. When searched on net, i got find function help. Code is below: With Worksheets(1).Range("a1:aa1") Set c = .Find("text to find", lookin:=xlValues) If Not c Is Nothing Then address = c.Address...

Hi, I have a macro that search for a string and copy-paste the entire row to new place. Need help for a modifications. ?? Need to set the macro to start pasting the result from a particular cell instead of last row. Macro i want to modify: Private Sub Click() Dim strLastRow As String Dim...