PDA

View Full Version : Help...Excel Macro...



Im4real
03-11-2011, 03:54 AM
Hello.
I'm a newbie at macros (started 3 days ago :eek:) and besides that my academic formation is nowhere near programming :(.
So, if someone can help me i would appreciate it.
The problem:
The program must allow the user to create / check the documents of each order number (Example: 4FF3010). For this, the user writes in the field order number and presses a button in front.
The program should then do:

Go to the directory where you save Excel files for each of the orders (File is named after the order) and checks the file of that order is created or not.
If the file exists, you should see a message that already exists and ask whether to open or not.
If the file does not exist should see a message asking whether to open the sheet template to fill the order details.Thanks for your help.
Best regards,
Bruno Borges

Im4real
03-11-2011, 04:50 AM
Problem Solved.

Thanks.

Aussiebear
03-11-2011, 02:55 PM
Hmmmm....... the solution must be somewhere between Post #1 and post #2......

Yet I can't see it on the forum.