Workbook_Open Question

[Guest]

Where did you place the OpenRebates sub?
gm

gm

It worked without issue for me. I created this sub to open the workbook

Sub OpenRebates()

Workbooks.Open "C:\Dick\Ng\08Aug\Rebates.xls"

End Sub

Assigned that to a commandbar button and it all worked fine using XL2000 on
Win98SE (although I don't think the version matters in this case.)

The subs that you have in the ThisWorkbook module should be in standard
modules. Only use the ThisWorkbook module for event procedures (or other
class specific procedures). That's not the problem because it worked for me
as you sent it without modification, but you should move them anyway.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

Thanks, I will use the email link from your blog site.

 

[Dick Kusleika]

Where did you place the OpenRebates sub?
gm

In a standard module in Personal.xls.

 

[Eric Schneider]

Tried it, no change! Thanks anyway. Sooner or later some excel vba guru
will chime in with the explaination.
gm

Any more information on this problem? I'm running into a similar
situation with a painfully simple macro. It executes fine with a
shortcut (no SHIFT key in the shortcut so that's not the problem).

The Ctrl + E shortcut works great...but the sub called from
Workbook_Open executes and transposes both columns and rows I'm trying
to copy from one sheet to another.

Shortcut works great...Workbook_Open event does not.

???