Activeworkbook Vba

[Kahlil Algya]

SIZE="2"][center]Merge Or Convert Excel Trading Add-ins For Excel Convert Excel Into Web Pages Convert Databases Including Excel Business Spreadsheets Build Automatic Trading Models in Excel [/SIZE][/center]

I am tryin to use the code above to kill the active workbook after first saving it under a different name...all appears to work ...the workbook saves itself under the new name, the activeworkbook closes but then I get a popup that says Excel has encountered a problem and needs to close - sorry for any inconvenience....

What I am trying to do it have a routine that fires whenever the user attempts to save the file...this examines the contents and makes a descision to either allow the save or delete the active file after saving it under a new name....hope this makes sense

The code in your last post works fine until I put into this event...so, is there any way the I can stop the normal save process from happening and replace it with mine own little invention...I'd rather not disable the exisiting toolbars and replace them with new as this confuses my poor usergroup....any ideas ??

For example I just had a three year running shared workbook corrupt beyond repair. It had 8-10 inconsistent but daily users and about 150,000 formulas that had to run each time it opened. Needless to say I am moving them against their will a bit to an access application.

If you are executing a macro that is part of a workbook, what do you suppose

happens when you execute the Workbook.Close statement on that workbook? Do

you expect the macro to continue execution after the workbook closes?

Thank you , hhalle,your opinion helps a lot .

I have one more question , I need the workbook can be opened at the same time by 7 people. Of course , one people only operate one sheet in the book .

How can I do ? to set up the book?

Another thing to keep in mind is that the personal workbook if you have

saved any macros in it will also be counted as an open workbook, so the

count will never be zero, substarct this one from the count.

Van: ruijunfan via vb-vba-l [mailto:vb-v...@groups.ittoolbox.com]

Verzonden: maandag 8 maart 2010 19:08

Aan: hhalle

Onderwerp: [vb-vba-l] I use activeworkbook.close and application.quit ,

after this , the excel is dead,

I have a macro that I have coded to close the activeworkbook after running a series of formatting and saving it as a PDF. However, it opens a hidden version of the personal macro workbook immediately after and I'm not sure why or how to stop it from doing that.

I think you are using VBA to close the only open workbook outside of PERSONAL.xlsb. In which case, your hidden workbook isn't "opening" - it's already open in the background. You can actually duplicate this experience by hiding the only visible workbook as well.

I'm looking for a macro that will look at the first two digits of the activeworkbooks name, and then copy/paste the corresponding sheet from the closed VATControls workbook and add it to the active workbook.

I have tried a lot of things, and combined a few sample code snippets from various sources with various results. The code is a mess and needs to be cleaned up, as it is not consistent, but I'd like this part to work, and I'm afraid I am mixing up several methods to achieve one goal.

To clarify: I want to copy or add an entire sheet from a closed workbook, where the name of the sheet matches the value in cell b1, on a new sheet in the active workbook. The part of the code after Set sht = wb.wsGET was just to see if that part works.

3a8082e126