Small Piece Of VBA

Please quote for the following small amendment to a file I have.

I have a customer quote system that generates product quotes anywhere from 1 to 5 pages. Please provide a quote to detect the last page with products on and then delete all subsequent pages.

If you look at the dummy file, only the first 2 pages have products on, so this would need pages 3, 4 & 5 deleted. The 'Live' File will have 10 pages on, so ideally the code will just delete all pages after the last one with products on.

I had originally tried to code it so that a new quote page was generated each time the previous one had filled, but for various reasons this didn't work out, so have thought of this as an alternative.

I would be happy for it to be a small piece of VBA which I can attach to an active X button on a seperate page.

Have had a look at your previous Tidy Tool and have run a live export through it and it is almost perfect. I will detail one or two small changes later on today to complete the job, but overall I am very impressed!!

Compétences : Visual Basic

en voir plus : vba work, vba with, delete quote, vba time, vba for, vba, need an alternative look, dummy code, vba small code, customer quotes, piece code, small vba, small basic vba, vba provide, vba visual basic, vba small, amendment, visual basic small, almost basic, run anywhere

Concernant l'employeur :
( 7 commentaires ) Edinburgh, United Kingdom

Nº du projet : #1617684