Search results for query: *

When I run the code with the .visible property set to .T. and Word runs in the foreground everything works fine but with the .visible property set to .F. I get the following error when it gets to the last line of code shown below: "OLE IDispatch exception code 0 from Microsoft Word: The...

Hi, I am trying to use something along the lines of oWord.Selection.ParagraphFormat.TabStops.Add(0.75 * 72) oWord.Selection.ParagraphFormat.TabStops.Add.Alignment = 2 to create a tabstop in word and then change it to a Right Tab from the default tab alignment. I am not having any luck. I know...

Hello, I have found some great threads on here pointing to good links on Microsoft's website which gave me a lot of information on how to control Word from FoxPro but I am having one problem. I am trying to set the vertical alignment for text in a particular cell in a table to bottom from top...

I have a foxpro program which opens excel and creates a spreadsheet, populates it with data and then does some formatting. I am also trying to build some pulldown selection boxes (Data -> Validation to make it in Excel). Please see the snippet of FoxPro code we have written below. The .ADD line...

We have the two normal commands for making a sheet visible and hidden in VoxPro: XLApp.ActiveSheet.Visible = .F. <- Make it hidden XLApp.ActiveSheet.Visible = .T. <- Visible But there is also the Visual Basic command (coded in Excel) you can use of: Sheets(&quot;Sheet1&quot;).Visible =...

I have a word document with an excel worksheet embedded in it via the INSERT -> OBJECT -> EXCEL WORKSHEET commands. How do I select and write data to this excel object that is inside a word document? I have used XLApp.<blah> and WordApp.<blah> commands but how do I get at the Excel app inside a...

Is there a way to check whether someone has selected the &quot;Enable Macros&quot; option and make it so that your excel workbook won't open if macros have not been enabled? Thanks, Chad

Hey, Since you gave me tons of help before, I am afraid you are getting stuck with another Combobox question. I have a combobox called ExistIIP1 and when a user inputs their own custom ExistIIP1.Text value, I want the ExistIIP1.Value to equal some text I specify. In this example I am using the...

I have a two column combobox where you select an item from the first column and the value is selected from the second column. I want to also allow people to enter by hand an item into the combobox. So, I was trying something like what is shown in the subject of this message: ComboBox1.Value =...

I have a combo box on Sheet2 named nonSTIP1 which gets its pulldown choices from Sheet3 range D2:D10 When a combo box selection is made on Sheet1, I want to change the ListFillRange value for the combo box named nonSTIP1 on Sheet2 by pulling data from Sheet3. I have read posts on this board...

I am trying to read in the filenames of all the excel files in a particular directory and then place those names into a temporary cursor called cPreImport. The problem is that FoxPro puts the filenames from the DIR command into two columns and I can't get FoxPro to read the second column of file...