Search results for query: *

Hi, The Excel Record New Macro functionality seems to record only those activities that are done within MS Excel itself. Is it possible to extend the Excel Record New Macro functionality to include operations like opening of a word document, copying files from Excel to the word document and...

Hi, I need some help regarding copying from Excel to Word. Suppose I have a range $A$1:$E$40 in an excel document say "C:\MyExcel.xls" which has a sheet called "MySheet" and I have a corresponding Bookmark called "MyBookmark" in a word document called "C:\MyWord.doc". Can some one help me...

How can you run a .bat or .cmd file from VBA ? The Shell command can only .exe files and not .cmd or .bat files. Please help.

Hi, Suppose in VC++ code, I have two commands: ... ... runcommand1; runcommand2; ... ... now suppose each of the two above commands take a long time and their outputs are NOT dependent on each other. How can I run them parallelly ? p.s. both commands do some external file operations. thanks

Suppose I have a function/procedure where I need to select the Top n rows where the value of n is based by a variable, how I do it. For instance, the following is NOT working: Select Top @Num MyValue From MyTable Where <some condition> Any suggestions will be very helpful ... Thanks.

Hi, I am a relatively new bee in T-SQL. Suppose I want to write a function that usually takes 2 parameters where the user who uses it has the option of giving say 1 parameter. So I tried to give a default value as following: ------- Create Function dbo.MyFunction(@Var1 smalldatetime, @Var2...

Hi, I have a txt file with rows as follows: row 1-> &quot;Long-NSX,Short-ACC,0.40238&quot; row 2-> &quot;Long-NSX,Short-BHE,0.4096&quot; I want to read it in an excel workbook using the Text Import Wizard by using the Delimited Option, and using the Tab, Semicolon and the Other option with the...

This is probably a really dumb question. Suppose I have a worksheet with a sheet say &quot;Data&quot; and I want to save only this particular sheet as a textfile, say &quot;D:\Data.txt&quot; by running a macro, what would be the VBA code ...? Thanks in advance.

Hi, I want to overlay a scatter plot in Excel with a line chart. How do I go about it ? Any introductory code will be great help. Basically, I have to plot scatter points between two series say X and Y and then overlay it with a couple of linear lines that bound the scatter plot (like X=a+bY...

Hi, can some help me with a some basics of code to populate a table (that gets generated within a macro) from Excel VBA enviroment/macro to FoxPro. I not want a solution like &quot;put the table in a worksheet, and then use the database/exporting menus&quot;, but a solution which can directly be...

Hi, I am basically trying to send in an email Excel/Word documents as an attachment throught Outlook automicatically. For this, I need to keep the Outlook open for the email to go through, otherwise I am prompted for the login, password and domain. Is it possible to send the outlook email by...

Hi, I use the following code below to copy from a range in Excel to a bookmark in Word. Can someone help me to write the code for the reverse operation, copying from Word to Excel? -------------------------------------------- Public Sub CopyFromExcelToWord() Dim xl As Excel.Application Set xl...

Hi, I am basically trying to run this macro (below) in VBA. It used to work alright in Outlook 97, but in Outlook 2000 another pop-up opens up saying that &quot;A program is trying to automatically send e-mail on your behalf. Do you want to allow this?&quot; etc and this pop-up has three...