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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. pradipto

    Using Excel Record Macro to Capture MS Word Operations

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

    Copying from Excel to Word Bookmarks

    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)...
  3. pradipto

    Copying from Excel to Word Bookmarks

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

    Running a .bat or .cmd file from VBA ?

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

    Running a .bat or .cmd file from VBA ?

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

    URGENT: Parallel running of commands in VC++

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

    "Select Top" not working with a variable

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

    T-SQL Concatenation Question...

    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"...
  9. pradipto

    T-SQL Concatenation Question...

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

    Optional Input Arguments for functions in T-SQL ?

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

    Reading Txt file from Excel

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

    How to &quot;Save As&quot; a worksheet as a text

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

    How to &quot;Save As&quot; a worksheet as a text

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

    Scatter Plots in Excel

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

    MS FoxPro via Excel VBA

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

    Can Outlook be opened with Password from Excel/Word environment

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

    Copying from Word to Excel

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

    Copying from Word to Excel

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

    Sending Email 2 - problem in Outlook 2000

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

    Sending Email 2 - problem in Outlook 2000

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

Part and Inventory Search

Back
Top