Office Developer Packaging Wizard

[ChrisTheAncient]

Not the most dynamic topic for the forum!

I'm in brain picking mode if anyone out there has ever used this facility.

I have Office XP Developer Pro and have virtually finished designing an Excel spreadsheet package that uses two distinctly different workbooks. But both are needed.

The 'main' workbook uses Excel VBA macros to do things to the 'supplementary' workbook. So of course, there are quite interesting path names in the 'main' workbook macros.

Needless to say, if I just moved the workbooks into some gash old folder, the macros would lose the path and things would go pear-shaped.

So, and now the $64,000 question to see if I'm going to do this right...

Does the Packaging Wizard work out and adjust these path names in the macros - or do I have to pre-define them and make sure that I set the destination path 110% correct?

Now there's a thought!

I shall check back this evening (UK time) when I get in from work.

TIA

Chris




*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[ChrisTheAncient]

Cracked it, folks.

I didn't realise (until now) about the Excel vba command of "This Workbook.Path".

Now I'm using that, I'm happy and my worries have disappeared.

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************