473,325 Members | 2,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

How to state web-based location when using SaveAsWeb method

I'm using Access to call Visio and generate organization charts (using Visio's Org Chart Wizard) and then us the SaveAsWeb method to save the file as a set of web pages.

As long as my target is on a "normal" drive (i.e. "k:\mydrive\OrgChart.htm") things work fine. As soon as I change the target to one of the folders on our intranet, I get an error message that the path name is invalid.

I thought I'd be able to use:
/TARGET=//pashanet/hr/TotalRewards/Drawing5.htm

but it's not working. Any thoughts???

Expand|Select|Wrap|Line Numbers
  1. Sub Generate()
  2. Dim VisApp As Object
  3. Dim visDoc As Visio.Document
  4. Dim visExcelFile As String
  5. Dim objAddOn As Object
  6. Dim objAddOn2 As Object
  7. Dim orgWizArgs As String
  8.  
  9.  
  10. 'Export data file from access and save as Excel file
  11. DoCmd.OutputTo acOutputTable, "TblOrgChart", acFormatXLS, "K:\HR-Payroll\HR\HRIS\OrgChart.xls"
  12.  
  13. 'Assign file location of Excel file that feeds into Visio
  14. visExcelFile = "K:\HR-Payroll\HR\HRIS\OrgChart.xls"
  15.  
  16. 'START VISIO'S ORG CHART WIZARD
  17. Set VisApp = CreateObject("Visio.Application")
  18. Set objAddOn = VisApp.Addons.ItemU("OrgCWiz")
  19. objAddOn.Run ("/S-INIT")
  20.  
  21. 'Add org chart arguments
  22. orgWizArgs = " /FILENAME=" & visExcelFile & " /NAME-FIELD=NAME /MANAGER-FIELD=SupID /DISPLAY-FIELDS=Name, Title /CUSTOM-PROPERTY-FIELDS=Title,Location HIDDEN /SHOW-DIVIDER-LINE /SYNC-ACROSS-PAGES /HYPERLINK-ACROSS-PAGES" 'fill in args here
  23. objAddOn.Run ("/S-ARGSTR " + orgWizArgs)
  24.  
  25. 'Run the wizard
  26. objAddOn.Run ("/S-RUN")
  27.  
  28. 'Save the document as a web page
  29. Set objAddOn2 = VisApp.Addons.ItemU("SaveAsWeb")
  30.  
  31. 'Add the Web Page Arguments/Preferences
  32. objAddOn2.Run "/QUIET=True /NAVBAR=False /SEARCH=true /TARGET=//pashanet/hr/TotalRewards/Drawing5.htm"
  33.  
  34. 'Quit Visio and close everything out
  35. VisApp.Quit
  36. Set VisApp = Nothing
  37.  
  38. End Sub
Mar 27 '09 #1
3 2127
ADezii
8,834 Expert 8TB
Have you tried 'Mapping' the Drives?
Mar 27 '09 #2
Hi ADezii,

Thanks so much. This worked perfectly!
Mar 30 '09 #3
ADezii
8,834 Expert 8TB
@raddrummer
You are quite welcome.
Mar 30 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Brett | last post by:
Is there a relation between the web and a finite state machine (FSM)? My web application can do clever things to retain state such as storing session variables in server memory or giving it to the...
1
by: Glen | last post by:
I cannot find any documentation on this state server error. Any suggestions? ---------------------------------------- Event Type: Error Event Source: ASP.NET 1.1.4322.0 Event Category: None...
1
by: Tin Man | last post by:
I have read in asp.net books (1) that with asp.net, Session state will work with web farms and (2) that Session state will NOT work with web farms or gardens. Which is true? T
2
by: geodev | last post by:
Hello, I’m currently writing an asp.net application that will be running on a Windows XP Professional workstation utilising IIS and MSDE Database. At a later date this application will need to...
4
by: McGeeky | last post by:
I am implementing a series of sequential web pages, a wizard, whereby the user can step back to a previous page. I want to restore the state of those pages if the user navigates back to them. Only...
2
by: Andrew Polo | last post by:
I'm trying to establish connection between my web service and state server to save session state. But I've got exception saying that server is probably not running or ....(etc). Server is running,...
1
by: Tim | last post by:
Could anyone tell me what this means and how do I correct it. Any suggestions? Thanks! Tim Richardson IT Developer and Consultant www.paladin3d.com Unable to serialize the session state. In...
2
by: John A Grandy | last post by:
Enabling / disabling session state can be controlled at the web.config and the iis web site levels. If session state is disabled in web.config , is there any reason to also disable it at the iis...
3
by: Jeff User | last post by:
Hi Sorry if this post appears twice, but it is not appearing in my news reader. We have an application that uses sessionState set up in Web.config is setup as follows: <sessionState...
0
by: mwmorrison93 | last post by:
Hello, I'm at my wit's end regarding the "The state information is invalid for this page and might be corrupted" error and I'm hoping someone can provide some assistance. I working with C#/ASP.NET...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.