change source spreadsheet

[stibbetts]

does anyone know how to change which spreadsheet inventor is linking to?

 

[stibbetts]

let me re-phrase that, i know someone knows how to, could you please give me a push in the right direction?

 

[VBAjedi]

You're going to have to be more specific. What is "inventor" - a named range, a hyperlink, or? If you give us more details, we can give you a more intelligent answer.


VBAjedi

 

[stibbetts]

Autodesk Inventor, it's a 3-dimensional Modeling Program. mine happens to be a very old version, 5.3.

 

[VBAjedi]

Hmmm, I've personally never used that program, but I'm almost certain that if it interacts with a spreadsheet, changing the target spreadsheet will be something that's done from within Autodesk Inventor. I'd suggest that you check its help files, contact the company that made it, or find a forum that deals specifically with that software.

Of course, you may get lucky and discover that someone in this forum has used it and knows the answer!

Anyone?



VBAjedi

 

[stibbetts]

i know how to change the spreadsheet manually but i need it to happen in a program that i have written, this is almost the last step in a very tedious process that i have automated so far

 

[VBAjedi]

Unless you can automate AutoDesk with VBA, about the only thing I can think of that you could do is to manually point AutoDesk to a generic spreadsheet (i.e. "Source.xls") in some specific location. Then in your code you could copy the desired spreadsheet to that location and rename it "Source.xls".

VBAjedi

 

[stibbetts]

i can automate autodesk with vba, that is the program i have been writing, i have figured out the dilema now though thanks anyway