I have an Excel 2003 workbook that contains a macro to copy certain of its sheets across to a new workbook, then save and close the new workbook. It does this several dozen times, with slightly different sheet selections each time. I would like to add an extra step to the macro to export the secondary workbooks' spreadsheets to PDF. T...
While opening any MS Access database, a security warning appears saying that the file can be harmful to the computer. However, is there a way to remove this message. Or should it remain a necessary evil ...
What is the best way to sync up two lists each of which may contain items not in the other? As shown the lists are not sorted - although if necessary sorting them first would not be an issue. List 1 = a,b,c,e List 2 = b,e,c,d Using the lists above, I'm looking for a solution that will write out to a spreadsheet in two columns: a b ...
I have a Excel Sheet(Say OG.xls) which has some data already in it with some 5000 rows with headings in the first row and Upto "AN" Columns. This No of rows(5000) doesn't change for a whole year. Now i have 5 XL files(Say A,B,C,D,E) and the data from these files has to be appended to this OG file just starting from 5001st row every time....
how to import the data/files in csv format to excel vba in a much faster way? so far,i could get the files n display in excel but it is one by one. this will take a lot of time. how do we make it in faster way? ...
Greetings, The VBA code below will create an Excel QueryTable object and display it starting on Range("D2"). The specific address of this target range is immaterial. My question is -- is it possible to manually feed in values to an in-memory Recordset, and then have the table read from it? In other words, I want to specify the table ...
I have some simple .doc files I made in Word 2007 where I changed the text color and used highlights to compare some similar texts. What I'd like to do is change any instances of green text or gray highlighting to different respective colors for each. I'm sure there is a simple way to do this with VBA but any other sort of answers are a...
I have a table, call it TBL. It has two columns,call them A and B. Now in the query I require one column as A and other column should be a comma seprated list of all B's which are against A in TBL. e.g. TBL is like this 1 Alpha 2 Beta 1 Gamma 1 Delta Result of query should be 1 Alpha,Gamma,Delta 2 Beta This type of ...
The print functionality of Excel (in VBA) is extremely slow, I hoping someone has a way of speeding the printing up (without using the Excel 4 Macro trick). Here's how I do it now: Application.ScreenUpdating = False With ActiveSheet.PageSetup -various setup statements which I've already minimized- End With ...
Need help to figure out how to overide the default CreateObject() function in VBScript with my own. Basically the same exact thing as this example in VB6: http://www.darinhiggins.com/2007/08/22/TheVB6CreateObjectFunction.aspx I just need to adapt this to work in VBScript. The only thing I cannot figure out is this line: VBA.CreateObj...
I had a VBA project in outlook with a few email macros - but after a PC crash they are all gone and all I see is a fresh 'Project1' when I hit Alt+F11 I'm not a VBA programmer, but had a collection of handy macros for email sorting etc. I would not like to have to code them again. Anyone know where the code files should be on the filesy...
I have trouble comparing 2 double in Excel VBA suppose that I have the following code Dim a as double Dim b as double a = 0.15 b = 0.01 After a few manipulations on b, b is now equal to 0.6 however the imprecision related to the double data type gives me headache because if a = b then //this will never trigger end if Do you know...
HI i have database with many tables. In the first table i have a field called status. table 1 idno name status 111 hjghf yes 225 hjgjj no 345 hgj yes other tables could have same idno with different fields. I want to check the status for each id no and if it is yes then for that id number in all ta...
Is there any coding standard published by microsoft for vba applications? ...
I'm trying to call a web service in an Excel Macro: Set objHTTP = New MSXML.XMLHTTPRequest objHTTP.Open "post", "https://www.server.com/EIDEServer/EIDEService.asmx" objHTTP.setRequestHeader "Content-Type", "text/xml" objHTTP.setRequestHeader "SOAPAction", "PutSchedule" objHTTP.send strXML And I get back the following response: <?xm...
How do I programmatically reset the Excel "Find and Replace" dialog box parameters to defaults ("Find what", "Replace with", "Within", "Search", "Look in", "Match case", "Match entire cell contents")? I am using "Application.FindFormat.Clear" and "Application.ReplaceFormat.Clear" to reset find and replace cell formats. Interestingly, a...
I have some legacy code that uses VBA to parse a word document and build some XML output; Needless to say it runs like a dog but I was interested in profiling it to see where it's breaking down and maybe if there are some options to make it faster. I don't want to try anything until I can start measuring my results so profiling is a m...
I have a protected Excel worksheet, without a password. What I'd like to do is trap the event that a user unprotects the worksheet, so that I can generate a message (and nag 'em!). I can setup event checking for the application, for when new workbooks are opened, etc., but not for Unprotect. Does anyone have an idea? ...
Does anybody know how to call the import data built-in dialog excel from a macro (vba). I've tried Application.Dialogs.Item(...).Show but I can´t find the right dialog. Thanks in advance. ...
I have a vba macro which runs a loop for about 200 iterations, using up the ram page file as it runs. I need some kind of quick fix to clear the page file after every iteration. I know the best fix would be to clean up the code, but time is a constraint here. ...