Error 91 - Object variable or with block variable not set

[jaiswati]

I have tried to execute Auto_Open to run the macro at Start of excel
This works fine when we just put code

Please Login or Register  to view this content.

But When I put our actual code to manipulate the data of excelsheet as follows

Please Login or Register  to view this content.

We get the following error
Error 91 - Object variable or with block variable not set

[colofnature]

I think - and if I'm wrong I'm sure someone will correct me - that when the Auto_Open code is called, the workbook hasn't yet been instansiated. That is: when your code is being run, the workbook exists, but it's properties have yet to be defined. It's like you've asked for an ice cream, but haven't said if you want a topping: You:"Double choc-chip!"; Ice-cream god:"OK", You:"Rapsberry" Ice-cream god:"Raspberry what?" See?

[colofnature]

Sorry, talk about mixing metafors! Even I couldn't take any meaning from that...

[jaiswati]

Hi,

That only i want to ask, Auto_open gets invoked when excel file is loaded.
Is there something like this sub_procedure which is invoked after loading any file
Or every time When I open the excel file , I want same formatting to be applied.So I have called the micro in auto_open
this micro actualy deals with Activesheet which doesnt present when file is loaded.
Please help me out .As its very urgent

[jaiswati]

Hi,
I want to remove the images in excel file, autofit the contents for that purpose i have written the code as follows .But this code should execute.
whenever i open the files .I tried calling this in Auto_Open.
But i got the error that Object varible.not set.Please help me out with this regards as its very urgent

Please Login or Register  to view this content.

[shg]

Please wrap your code with code tags. If you don't know how, consult the forum rules.

Thanks.

[Paul]

Jaiswati, I wrapped your code as required - future posts may be deleted. Please click the link in my signature to review the forum rules prior to posting.

(Of course, I just saw shg's response..oh well)

[jaiswati]

Hi,

I Have Added code in code tag.HereAfter i wil do the same

[Paul]

Instead of using Auto_Open, you can use the ThisWorkbook_Open event, in which you could activate a specific sheet and then use the ActiveSheet.xxxx format.

[shg]

I Have Added code in code tag.HereAfter i wil do the same

Thank you.

Your code doesn't compile, and has undefined variables like the I1 in

Please Login or Register  to view this content.

I'd start there.

I can't follow the intended logic of the DeleteColumn module.

[mudraker]

jaiswati

Please read the forum rules

When you signed up to this site you agreed not to post the same question to multiple forums

Your duplicate threads have been Closed.

A thread with the rules is available at the top of each forum


Thread http://www.excelforum.com/showthread.php?p=1860679 opened after receiving PM from jaiswati

[mudraker]

jaiswati

Please read the forum rules

When you signed up to this site you agreed not to post the same question to multiple forums

Your duplicate threads have been Closed.

A thread with the rules is available at the top of each forum

[mudraker]

Thread re-opened after receiving PM from jaiswati

[jaiswati]

I Changed the sub proc from Auto_open to ThisWorkbook_Open() , still i got the same error that object variable or block variable not set.
Please help me asap....Its very urgent

Please Login or Register  to view this content.

[jaiswati]

Please tell me to get out of this situation in exact way (with help of code and as in provided in this post).

Waiting for the reply.

Thanks and Regards
Swati

[mikerickson]

Thread Closed Again.
For the same reason.
Repeatedly posting the same question in different threads is an ineffective way to get an answer.
And against the rules

[mikerickson]

THREAD CLOSED.
This is the same question in yet another thread.

[shg]

Swati,

I have merged these three threads into one and reopened.

I urge you in the strongest way to not keep opening new threads with the same question. If your posting rights are revoked, you will lose access to a valuable asset. And if they aren't revoked, people will come to ignore your questions.

[jaiswati]

Hi shg,

Surely.I was in panic Now its ok. I wil take care from next time

Swati

[shg]

Thank you. Please become a poster boy for forum etiquette. I have people annoyed with me for reopening this thread; vindicate my decision.

[mendieto]

I think that perhaps this people dont know about vba because dont response your question, dont you think? they only care about the forum rules

[mendieto]

This forum its sucks!!