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

The Workbooks.Open method will open one file at a time. No wildcards are
allowed.
I can't figure out why you would need wildcards.

Here's something to try:
Browse in Livelink for the document you're interested in, right-click the
link (not the dropdown arrow), copy shortcut.

Then in your original code, replace "C:\Documents and
Settings\User\Desktop\filename.xls" with the URL you've copied.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mai" wrote in message
...

I'm writing a macro that will copy & paste information from other
workbooks into a master workbook. My company hosts all official files
via internet. I know my code works - I've tested it on my desktop
folders. But now that I have to transfer it to the internet using a
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 a
wildcard? Or is this part of the limitations of Excel?

Thanks,
Mai


--
mai
------------------------------------------------------------------------
mai's Profile:
http://www.excelforum.com/member.php...o&userid=13950
View this thread: http://www.excelforum.com/showthread...hreadid=266159