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!

  • 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: jgillin
  • Content: Threads
  • Order by date
  1. jgillin

    sonicwall dropping IKE udp packes

    Hi, I'm having some trouble getting the sonicwall global vpn client working with the TZ 210. I did packet capture on the sonicwall, and it showed that it is received the request (phase 1 isakmp requests) on port 500, but it drops them (drop code is 36 which means its blocked because of a...
  2. jgillin

    Problem looping through PowerPoint Slides

    Hi, We have a Visual Basic application that uses OLE automation to control PowerPoint (loop through slides, extract information, etc). For some reason, the looping through the slides portion of the code is throwing an error (but only on my computer -- other peoples computers don't seem to be...
  3. jgillin

    Deploying ASP applications

    Hi, I was wondering if anyone knows of any products (or articles) that assist in deploying ASP applications? I've had very little luck finding anything like this. I'm looking for a tools that helps in creating a deployment package that will do things such as run SQL scripts to install a...
  4. jgillin

    VBA - PowerPoint - accessing Screen object

    When working in PowerPoint VBA, I don't seem to have access to the Screen object. I'm trying to get the TwipsPerPixelX value, but can't seem to figure out how to get this value. Does anyone know how this can be done when working in PowerPoint vba? Thanks for any suggestions.
  5. jgillin

    Adding Flash object programatically

    I'm adding a shockwave flash object programmatically using code "similar" to below: ActivePresentation.Slides(mySlide).Shapes.AddOLEObject 150, 150, 480, 320, "ShockwaveFlash.ShockwaveFlash.7", "", MsoTriState.msoFalse, "", 0, "", MsoTriState.msoFalse Dim obj As ShockwaveFlash Set obj =...
  6. jgillin

    MSI - Permissions

    Hi, I've been trying to figure out how to use Orca to change permissions on the install directory. I've read some stuff online, and tried but it doesn't seem to affect permissions. Here's what I've done so far: 1.) Created the MSI with Visual Studio Installer. 2.) opened the MSI in Orca 3.)...
  7. jgillin

    Embed Data within PPT

    Hi, I have a PowerPoint VBA application. Within this application, users store data related to games. Currently it writes out to an XML file on disk. I wanted to see if anyone knew of a way to embed this data within PowerPoint. It would be nice if they could use their PPT with this macro on any...
  8. jgillin

    Windows Installer question

    I have an MSI I created with the Visual Studio Installer. I've set it up to work "for all users" by adding "ALLUSERS=2" to the property table (using Microsoft's free Orca tool). The only issue I'm having is that I have a "data" subdirectory within the installation directory which I use to write...
  9. jgillin

    Query using a SQL Server linked server

    Hi, I've created on Linked Server using Enterprise Manager (via Remote Desktop) on my dedicated internet server. Now, I'm trying to use a query from ASP to get data from that server. BTW, the linked server works fine in EM. I can see all the tables, etc. In ASP, it's returning an "Invalid...
  10. jgillin

    Eval() / Execute() - not in VBA?

    Hi, From what I can tell VBA doesn't have the Eval() or Execute() functions that VBScript has. Does anyone know why? (security concerns?). Is there any way to do runtime evaluation with VBA. I've noticed that the WSH has Eval() and ExecuteStatement() functions. Can we count on the user having...
  11. jgillin

    passing parameters to OnAction Handler

    I'm trying to pass parameters to an OnAction event hanlder in PowerPoint (for a menu item command). I obtained a syntax for this that was supposed to work, but doesn't seem to be. The syntax is as follows: EditSubmenuItem.OnAction = "'EditSubmenuAction """ & strParameter & """'"...
  12. jgillin

    PresentationClose event

    Hi, I'm handling the PresentationClose event in PowerPoint to "disable" (enabled = false) some menu items. Since the PresentationClose event occurs BEFORE the Presentations.Count number is decremented, I check to see if the # of presentations open equal "1" before disabling. This all works...
  13. jgillin

    Adding submenu items

    Hi, I'm familiar with adding menu items to PowerPoint with VBA code, but can't seem to find any information on how to add submenu items to a menu item. For instance, I've added a Menu Item under "Edit" called "Edit Game File". I want "Edit Game File" to show up with an arrow next to it, and...
  14. jgillin

    Programmatically determine Macro Security Level

    Hi, I'm trying to determine what the user's Macro Security Level is (ie, at runtime). Note that I'm not trying to set it, and I know that can't be done through code. The code is for a PowerPoint project, and I've looked through the PowerPoint object model, but wasn't able to find any property...
  15. jgillin

    installation / scrrun.dll / XP sp2

    Hi, I have an issue related to installing a VB app (MSI installer). Recently, I upgraded to XP SP2. After upgrading, whenever I create an MSI and run that MSI on a machine that has XP SP1, there's a popup during installation that essentially reads "cannot overwrite scrrun.dll". I figure that...
  16. jgillin

    Transfer SSL Cert to another server

    Does anyone know if there are any issues with transferring an SSL certificate to another server? We used to have a domain on an internal server, then we switched it to a hosting company (and thus the IP address has changed, but the domain name is the same). Does anyone know if we can just copy...
  17. jgillin

    Help with determine JOIN type

    Hi, I have the following query which pulls information from 3 tables: SELECT b.*, p.amount_paid FROM tblBusinesses b tblPayments p WHERE p.business_id = b.business_id AND p.account_id = 1 The tblPayment table contains a combined primary key (business_id and account_id), and an amount_paid...
  18. jgillin

    SSI with a virtual directory

    Hi, Currently, I'm developing a site, and have it setup on an alternate port within my company's intranet (IIS 6). They want the customer to access it externally, but don't want to open any other firewall ports. We only have 1 IP address, so I can't set the site up on another IP (and don't...
  19. jgillin

    VBA addin versus true plugin

    Hi, My company has me working on some add-ins for MS Office. One thing I noticed the other day, is that when installing the Macromedia Breeze for PowerPoint, it adds functionality to PowerPoint, and creates a new menu/submenu, but doesn't show in the "addins" list. I'm assuming this is because...
  20. jgillin

    IIS / SSL / accessible by internal IP only

    Hi, I'm trying to setup SSL on IIS. I created a CSR using IIS on the default site, and sent it to Thawte. After receiving the certificate, I finished the certificate process. I can access the https site by internal IP address (eg, https://192.168.1.159), and of course, the popup comes up since...

Part and Inventory Search

Back
Top