• WSstephan

    WSstephan

    @wsstephan

    Viewing 15 replies - 31 through 45 (of 51 total)
    Author
    Replies
    • in reply to: Access a data base from the web site? #520800

      Chris,

      ADO by itself is not going to do it for you. You’re still going to have to learn ASP. Visual InterDev, which comes with the Visual Studio package (as Charlotte mentioned in her post), is simply a development tool for creating and deploying ASP. I, and not my former boss, was the one who made the decision to use it instead of competing technologies like Cold Fusion. And, like I said in my earlier post, coming from a VBA/VB background, I found Visual InterDev/ASP *really* easy to learn because the main server side language is VBScript. Now, as you get into web programming more, you’re also going to have to learn some JavaScript for client side stuff, and there’s no way around that. But the meat of the programming is server side.

      The way I taught myself Visual InterDev was with essential 2 books. I started out with the easiest book on the market, believe it or not, “Visual InterDev 6 For Dummies”, which I zipped through within a week. With that, I already had enough knowledge to develop basic database-driven web apps. Then, I immediately graduated to one of the hardest books on the market, “Visual InterDev6 Unleashed” from SAMS, from which I got more intricate knowledge.

      Anyway, with your experience in VBA/VB, I’m sure you too will pick up the web programming very fast.

      Stephan

    • in reply to: Access a data base from the web site? #520626

      The answer for you is Visual InterDev, ASP and ADO.

      Basically, I was in a similiar position about 2 years ago. I was strictly a VBA guy, but I needed to create database-driven web apps, which I had absolutely zero experience doing. I taught myself the basics of Visual InterDev and ASP within one week. (I already knew ADO.) Coming from VBA, this wasn’t too difficult because the main server side ASP language is VBScript, just another flavor of VB!

      Anyway, a better forum for this type of question may be the “HTML/JavaScript/VBScript/etc…”. Also, you might want to check out a Visual InterDev forum I also belong to: http://VI6Talk.listbot.com

    • in reply to: Form font funnies #520476

      No actually, what I meant was Tahoma 8 pts. would appear to be different sizes within the very same form.

      I’ve come to the conclusion that the problem is caused by the ridiculous Large Fonts option some of my users insist on using (rather than the resolution).

      I will simply take the advice of Kevin or Gary and hopefully, that’ll take care of the problem.

    • in reply to: VBA 4 PowerPoint #520344

      Here’s some code appropriated from QUE’s Special Edition Using VBA 5:

      Sub Fly_From_Left()
      ActiveWindow.Selection.SlideRange.Shapes(“Rectangle 5”).Select
      With ActiveWindow.Selection.ShapeRange.AnimationSettings
      .Animate = msoTrue
      .EntryEffect = ppEffectFlyFromLeft
      .TextLevelEffect = ppAnimateByAllLevels
      .AnimateBackground = msoTrue
      End With
      End Sub

    • in reply to: Can I search across several documents at one time? #519042

      Yes, in the File Open dialog box, click the Advanced button. Then in the ensuing dialog box, set as your criteria: Contents include words [name you’re trying to find]. Also, at the bottom of the dialog, pick the folder to search in.

    • in reply to: Finding Paragraph Marks Using Wildcards #519039

      You’re going to have to use a little trick here. Since you can’t find paragraph marks (^p) when using wildcards, you have to find something else that represents the paragraph marks.

      Step 1:
      With wildcards turned off, Find all ^p and replace with ~^p
      (Note: this example assumes that there were no occurences of ~ to begin with. If there are, you need to pick another character.)

      Step 2:
      Now, with wildcards turned on, to find the paragraph marks, enter ~? (i.e., ~ followed by any char.). This works because we know that the only character following ~’s are paragraph marks.

      Step 3:
      After everything is finished, clean up your document by replacing all the ~’s with nothing.

    • in reply to: Executing an Excel 97 Macro using task scheduler! #511736

      In other MS Office apps, you would put a command line switch to start the app and also run the macro, but I don’t think you can do that in Excel. I think your strategy would go something like this:

      (In this example, let’s assume you schedule the task to run in task scheduler at 8:00 AM.)

      1. Put the command line that starts Excel (“C:Program FilesMicrosoft OfficeOfficeExcel.exe”) in task scheduler.

      2. Put the file that contains the macro you want to run in your XLStart directory.

      3. Put the following code in the file’s Workbook_Open event procedure:

      Private Sub Workbook_Open()
      Application.OnTime EarliestTime:=TimeValue(“8:01 AM”), Procedure:=”YourMacroHere”
      End Sub

      Notice that the time I put in Excel’s OnTime method is 1 minute later than the time you schedule in task scheduler. The reason the OnTime method is necessary here is because otherwise your macro would run *every* time you launched Excel, which I’m sure you don’t want.

      Stephan Ip

    • in reply to: Disabling prompt to save attached template #511595

      Absolutely brilliant. Thank you.

      Stephan Ip

    • in reply to: Tabs and Paragraphs #510959

      Basically, what’s happening here is when you hit tab in an existing paragraph, Word auto-formats the paragraph with a first-line indent instead of putting in a tab mark.

      If you find this behavior annoying, you can turn it off by going to Tools | Options | Edit and unchecking the “Tabs and backspace set left indent” option.

      Stephan Ip

    • in reply to: More form field headaches #510625

      No, it isn’t protected. Originally, I thought I wanted the form fields to be protected, but later I realized I couldn’t do that, because the end-user has to be able to edit the document itself.

      Again, what I’m really trying to do here is have the contents of fields throughout a document (like a COMMENTS field containing an invoice number) change throughout a document when the user changes a form field entry (hence, using the form field’s ExitMacro).

      Stephan

    • in reply to: More form field headaches #510621

      Gary,

      Thanks for your reply. Actually, possibility #1 is what’s happening here. I did test this using just one line of code showing a MsgBox. The MsgBox never shows up using either the EntryMacro or ExitMacro *unless* the form fields are protected. Only problem is I don’t want the form fields protected.

      So, it looks like I am the victim of yet another Word/Word VBA bug — the FormField’s EntryMacro and ExitMacro won’t run unless the form fields are protected. Now, I am racking my brains out trying to get the original functionality I wanted some other way — updating the contents of fields throughout a document when the user edits one field.

      Any ideas on how to do this?

      (BTW, I almost forgot how much fun Word VBA is after having been away from it for a while.)

      Thanks.

      Stephan

    • in reply to: Word Tables #1775793

      Try this:

      Sub ReplaceEmptyCellsWithText()
      Dim aTable As Table
      Dim aCell As Cell

      For Each aTable In ActiveDocument.Tables
      For Each aCell In aTable.Range.Cells
      ‘Len of end-of-cell “character” is 2,
      ‘so if Len of cell is 2, it contains no text
      If Len(aCell.Range.Text) = 2 Then aCell.Range.Text = “New Text”
      Next aCell
      Next aTable
      End Sub

      Stephan

    • in reply to: How to test optional parameter ? #510270

      The way I’ve always tested for the existence of optional arguments (parameters) is to use the IsMissing function.

      If IsMissing(NameofArg) = True Then …

      The only drawback to using IsMissing is that you must make all the optional arguments Variants because it *only* works with the Variant data type.

      Stephan

    • in reply to: Hyperlinks in Word #1775652

      Thanks Gary for the tip.

      There’s nothing more frustrating in this programming business than when you know you have all the logic right and the results still come out wrong.

      Stephan

    • in reply to: Hyperlinks in Word #1775541

      You’re going to have to do this with code:

      Sub RemoveAllHyperlinks()

      Dim aHyperlink As Hyperlink
      For Each aHyperlink In ActiveDocument.Hyperlinks
      aHyperlink.Delete
      Next aHyperlink

      End Sub

      However, you might have to run this sub multiple times to do the trick. Due to yet another apparent Word VBA bug, this sub is only deleting half the hyperlinks each time around. Go figure.

    Viewing 15 replies - 31 through 45 (of 51 total)