RunTIme Error 4248

Hello everyone,

I have previously posted this in this forum. http://www.mrexcel.com/forum/excel-q...ml#post3516111
My bad for not following rules before posting. Thanks to someone for letting me read the rule but that has hit me that the pressure of my problem, I forgot for a while. I thought that my respect for others had been gone for a while.


Basically, I hope someone can help me figure out this problem I have in Excel.

I have this code that works fine to open ms word when I will paste data from excel. it also sets to the right position in word.

Please Login or Register  to view this content.

Then this code will do the copying from excel to word.

Please Login or Register  to view this content.

It works perfectly fine in my pc. up to now it's all ok. but when running from my colleagues pc, it seems to miss the active document. The open ms word is working in the other pc. but the pasting part which is the second code gives us the run time error 4248 as if there is no open document. but it has succesfully opened. not sure why my code is not detecting the open word doc. and why this happens only in the other pc.

thanks in advance for the help.

Jhun

Why 2 separate subs?

Please Login or Register  to view this content.

PS Can you please use code tags when posting code?

Jhun

I can't see why that would stop you combining the subs.

Just add code to either take user input for the no of rows to copy or to calculate the no of rows.

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Jhun

The forums aren't connected but both have a similar rule about cross-posting.

By the way, one reason not to cross post is because it confuses things for everybody, including yourself.

Anyway, back to the question.

It should be straightforward to add to the code to copy the correct range and run it from one button.

How is the no of rows/columns to copy determined?

I perfectly understand the upsetting part when cross posting.

Norie,
I have two tables.
one has the main item and I always include in copying. thats range F11:J13. F11 is header
then another table is at Attachment 249288

then another table at range F14:J18. F14 and f15 are both header too.

I put a formula in cell F20 to count the value in cell F16:F18.
If it's 0, then it will copy only the main table and leaving the second one.

if it's 1, then it copy main table down to the first row of the second table. so that's actually. F11:J16
if it's 2, then F11:J17
and 3, then F11:J18.

That is why i just assigned 4 buttons then i will click the one depending on number of rows to copy or 0 for the main table only.

I am glad if that can be merged into one macro only. but more than that. I am not clear why my macro is not working in other pc.

in my end, it opens the word then does the copying.
But in the other pc, it only opens the word doc but not the copying part. It gives the run time error 4248. as if the doc is not open...

by the way the error points to this part of code.

Please Login or Register  to view this content.

Thanks much sir...

There could be a number of reasons that the 2nd code isn't working.

I'd probably go for Word not actually being open when it runs.

As for deciding what to copy, that is straightforward if you have things set up as you describe.

Please Login or Register  to view this content.

Sorry I don't know what you mean.

For the second code you posted Word has to be open, otherrwise there's nothing for GetObject to get.

Jhun

No problem.

Try this.

Please Login or Register  to view this content.