I'm writing a macro that will copy & paste information from othe
workbooks into a master workbook. My company hosts all official file
via internet. I know my code works - I've tested it on my deskto
folders. But now that I have to transfer it to the internet using
livelink and data ids that apparently changes.

On my desktop my code looks like this:
Workbooks.Open Filename:= _
"C:\Documents and Settings\User\Desktop\filename.xls"

So, instead I want to turn it into
CurrWorkBook = filename.xls
Workbooks.Open Filename:= _
"http://company.com/livelink/livelink/" &* "/" & CurrWorkBook
"func=doc.Fetch&nodeid=" &*

I can't use * as a wildcard. Is there anyway that I can insert
wildcard? Or is this part of the limitations of Excel?

Thanks,
Ma

--
ma
-----------------------------------------------------------------------
mai's Profile: http://www.excelforum.com/member.php...fo&userid=1395
View this thread: http://www.excelforum.com/showthread.php?threadid=26615