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 Westi 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
  • Order by date
  1. Argh2

    Upload a file to an intranet folder

    ettienne, fumei, hackoo, Thanks for your replies. Was trying to avoid ftp, but it seems unavoidable. Appreciate the help. -Argh2
  2. 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...
  3. 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...
  4. 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...
  5. Argh2

    Invoke VBScript from VBA

    PHV, BINGO! If I locate the .vbs script at D:\Temp it works fine, but my actual path is D:\Documents and Settings\..., so based on your last post, I've revised the code to: Sub test1() 'This line works fine Shell "C:\Windows\system32\Calc.exe", 1 'This line now works fine too...
  6. Argh2

    Invoke VBScript from VBA

    PH, Double-clicking the .vbs script works fine. The .vbs is just a test: Msgbox "This .vbs script is called from VBA" -Argh2
  7. Argh2

    Invoke VBScript from VBA

    Thanks, PH, CreateObject("WScript.Shell").Run "D:\Temp\TestScript1.vbs", 1 causes an Method 'Run' of object 'IWshShell3' failed error. -Argh2
  8. 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...
  9. Argh2

    Collapse/expand buttons in excel spreadsheet

    niamhc, In Excel, the functionality you're looking for is on the Main Menu Bar. Try Data / Group and Outline / Group. In Excel help, type 'group and outline'...look at 'about outlining a worksheet.' -Argh2.
  10. Argh2

    Apply FileSystemObject methods to url folders &amp; files

    Tried updated code from another computer, behind a personal firewall, with internet urls -- it works fine and responds immediately: FileExists equivalent: ?urlisvalid("http://www.tek-tips.com/images/logo.gif") True ?urlisvalid("http://www.tek-tips.com/images/logo.giffff") False FolderExists...
  11. Argh2

    Apply FileSystemObject methods to url folders &amp; files

    fumei & CautionMP: Thanks for your replies -- especially the code, which got me testing it right away! A little testing showed that the error trapping approach is overly accepting...as long as the servername (front of url) is ok, no error is raised, even if the folder and/or file names are...
  12. 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