Copying Data From Closed Workbook

Hi Guys,

Havinig a few niggling little troubles...

trying to run some code as a workbook is opened, basically, it opens a workbook, copies a number from it, pastes it into a cell in the original workbook, adds "1" to it, then calls another macro to export the new number to the cell in the workbook it was copied from...

heres what i have:

Please Login or Register  to view this content.

now i know this code works, because i copied and pasted it from another workbook that i created that does the same thing, and it works perfectly.

when i try to run it, it come up with the infamous "Run-timer error '13': Type Mismatch" error... anyone have any ideas as to why? its doing my head in

i dont know where the error is... its not highlighting anything. nothing at all. hence why im here, i can normally figure it out through a few trial and errors...

Please Login or Register  to view this content.

and yer the code for GetRange would help :\ my bad! i alays forget about that bit!

i dont know where the error is... its not highlighting anything. nothing at all. hence why im here, i can normally figure it out through a few trial and errors...

Please Login or Register  to view this content.

and yer the code for GetRange would help :\ my bad! i alays forget about that bit!

Right cell G6 is an empty cell... its for a sequential Purchase Order number, hence the adding "1" to the value.
thats what i keep getting the #Ref! after its thrown up the type mismatch error...

but like i said, it works in another workbook... EXACTLY the same code... same locations and everything! it really is a strange one.

is there anyway i can troubleshoot whats going on?

right it works!
all i did was change "\\mp-sbs-01\storage\Blank Forms\DataBases\" to "\\mp-sbs-01\storage\" and put a copy of Q_Numbers.xlsx there... very strange, maybe it just doesnt like long network paths??

no i dont like long paths... maybe ill just create another share? or maybe ill just leave it as is and working? haha!
no there was no changes in the network at all... my worrie now is, will other people get the same errors when using it on dfferent machines? everyone has access to the network share so it shouldnt be a problem?
yer i can manually open the file through the "run" command... i really dont understand it...

yer i do... when generating a new order, it gets the number from the Q_Numbers file, pastes it to G6 in the purchase order, adds 1, then pastes that number back to Q_Numbers, making the next purchase order thats created, the next number... if that makes sense?
why is there an easier way to do this? am i making it too complicated?

i figured it would be best, as about 3 different people will want to create them, therefore the number needs to be centralised... damn this programmings hard stuff hahaa!