Ignoring 1 of two modules

Hi Pike,

Not really as it is needed for the original spreadsheet(purchase Order 26-01-10....).

What is happenin is as NewPrint macro is running it is opening the Purchase order 26-01-10 and then carrying on the macro from module 1 of that.

Does that make any sense?

Libby

Basically what I ultimately want to do is to do a purchase order, print it and the contiuation sheet if there is one, fill the sumary sheet and save a copy of actual purchase order. This all works.

From there I may need to access the save PO's to amend them hence why saved a copy. What I am looking to do is be able to amend this, print it with contiuation sheet if there is one and fill in the summary sheet on the original purchase order spreadsheet.

That is what I want to achieve.

There maybe a better way than what I have done.

libby

How does that work?

I am all very new to this Pike and only understand little bits. Probably why this is so hard for me.

When you say append how will that work? Th assigning of the macro is only in module 2 as this is to relate to the new workbooks formed each time only.

So the new workbook is formed, module 2 transferred and the macro within module 2 NewPrint assigned to the print button on sheet one, saved as whatever the user wishes and closed.

Then at a later date the user may go back into this spreadsheet to amend a cost they got wrong or something, then I want this to be saved separately but the details to go on to original sheet which will be saved on each users computer, unfortunately I will not know where.

Have I lost you? I'm a bit confused myself now.

Ok so is there a way I can do this?

Hi ya,

Sorry for delay. Busy busy at work.

I've attached the file as a zipped file.

All I need to do is :
the sheets which are copied (purchase Order and Continuation sheet to be opened at a later date amended and the same details filled into the summary sheet which is on the the original sheet.

This will be used by several users in several locations so the Purchase order file could be saved in several different pathways.

Thanks so much for your help.

Hi there again.

Slight change of plan.

The document will be saved in a specific location of:
G:\Eworking\Comms\TPW\Administration\Consultants PO's\Glasgow & Birmingham\Purchase order 26-01-10(version 1).xls

I'm hoping this makes a difference!

Thank you
Libby

Hi there,

This seems to work but for some reason it is still erroring at:

Please Login or Register  to view this content.

In the Transfer_Module(myfileName)

Please Login or Register  to view this content.

Is it something I've done?
Thanks you so much for all your help so far.

I just need module 2 to transfer to the copy and saved module and I'm there.

Thanks again
Libby

In a way yes. The way it works so far is you fill the details you need onto the purchae order sheet and if necessary the continuation sheet.
On clicking print it will print purchase order then ask re continuation sheet. If no continuation sheet it then transfers the data request to the summary shh
et. Once this is all doneit copies purchae order and cont sheet to a new workbook an asks what you want to save it as and the new book closes. Then the purchase order and cont sheet are cleared of certain contents to make it ready for a new one to be filled in.

What I need to do is to go into the created workbook and at anytime amend this and ensure the summary sheet on original sheet is filled in.

This all works but only if I manually add the module with code for newly created workbooks to those workbooks when I reopen them.

If the module transferred automatically it would work a treat.

Am only dong it in excel because my company will not give the department that wants this the access to Microsoft access ( where it would have been a lot simpler.

I hope this clarifies what I am trying to achieve. I am so close with all the help from you and a few others on here.

I'm hoping it is possible

thanks again for all your help so far.
Libby

Hi Pike,

You've been great. I did repeat the error post only to specify the error as I thought perhaps someone might have helped if you were offline.

I will delete the other post.

I think this works great however as I am currently try to run it on 2007 itis saying I cannot save to macro free workbooks. I've been to the trust centre and change the settings but still doesn't work.

I'm sure it will work fine in the office on the 2003 version though which is what it needs to work on so thank you very much.

I appreciate all your help on this.

Thanks again
Libby

Hi there,

All works fine at work on 2003 thank you.

It would be good to have the code so it can work on 2007 and 2003 as I may be able to use this again for something else.

Also, one last thing, is there any way we can get Command Button 1 to say Print and Command Button 2 to say Amend? Not a worry if we can't. the most important stuff is working.

Thank you agawin for all your help.

Libby

Thanks Thats great. I think it might be better if both buttons are visible all the time and labelled but I think I've worked that out.

Now I just need it to find the document path to open the purchase order sheet on amending but thats simply getting path right.

I'll let you know if there's any tweeking but otherwise you have been brilliant.

Thanks again.

Libby

All working fine however, when it prints it is showing the buttons on the print? Very strange. How can I get that not to do that?

This should be it then!

Thanks

Libby

Also for some reason the date from the purchase order sheet is being transferred to the summary and changing. Very strange. It says 01/02/2010 on purchase order but is moving to the summary as 02/01/2010. I thought it may have been in the american format but it isn't it is saying 2nd January.

Any clues?
Libby

Just using the offset.

Code is:

Please Login or Register  to view this content.

Where K1 is the date. K1 has the function TODAY() which says 01/02/2010. In theory this should just link it shouldn't it? It has always worked before until today.

Really strange.

Thank you. Seems strange that text worked before but as long as it is working.

Thank you.

I don't suppose you can tell me why command buttons would print?

fab thanks.

I knew it must be something simple but I am se new top this and learning as I go.

Thansks for your help with the copying of cells to a closed workbook too.

Fantastic. Thanks again.