out of stack space??

Unfortutely Ross,
It didn't work. The strange thing is that this program worked fine 2 days ago. Is there a way to track stack? IF there is, i will go through each line to see what;s wrong.
THanks

Hello adds007,

If you are running out of stack space, I suspect this macro is being called from either a Worksheet_Change or Worksheet_SelectionChange event. The most common cause of stack space errors is due to cascade failure. This happens when an Sub or Function is called recursively and does not remove data from the previous call. You should post your workbook to get a quick an accurate answer.

I am not using any events, so that can;t be the problem. I went through line by line and didnt do anything recursive till the error line atleast. I attached a copy of it for your reference. FYI, it works fine on my co-workers computer. Attached is a copy of the workbook.

Sub tst()
With GetObject("E:\OF\0_rain4u table.doc") '<--out of stack space error here
.tables(1).Range.Copy
End With
Sheets(1).Paste
End Sub

Unfortunately snb, that didn't work either. Still shows the error for both GetObject and CreateObject.

I am pretty sure the stack got filled up with another program i am working on. That one is pretty big program and I might have missed something that;s filling up stack. So a way to know how memory gets filled would be nice to know, if you guys know.
Thanks

Hi,
Sorry for the delay, I can't access my computer on weekends.

THanks for the program you gave. It worked, but it's really really slow.
Most of the time the dialog box doesn't open.

I decided to try what snb told me, and got rid of userform.
IT WORKED PERFECT, like a charm. Thanks a lot for the advice, snb.
But sometimes i have to import a huge table and it takes a long time to import. Isnt there anyway to include the userform to show progress without slowing it down?

Regardless, I am glad i know what the problem is now.

Thanks snb and Leith Ross for all the feedback and support!

Snb,
I just realized about using your 4 lines of code instead of mine like 20 lines of code.
Yours is way more efficient and doesn't require a progress bar. However, the format after import is not the type i want, unlike the other long procedure I used. Is there a way to improve this program so that no merge cells appear and all cells are copied exacly into excel? In other words, I want your program to give same result as my program.
That would save a lot of time of having to unmerge and fix all cells manually.
Thanks

I got bad news. The ghost of the past is back to haunt me. "OUT OF STACK SPACE"
Unfortunately, the error appeared again (which didnt before) at GetObject when I run snb's program. I added the functionality of having the user to select the file.

Please Login or Register  to view this content.

please help!

I got that from excel help:

Your local variables require more local variable space than is available.
Try declaring some variables at the module level instead. You can also declare all variables in the procedure static by preceding the Property, Sub, or Function keyword with Static. Or you can use the Static statement to declare individual Static variables within procedures.

I will remove static, since you are right, its not helping me
But this procedure is called upon a form control button click on worksheet. It doesnt refer to any other procedures in the project, also.

I put the code in simplest form I could and still gives me that error!
Attached is a sample of what i have, which gives me an error

I am sorry, I must have typed it wrong, but that;s not where the error occurs
It's at GetObject function. is there any other way i can get handle on the word file and copy the table?

I placed below code just before using GetObject

Please Login or Register  to view this content.

And this is what it gave me in the immdiate window

Please Login or Register  to view this content.

Seems like i have a lot of space left

nope only one workbook is open

is there a way to check what's on stack right now? or how I can clear it?
Because, my code is like 10 lines long with abosolutely nothing else open, and gives me the friking error when i run it.
I mean how can i be out of stack space, when i am running nothing else?