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 Gerry, Yes I am planning to do an copy and paste, unless there is a better alternative. Basically I have a template of a report that I have to send every month. I basically have some analysis done once a month whose output is dumped by Matlab into text files, then read (& nicely formatted)...

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...

Thanks Zygor. I had the same problem mentioned in the post. Need to put that """ (triple quotes). Regards.

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 Nikhil, I think the self join idea is not a speed efficient one, I was tring out with and without the self join on some very large queries. The "without the self join" idea of SQL Sister works anywhere from 8-20 times faster (depending on the size of the query) than the "with the self join"...

Hi Guys, Thanks for the very interesting post. (I am a new bee and) I have some problems that were very similar to above. I was wondering you guys can give some suggestion on this query, i.e. whether it can be optimized further similar to what has been suggested above (my importance is on the...

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...

thanks a lot. actually i was just about to write regarding the issue in your second post. just two more questions: (a) if there is already a file existing, then Excel ask &quot;A file name 'myfile.txt' already exists in this location. Do you want to replace it?'. How do i supress this pop-up...

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...

Thanks Smith. Your code works fine with copying one cell from word to excel. Can you please help me further? In my case, the bookmark is a table (say 2x2) in word and the range is also a table (same size, 2x2) in excel. When I use your code for copying a table from word to excel then the whole...

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...

Jon, Well, the above code worked well the first time. The second time onwards, it seems to get stuck in the Drafts folder. The Redemption website mentions a solution (under the FAQ section) to use Set Utils = CreateObject(&quot;Redemption.MAPIUtils&quot;) Utils.DeliverNow I tried that too...

Thank you so much. It really worked. Really don't know how to thank you. So many of my office automatic mailing applications had stopped working because of Outlook 2000. Here is the modified code that I used (keeping it here so that any other person who may read this page, can find it useful)...