plz

When I pressed new query, from file, from worksheet afterchoosing a file it says unable to connect plz help answer by tomorow

IE open in background in vba excel even i used objIE.visible = true. my code is : Private Sub CommandButton2_Click() mystart: Set objIE = CreateObject("InternetExplorer.Application") objIE.Top = 0 objIE.Left = 0 objIE.Width = 1024 objIE.Height = 768 objIE.Visible = True 'We can see IE 'On...

Hi Team, My if formula is not working plz suggest where its going wrong, and also, if any other solution then also i am ok. Thanks. Sub Test() Dim lr As Long Dim i As Integer Dim ws As Worksheet<strike></strike> Set ws = ThisWorkbook.Worksheets("sheet1") lr = ws.Range("A1000").End(xlUp).Row...

I have data values which has values for eg: 9883;3883;45;567 which i want to convert into rows with use of formula. Plz advise.

Hello. when i open a specific excel file it asks for password but after providing password no file opens... Plz help how to retrive my data... the file contains almost 20 sheets and sheets are interlinked.. when i click file to open i see FUNCREs.XLAM written in bottom ribbon.. plz help I...