Recent content by jaminewok

cLFlaVa, i am always opening the same file, but the program you wrote for that tries to open the already open workbook. also, the programs you wrote are functions, and i have no idea how to autorun a word function from excel. all i know is how to autorun macros...

Public Function getWorkbook("Book1.xls" As String, Optional "Y:\Book1.xls" As String) As Workbook how would i get that to work? because it says expected:identifier when i try it thanks

cLFlaVa, sorry for this base question, but where do i put the real file name/location? is it szFilename/szLocation? thanks.

this program SORT OF works, but i need to switch between already open instances of word and excel, not open new instances. Dim Wbk1 As Object, w Dim Doc1 As Object, q Set objWbk1 = Excel.Workbooks.Open("Y:\Book1.xls") Set objDoc1 = Word.Documents.Open objWbk1.worksheets("Sheet1").Shapes("Chart...

clflava, im getting an "Object Required" error. clflava and skip, this is a word macro. i used excel to automatically open word and run a word macro to paste a table copied from excel. I need to automate going back to excel to copy more tables/charts and paste in word again. skip, how would...

skip and clflava, heres my code again: Dim Wbk1 As Object, a Dim Doc1 As Object, b Set Wbk1 = Excel.Workbooks.Open("Y:\Book1.xls") Set Doc1 = Word.Documents.Open("Y:\investmentpolicysummary.doc") Wbk1.worksheets("Sheet1").Shapes("Chart 2").Copy Doc1.range.PasteAndFormat (wdChartPicture) End...

skip, here is a segment of my code Selection.PasteExcelTable False, False, False Dim wbk1 As Object, a Dim doc1 As Object, b Set wbk1 = Excel.Workbooks.Open(YBook1.xls) Set doc1 = Word.Documents.Open(Yinvestmentpolicysummary.doc) wbk1.worksheets(Sheet1).range(Chart 2).Copy...

sorry for the repeated posting, but my question is not being answered. i know how to open new and existing documents and workbooks from excel and word. what i need to know is how to switch between an already open workbook and an already open document to copy and paste things more than once. i...

Can someone please help me switch between an existing and open Excel worksheet and an exisiting and open Word document. I need to copy from excel, paste to word, then go back to excel to copy and paste some more. Thanks.

Can someone please help me switch between an existing and open Excel worksheet and an exisiting and open Word document. I need to copy from excel, paste to word, then go back to excel to copy and paste some more. Thanks in advance.

Does anyone know how to transfer only the most recently updated record from access to excel? i can only get the whole recordsheet to transfer over. --------------------------------------------------- Have you got something that identifies it as the most recent record (e.g. a date/time field)...

I do not have a primary key, but I can add one if necessary. I hope to transfer to a blank spreadsheet that already exists. "So, like when you'r user clicks on 'next' you want the entry he's just done to be thrown into excel yeah?" That is exactly what I want to do. Thanks

sorry for the lack of clarification. i have a justified form, and i need to transfer only the most recent entry in the form from access to the first line of an excel sheet.

Does anyone know how to transfer only the most recently updated record from access to excel? i can only get the whole recordsheet to transfer over.

i only know how to copy the whole recordsheet to excel