How to open another workbook in same folder?

[tgregoire]

hi,
i am trying to open a file in the same folder. i have tried the below code and it is not working for me.
i get runtime error 1004
method 'open' of object 'workbook' failed

i have tried several other things and none seem to work. i can get it to open but that is only if i hardcode the file path. the issue with that is the user can move the workbook and file that needs opening around so it needs to be dynamic.

also could use some help closing it once i extract the data i need.



Workbooks.Open Filename:=ThisWorkbook.Path & "\openthis.xls"

i need to complete this project soon.
please help!
THANK YOU!!

 

[SQUIDD]

ok

so to rule out the file

create a couple of dummy files to test this code on your desktop.

if the code works, then you know its your file.

 

[tgregoire]

so it appears that after i export the file from our ERP system i have to export as an excel application file instead of as a document file and then manually saving it. kinda weird.


now i am having issues saving the macro enabled workbook using vba after importing the data from the other file. again i need to save it in the current directory.


Sub save_as()


Dim dt As String, wbname As String

wbname = " Statement of Income By Period (EPlant Different Fiscal Year) "
dt = Format(CStr(Now), "yyyy_mm_dd___hh:mm")
ActiveWorkbook.SaveAs Filename:=wbname & dt



End Sub

 

[tgregoire]

never mind. i just realized i used : in the time stamp and thats not allowed.

thank you for your help.

 

[SQUIDD]

Hey.

Ok great. Glad you got it all working?