Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Argh2
  • Content: Threads
  • Order by date
  1. Argh2

    Upload a file to an intranet folder

    How can I automate uploading a file, from my local drive to an intranet folder for which I have write access, using VBA? For example: - upload: C:/MyLocalFolder/MyWorkbook1.xls (could be .txt, .zip) - to: http://red.green.com/MyIntranetFolder/MyWorkbook2.xls CautionMP and fumei helpfully...
  2. Argh2

    Hyperlink from web page to an Excel range

    I'm trying to link from a web page to a range in an excel workbook. This works fine in XP home edition with excel 2002. No fuss, no muss: <html> <a href="test1.xls#Sheet1!B2">go</a> </html> When I try the same html file in XP professional, it opens the file but ignores the sheet & range...
  3. Argh2

    Link from web page to Excel range

    According to Microsoft KB article #197922, you can link from a web page to an Excel range with the following HTML syntax: <a href="http://sample.microsoft.com/test.xls#Sheet2!MyRange">Third link.</a> as long as the link is specified with http: and not file:. You can either use a named range or a...
  4. Argh2

    Invoke VBScript from VBA

    How do you call a vbscript (.vbs file) from VBA? I tried shell, but it causes an "Invalid procedure call or argument" error. Sub test1() 'This line works fine Shell "C:\Windows\system32\Calc.exe", 1 'This line causes an invalid procedure call or argument error Shell...
  5. Argh2

    Apply FileSystemObject methods to url folders &amp; files

    There are several threads about how to FileExists and FolderExists, etc. but they assume the filespec or folderspec argument is on your computer or on a mapped network drive (e.g., "M:\folder\file.xls"). I get inconsistent or unusable results when applying them to urls (e.g...

Part and Inventory Search

Back
Top