Search results for query: *

ok, thank you very much :)

run-time error '424': object required in: For Each sh In [SheetName]

sorry for how lame i am, but if you mean to check ActiveX Data Objects then i don't have it in tools>references and if i try to check "active directory types" for instance it gives me this error "Error in loading DLL" and it gives me this mistake if i try to check anything starting with "active...".

it gives me a mistake here Dim rst As ADODB.Recordset the mistake is "user-defined type is not defined

when i get to New Database Query it says "this future is not currently installed".

2003

it turned out that on the computer that it'll be used there is no MS Query installed and i'm supposed not to use it, so if you know another way i'll be very thankful, if not - i have no idea what i'm going to do...

OK i read it several times and i don't know how to combine Application.GetOpenFileName Method with it... i don't know how it should look like in VBA at all...

i'm sorry, i probably didn't understand it well (my english is not good), i'll go read it again :)

i thought that Bong's code was perfect, but then i noticed that it opens it as another document, but i need it to be in the current one starting in the selected cell and since i don't know how big will be desired document or if it'll have a table in it i can't use SkipVought's reply too...

Hi, i'm new to VBA and i really need some help with this. I have a User Form with a button which should open excel file(which the user must select via Application.FileDialog(msoFileDialogOpen) into excel) and i have absolutely no idea how to do that. I'll be very thankful for any help :)