Search results for query: *

Hello all, Is it possible to get the criteria list for a particular autofilter to appear in a combo box? TIA! Marvin

Hi all, Is it possible to animate several picture/graphic frames in VBA? Just wondering. Thanks in advance.

Hello All, I've been tasked by my manager to create a macro that would copy a range of cells from MS Excel to MS Word. So basically when it gets transferred to Word, it becomes a table. Here's the code: Application.ScreenUpdating = False Dim appWD As Word.Application, docWD As...

Hello all! Before I go on, here's the code I'm working on: ActiveSheet.Unprotect "GT2" Dim BASE, RX, BUILDUP, PRES, QSUM, RIB, SQ, BASEDIR, RXDIR, _ BUILDUPDIR, PRESDIR, QSUMDIR, RIBDIR, SQDIR BASE = Range("b9") BASEDIR = Dir("x:\" & BASE) RX = Range("b12") RXDIR = Dir("x:\" & RX)...

Ok, here's the code I did last night: Private Sub Create_Copy_Click() Unload UserOptForm SrvArea = Range("d5") svname = SrvArea & " - BOBCopy.xls" Workbooks.Add.SaveAs FileName:=svname Windows("The 2004 Book of Business Report.xls").Activate...

.. doesnt fit the screen. I know you use the underscore symbol to do that, but how? TIA!

Ok, here's the code: Application.ScreenUpdating = False Columns(&quot;a:a&quot;).Select PurchID = &quot;221&quot; If TypeName(Cells.Find(PurchID)) <> &quot;Range&quot; Then MsgBox (&quot;Purchaser ID not found!&quot;) Range(&quot;a1&quot;).Select Else: Cells.Find(PurchID).Activate...

Hello, Is there a command in VBA that allows to delete pages in Word? The way I'm doing it right now is very clunky; I basically record a macro to position the cursor just right below the page break and do a shift+PageUp to cover the upper pages to delete it. Any help would be greatly...

Hello, I'm trying to copy data from Excel to Access using the Template Wizard. This process works although it involves using the template and saving it. What I would like to do is to transfer directly from one of the Excel tool spreadsheets we're using to Access without needing the template. Is...