run an exe file in excel using VB

Visual Basic for Applications (VBA)

Index ‹ Microsoft ISV

- Previous
  - 1
    - public variable between sheet code and userform Hey, I created a public variable in sheet code and assigned a value to it. Now I want to be able to call a userform from the sheet code and use the value I established in the Userform code. Is there a way to do this Tag: run an exe file in excel using VB
  - 2
    - Help Deploying VBA changes across hundreds of Word Temlates I have been asked to "clean up" existing Word templates that have VBA code in them. Basically what I need to do is to remove the old code that is currently in the ThisDocument class module of the template and replace it with the new code. I've exported the "good" code to a .bas file and I have worked out how to import it back into the Word Template but the only problem I have is that I am importing it as a new module and the original code for the template is stored in the ThisDocument module. I don't know how to either clear the ThisDocument module programmatically (using VBA) or how to replace the contents of it with the "good" code. There are hundreds and hundreds of these templates and I am looking for the quickest and easiest solution as I am only new to the whole VBA world. Any help greatly appreciated. Thanks in advance. SIobhan Tag: run an exe file in excel using VB
  - 3
    - A question from a beginner... Here is a another good starting point for your VBA journey. http://www.mvps.org/dmcritchie/excel/excel.htm#vbatutorials Tag: run an exe file in excel using VB
  - 4
    - About iexplorer 7 error. "The instruction at 0x66869bc7 referenced memory at 0x00000050 . The memory could not be read." I keep getting this message whenever I close the internet explorer 7. Can anyone help me out on this matter Tag: run an exe file in excel using VB
  - 5
    - Excel Pivot Table Hi, I am populating the Excel Pivot table from the sql OLAP cubes . I am having 2 items in the Data Field list and I dragged and droped those two in the pivot table and every thing is working fine .But the problem is when i am selecting two rows and asking to group by right clicking the Data field , It is grouping the rows but it is showing only one column insted of two and the 2nd column is disappering and it is also disappering from the Data Field List and coming back when i say unGroup. I could able to figure out if it is a front end (Excel ) issue or it is a backend (OLAP) issue. Can any one help me on this and also let me know if I am missing any thing in setting the properties. Tag: run an exe file in excel using VB
  - 6
    - VBA Word Can't find project or library Can you share the code you are currently using. Tag: run an exe file in excel using VB
  - 7
    - Excel: Public variable doesn't work I have a routine that needs to sometimes display a form to get user input, then hand the result back to the caller. I use a Global variable to do this but the value is not returned. When I use Option Explicit, I get a run-time error, "Variable Not Defined" in the form. The code is like this: In the calling module... Code Snippet Public PsResult as String private sub ModuleA() PsResult = "" formB.show msgbox PsResult end sub Then, in the form's code Code Snippet PsResult = "derived value" Note that the form doesn't specify "Public PsResult as String". It shouldn't need to as it should already exist. What is important to note is that my calling code is within ThisWorkbook (because it's replacing the standard Excel Workbook_BeforeSave function). If I copy a bit of it to a new Module then it works perfectly. So why can't my form see a Public variable defined in ThisWorkbook Jeff. Tag: run an exe file in excel using VB
  - 8
    - Inserting Comments in Excel...from a Beginner Having lifted the code straight from this thread and into a blank spreadsheet on my PC at home, it's working fine. The only time I can get it to generate an error is if I select a range of entirely blank cells, or if I were to click cancel to the input box. You would obviously write appropriate code to deal with these eventualities, but for the example I left it out. Did you copy the code directly from this thread If you typed it in, there could be a typo somewhere. I'd try copying it in directly from this thread and give it another go. Failing that, come back with more precise details of the particular situation you're using it. Tag: run an exe file in excel using VB
  - 9
    - Time Addition Hi all, I am facing such a horrible problem, i have tried everything and cannot find a way to solve it and it is now driving me insane. What i am trying to do is to calculate the amount of hours a member of staff has worked for the whole week, this is done through VBA on a userform and i just cannot do it. the main problem i am facing is how to add hour and minutes together to give me a value in format HH:MM see code below Code Snippet Dim BreakLength As Date Dim TotalHours As Date 'Dim for Sunday Dim TimeAstart As Date Dim TimeAend As Date Dim TimeAelapsed As Date Dim Day1 As Date 'Dim for Monday Dim TimeBstart As Date Dim TimeBend As Date Dim TimeBelapsed As Date Dim Day2 As Date 'Dim for Tuesday Dim TimeCstart As Date Dim TimeCend As Date Dim TimeCelapsed As Date Dim Day3 As Date 'Dim for Wednesday Dim TimeDstart As Date Dim TimeDend As Date Dim TimeDelapsed As Date Dim Day4 As Date 'Dim for Thursday Dim TimeEstart As Date Dim TimeEend As Date Dim TimeEelapsed As Date Dim Day5 As Date Dim TimeFstart As Date Dim TimeFend As Date Dim TimeFelapsed As Date Dim Day6 As Date 'Dim for Saturday Dim TimeGstart As Date Dim TimeGend As Date Dim TimeGelapsed As Date Dim Day7 As Date BreakLength = "00:30:00" '------------------------------------------------------ 'this section is repeated seven time all together 'once for each day of the week 'label8 for sunday, label9 for monday and so on 'TimeAxxxxx for sunday, TimeBxxxxx for monday and so on If Label8.Caption = "--:--" Or Label8.Caption = "" Or Label8.Caption = "00:00" Then Day1 = 0 Else TimeAstart = ComboBox1.Text TimeAend = ComboBox2.Text TimeAelapsed = TimeAend - TimeAstart + IIf(TimeAend > TimeAstart, 0, 10) If TimeAelapsed >= "07:00" Then Day1 = TimeAelapsed - BreakLength Else Day1 = TimeAelapsed End If End If '----------------------------------------------------- 'Here is where all the problems start, to TotalTime = Day1 + Day2 + Day3 + Day4 + Day5 + Day6 + Day7 Label15.Caption = Int(CDbl(TotalTime * 24)) & Format(TotalTime, ":nn") if my shift goes over midnight then the number of hours is in 3 digits e.g if my shift is 21:45 to 06:00 then label15 shows 223:45 instead of 7:45 (note that is should be 8:15 but the break time is deducted) but label8 will show me 7:45 So the main solution i am looking for is how to add time together. I am now desperate for a solution to this, so if anyone does have a solution please help me Thanks in advance Tag: run an exe file in excel using VB
  - 10
    - Excel/Word VBA IDE - Additional Controls Dialog Box refuses to display I have a problem trying to add additional controls to the Controls toolbox The two methods I've tried 1. Right click on the controls toolbox , click Additional controls 2. Menu, Tools, Additional controls Neither of the above produce a dialog box containing the list of additional controls to choose from. Things I have tried so far.... Office Update, Reinstalling Office 2000, uninstalling Office 2000 and installing Office XP (2002) Please help any ideas Tag: run an exe file in excel using VB
  - 11
    - Excel Time Help Further to my previous reply, If you happen to use this calculation do not use Cut and Paste when program is running. Use Copy and Paste only and then Delete any unwanted data. Tag: run an exe file in excel using VB
  - 12
    - Excel import Thank you Shasur. With as quick as that referesh is I think my solution will be to generate a csv file, then import the file using a QueryTable connection. Tag: run an exe file in excel using VB
  - 13
    - Use of InStr() function Hi, The Instr function is designed to find characters/text. So search for text that is not there will not work. Looping through the characters is the normal way of doing it. Another possible approach is to use Regular Expressions. I'm not really clued up on there use but a bit of googling should provide more help. Tag: run an exe file in excel using VB
  - 14
    - iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :( The same exact thing is happening every time I close IE7. The location number is different for me (0x7c812a5b). Immediately after clicking okay for that error window... I get another. It reads "Runtime error 217 at "039EFD29". Browsing around the site here... this seems to be some sort of conflict between IE7 and Norton 2007. I read in a thread for the runtime error to do the following: Control Panel > Internet Options > Advanced (tab) > RESET Tag: run an exe file in excel using VB
  - 15
    - Importing excel spreadsheets over time into Access using a module in Access Hi, I am trying to create an access database that will allow to import excel spreadsheets at the click of the button on a switchboard. I have been trying for hours to create a module in access that will import excel spreadsheets that contains a table with 12 columns and a different amount of rows for each spreadsheet. I was able to create an almost complete macro in excel that I copied over to an access module (i was unable to create a Do while that will format the excel file by cutting out the first 8 rows and take out all columns except for 6 of them that i need for importing. It should delete rows below once it finds a row with "Elimination Totals" (Column C) or delete rows belowonce it reaches a blank cell in Column A. The Functionality of Database that I am trying to create can be described as: Functionality: Import Spreadsheet (6 fields/columns) into Access Table with 8 fields(Year & Quarter fields will be entered in by user) Use macro or module to format the imported file a) auto expand all columns and rows b) Delete first 8 rows of spreadsheet c) (only import columns A, B, C, D, I, & L) delete all of the rest of the columns d) Read Column B data (truncate or delete the first character in the cell) ex 6050 should be 050; G123 should be 123: keep the remaining three characters in the table. e) Import the table until Column A reaches a blank value “” (maybe a do while function….not sure how these work ) or until Column C = “Elimination Totals” Everything on the Elimination Totals line and below should be deleted and not brought into the table in Access. f) Row 1 & 2 values should be combined to make one row. Example: Row 1 Column A = Cost; Row 2 Column A = Center; Combine the two and you get one Row = Cost Center. Delete the extra row The import should be initiated by clicking “Upload Spreadsheet” on the Switchboard (I believe I just need to refer to the function name of the import module to accomplish this) a) When the ‘Upload Spreadsheet’ button is clicked on the Switchboard, a query should be initiated that requires the user to input the Year value ex: “2007” and Quarter value ex: “1”. These fields as well as the imported fields should be linked to a table. The table should be pulled by a form preferably a Pivottable sorted by Fiscal Year and Quarter that allows user to change the Agreement Description field(Column C from above) and RA Number (Column L from spreadsheet before formatting) but the other 4 fields should show all and not be able to get modified at all. Data in the Pivottable will be the Agreement Amount value (Column D from above) b) Another Pivottable will be needed to be sorted by Component (Column I from spreadsheet before formatting). Only the Components should be accessible to change for sorting options here; the rest of the fields should display all and be locked from editing. Data in this Pivottable should also be from the Agreement Amount field/column(Column D from above). The macro that i used is as follows: Sub ProviderListMacro() ' ProviderListMacro Macro - Formatting Range("E9 20").Select Selection.EntireColumn.Delete Range("I8 42").Select Selection.EntireColumn.Delete ActiveWindow.SmallScroll Down:=21 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 ActiveWindow.SmallScroll Down:=-45 Rows("1:8").Select Selection.Delete Shift:=xlUp Range("A1").Select ActiveCell.FormulaR1C1 = "Cost Center" Range("B1").Select ActiveCell.FormulaR1C1 = "Agreement Number" Range("C1").Select ActiveCell.FormulaR1C1 = "Agreement Description" With ActiveCell.Characters(Start:=1, Length:=21).Font .Name = "Arial" .FontStyle = "Regular" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With Range("D1").Select ActiveCell.FormulaR1C1 = "Agreement Amount" Range("E1").Select ActiveCell.FormulaR1C1 = "Organization" Range("F6").Select Selection.EntireColumn.Delete Range("F5").Select Selection.EntireColumn.Delete Range("F1").Select ActiveCell.FormulaR1C1 = "RA Number" Rows("2:2").Select Selection.Delete Shift:=xlUp Cells.Select Cells.EntireColumn.AutoFit Cells.EntireRow.AutoFit Range("B10").Select ActiveWindow.SmallScroll Down:=-9 End Sub Can someone please assist me on successfully giving the user the ability to import an excel spreadsheet (has the same required information) by creating a module that will import the file and fix the formatting, then save the information to a table and display it on a Form The form should have two extra fields - Year(2007) and Quarter (ex: 1,2,3,4), which i can/will add to the table. Any input will be helpful thanks, ultsun1 Tag: run an exe file in excel using VB
  - 16
    - Dynamically add controls with events at runtime Does this help. http://j-walk.com/ss/excel/tips/tip76.htm Or you could use a class with the event code in. See Stephen Bullen's reply in this post. http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/93d77c52ee239ef9/a5831a94d1b49dcb lnk=st&q=&rnum=1&hl=en#a5831a94d1b49dcb Tag: run an exe file in excel using VB
- Next
  - 1
    - autofill vba code I need to copy a function down a column to length of the adjoining column to the left. I recorded a macro which did what I wanted. Unfortunately, the column changes sizes depending on my data. Unfortunately, every time I run the macro it uses the length that was recorded the first time. How can I set up a dim or something to have the autofill work with the variable length lists Thank you very much for any help nsheff1@hotmail.com Tag: run an exe file in excel using VB
  - 2
    - Need to link two word documents together. You can used Open method to open the document and do the necessary Code Snippet Sub Update_Documents() Dim ADoc As Word.Document Dim BDoc As Word.Document Set ADoc = Documents.Open("C:DocumentA.DOC") ' Update Your Stuff Set BDoc = Documents.Open("C:DocumentB.DOC") ADoc.Save ADoc.Close BDoc.Save BDoc.Close End Sub Cheers Shasur Tag: run an exe file in excel using VB
  - 3
    - VBA - Accessing files in a folder Hi Andy Thanks for your interest. I have now optimized the code and it is indeed very fast. Initially, i had directly used the FSO object, browsed to the specific directory, get all the files (2000+) and then loop through them to get the desired file names. Now i have used the Office.FileSearch method to select the list of files and once selected, i use the FSO.GetFile method to collect the file attributes. Cheers Raja Tag: run an exe file in excel using VB
  - 4
    - iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :( The same exact thing is happening every time I close IE7. The location number is different for me (0x7c812a5b). Immediately after clicking okay for that error window... I get another. It reads "Runtime error 217 at "039EFD29". Browsing around the site here... this seems to be some sort of conflict between IE7 and Norton 2007. I read in a thread for the runtime error to do the following: Control Panel > Internet Options > Advanced (tab) > RESET Tag: run an exe file in excel using VB
  - 5
    - Parse AIM Buddy List Export file and Import to LCS 2005 Client I'm working on a migration project from the wide use of AOL AIM to Office Communicator 2005 and Live Communication Server 2005. I can create a text file export like the following: Config { version 1 } User { screenName thereScreenName } Buddy { list { "GroupA" { "buddy1" "buddy2" } "GroupB" { "buddy3" "buddy4" } } } There could be any number of groups. I will provide variable inputs for the input file and output file locations. I need to be able to make a new file like: buddy1 sip:buddy1@aol.com buddy2 sip:buddy2@aol.com buddy3 sip:buddy3@aol.com buddy4 sip:buddy4@aol.com I am completely a newbie in C#, but I was requested to use it. Any assistance would be great. I will request that the resulting tool be open source and publicly available, so please keep that in mind. Tag: run an exe file in excel using VB
  - 6
    - VBA Powerpoint - identifying textboxes by type Thanks, that works great. Problem solved! Tag: run an exe file in excel using VB
  - 7
    - Issue with Selection.TypeText and Chinese Characters. Hello Everyone, I'm having trouble getting chinese characters to work with TypeText. When I use English, everything works great. For example, the following statement shows up as " " in my word document. exec sp_OAMethod @objword, 'Selection.TypeText("美國總統")' While I'm using T-SQL and not VBA, I figured that the people here would probably know the answer. I've been finding VBA documentation or recording word macros and translating it to work with T-SQL as there is hardly anything on intergrating Word and SQL Server. So, my appologies in advance if this is the wrong forum. If anyone knows the answer or could point me in the right direction, it'd be greatly appreciated. Thanks! Tag: run an exe file in excel using VB
  - 8
    - Automatically send attachment in email with a submit command button in word Hi Did you remeber to send the mail item in your code Tag: run an exe file in excel using VB
  - 9
    - Wording of Response web pages is different to specified text Hello, I'm working on a prototype application using Windows Error Reporting, and right now I'm trialling Responses. I'm trying to understand why the wording on the web page I see (after submitting an error report for an event that I've registered a Response for) is completely different from the wording I've specified on the Winqual website's Response Management page. Two examples: 1a) My registered response #948 for event #64109781 in Winqual's Response Management page: Product(s): WERDemo 1.0.0.0 URL to Solution/Info: http://www.qsrinternational.com Response Template: Working On A Fix Response Template Text: ##CompanyName## working on a fix Thank you for submitting an error report. Problem description The error was likely caused by: ##ProductName## More information ##ProductName## was created by ##CompanyName##. ##CompanyName## is aware of the problem and working on a fix. To learn more, see the ##CompanyName## website. ##ResponseURL## 1b) What I see on the Windows Error Reporting web page after submitting an error report for this event: http://wer.microsoft.com/responses/Response.aspx/7412/en-au/5.1.2600.2.00010100.2.0 SGD=e65d413f-fb6a-43c9-9310-018a1921e3ce Problem caused by WER Demo This problem was caused by WER Demo. WER Demo was created by QSR International. QSR International is aware of this problem and working as quickly as possible to make a solution available. Recommendation -------------------------------------------------------------------------------- To learn more about this problem, QSR International recommends that you go online to the following website. QSR International 2a) My registered response #997 for event #64109918 in Winqual's Response Management page: Product(s): WERDemo URL to Solution/Info: http://www.qsrinternational.com/products_nvivo_service-packs.aspx Response Template: Custom Template Additional Info: Thank you for reporting this error to QSR International. A fix for this error is available in WER Demo 1.0 Service Pack 1. To download this service pack, please follow the link above. 2b) What I see on the Windows Error Reporting web page after submitting an error report for this event: http://wer.microsoft.com/responses/Response.aspx/7813/en-au/5.1.2600.2.00010100.2.0 SGD=d12dd974-7324-4266-9560-863419e3743e Download updates for WER Demo This problem was caused by WER Demo. WER Demo was created by QSR International. Solution -------------------------------------------------------------------------------- A newer version of WER Demo is available for download that will address this problem. QSR International recommends updating to the latest version of WER Demo to take advantage of security and stability improvements. Go to the QSR International website and install the latest version of WER Demo: QSR International --- A related question: I see Winqual is attempting to localize the text displayed on these response web pages (e.g. replace the culture "en-au" with "de-de" in the URLs above, and the text is shown in German). How does this work, and what is supposed to be displayed on the response web page for different cultures if I've specified a Custom Template with custom text on the Response Management pages Is there any way to force the page to be displayed in English Regards, Marcus Ogden QSR International www.qsrinternational.com Tag: run an exe file in excel using VB
  - 10
    - Why is it so ? Thanks Dhon, I looked at your XML mapping file sent to wer@microsoft.com and compared the results to the data we have related to your company in Winqual based on the current mapping and I think I have found what you are referring to... Your mapping file has a module with a version of 7.0.2.0. For conversation sake, we will call this jason.dll version 7.0.2.0 . This file seems to have crash a process with a version of 7.20.0.0. We will call this Dhon.exe version 7.20.0.0. Because of this crash and the mapping of jason.dll version 7.0.2.0, you are able to see the process name of Dhon version 7.20.0.0 in the event list even though Dhon version 7.20.0.0 may have been explicitly mapped to another product in your rollup list. This is very much related to my post here . Kind regards, -Jason Tag: run an exe file in excel using VB
  - 11
    - Is Microsoft the company broken? I've been developing on Microsoft platforms for many many many years (early 80's). I've been forced to start developing on OSX and other flavors of *nix primarily due to: 1. Increasing demand by my clients to produce higher level service agreement 2. VS 2005 even with SP1 can't deliver the goods on large scale 24/7 mission critical apps 3. The need to still use Java in ASP.NET based web solutions 4. Microsoft's SP/Fixes take too long to (6-18 months is not acceptable) Unfortunately I find myself having to agree with my client's position and the many clients I've lost because of the platform (.NET) I use. But what it ultimately boils down to is this: 90% R&D and 10% coding I'm spending way too much time working around the problems associated with Microsoft development at all levels from OS to IIS to .NET. It's a platform of too many compromises, too many bugs, and is just not secure (at least in my Client's eyes which is all that matters). I have 5 new clients lined up and NONE of them are considering Vista at all and for my large corporate clients, Vista's hardware requirements have excluded it from being a viable large scale deployment. Why this post so late in the game Perhaps my last attempt to send the signal and hope someone at Microsoft isn't there just to collect a check, that someone at Microsoft does indeed see the problem, someone at Microsoft sits back and looks at the company as a whole and discovers the problem -- at the very least they should question why "Zune" even exists when there are serious issues/problems with their bread and butter (dev tools and OS and server tools). Rob. Tag: run an exe file in excel using VB
  - 12
    - Debugging I can watch the execution flow of code in VBA under MS Word 2002 using the F8 key. How do I take a step backwards I want to watch a small section of execution flow again without starting from the beginning. Tag: run an exe file in excel using VB
  - 13
    - Format text in MsgBox it would be so difficult if you're not adroit to use windows' api function & vba programming. i have a reference web page for your info. plz refer http://www.catch22.net/tuts/msgbox.asp best regards sjoo Tag: run an exe file in excel using VB
  - 14
    - Inconsistent results with c++ dll I have been given a C++.net dll that I must call from within excel vba. The call is made to a function of type integer (i.e., long in vba). VBA calls the function ~100 times every time the code is run. I start excel and run the code and the function returns the correct answer (I have a test data set that yields a known result). I can rerun the code as many times as I want in quick succession and the function still returns the correct answer. The problem occurs if I run the code, wait for several minutes, then rerun it. At that point, the function suddenly returns a different (and incorrect) result. Once the function returns the incorrect answer, it keeps returning the same incorrect answer every time the code is run regardless of the number of times run or the time between runs. Any ideas Because the function initially returns the correct results I suspect the problem lies in the dll. I'm a novice to c++ and the dll code is quite complex, but I've done my best to check for common memory leaks, etc. and haven't found anything. Any idea why the function returns the correct result unless I wait several minutes then rerun it - what is happening during that time to suddenly alters things Thanks in advance for any help you can give. Tag: run an exe file in excel using VB
  - 15
    - MS Office document and image writer print driver 1. Go to Control panel – Printer and fax 2. Add Printer – select local printer attached then manual 3. In the port option select Document image printer writer port 4. Install a generic text only printer. 5. Right-click on the generic text/only printer driver and select properties. 6. Click on ports and select "Microsoft office document imaging driver port" 7. Click on the advanced tab and change the driver to Microsoft office document image writer 8. Click on apply and OK Tag: run an exe file in excel using VB
  - 16
    - Application.File Search. Hi, If any one has a work around for Application.File Search in Excel 2007 please let me know. This is currently not working in Office 2007. Regards, Digambar. Tag: run an exe file in excel using VB