The code below keeps pasting the range cells on the next page, after the bookmark called input. Xlobj.Sheets("Input").Select Range("A11:B30").Select Selection.Copy wdObj.ActiveDocument.Bookmarks("inputs").Range.go to.Select wdObj.Selection.PasteSpecial Link:=False,...

I have an Excel Workbook that's located on our Sharepoint site. I'd like to create a linked table to that file but I can't seem to get it to work correctly. I was able to link to the Sharepoint List where the file is located but I don't know how to manipulate the worksheet: really what I want...

Hi, I am trying following code its working fine. Private Sub Command3_Click() 'Export function 'EXPORTS TABLE IN ACCESS DATABASE TO EXCEL 'REFERENCE TO DAO IS REQUIRED Dim strExcelFile As String Dim strWorksheet As String

I have a workbook containing 13 worksheets. Sheet 13 contains two list tables. I need to link sheets 1 through 12 to the list tables in sheet 13 so that only one set of lists has to be updated when changes occur. Please help me...

Hi there, I'm struggling to achieve my end goal in Excel; I have a list of dates (presently the list of dates is divided into individual worksheets with 20 rows and 5 columns of dates per worksheet. I have 30-40 worksheets). My objective is to obtain a list of the dates that match...