Problems with opening a file from Excel VBA

**sbe70** · 08-14-2012, 03:49 AM

Hi,

I have a problem when I try to open a new Excel workbook with a VBA macro. I have the followin gcode

***********************************************

Please Login or Register  to view this content.

****************************************************

It opens the selected file but then it starts the sub routine all over again without moving the data.

Any ideas?

Best Regards
Stefan

**JosephP** · 08-14-2012, 03:57 AM

there's no code to move anything but I can't see a loop there other than with the filedialog. a lot of the code is fairly pointless though as you can just use

Please Login or Register  to view this content.

btw if you write

Please Login or Register  to view this content.

this_Workbook is actually declared as a variant not as a workbook

**sbe70** · 08-14-2012, 04:00 AM

Hi,
I have code to move the data but did not include it. When I use Debug mode and Step In the code stops after executing the Open file row and starts all over again. It is weird.

**arlu1201** · 08-14-2012, 04:21 AM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

**sbe70** · 08-14-2012, 04:43 AM

Okay.

I got it to work with Joseph's help. Thanks....

**arlu1201** · 08-14-2012, 04:46 AM

Ok, its great that your issue is solved.

Please mark your thread as solved - Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.