First of all. Hi everyone
I'm fairly new to the world of excel and know little to nothing about using macro's. Now I have an idea which can save me a lot of work and I think this is possible by using a macro.
Let me explain... I took some picture screens to make it easier to understand what I want. The IMG tags doesn't seem to work on this forum so you'll have to click.
Here you see a standard file which I open from my desktop.
\1
In the next picture you see words/numbers in italic. I typ these over from papers which people fax to me. The shipment number which I marked in yellow is unique.
\1
Now what I want to achieve is the following. I want to have a shortcut key which saves the document in a map called Shipments as the unique shipment number used in the document. So the document name in this
case is 118526.xls .
It will look something like this.
\1
I already tried to fix a macro myself but it always comes up with the same doc name in the map Shipments. So it always saves as 118526.xls.
Here you can see the code
I think I need to adjust the numbers in bold to a certain cell in which the shipment number is present.
"C:\Documents and Settings\morgand\Desktop\Shipments\1128785.xls"
Extra:
I thought of an extra feature aswell. The reason I save these documents is because I need to adjust them later on the day. Now is it possible to have a macro search for a document number and then open it.
This is what I think it should look like.
\1
If anyone can help me with this it would be very appreciated. Keep in mind tho that my knowledge on visual basic isn't that great.
Thx in advance
Bookmarks