FYI the below link helped me how to assign a macro to text in word document.
http://word.tips.net/T001571_Assigning_a_Macro_to_a_Button_in_Your_Text.html
The above code worked....Thanks Colin.
Jason, Yes it can be added. But, as I mentioned in my previous post, my document has multiple sections and the excel has lot of content in it. I just wanted to give the user a feel that when he clicks on the link in a particular section, he gets only...
Sub recordreference()
' OpenExcel Macro
Shell ("C:Program FilesMicrosoft OfficeOffice12excel.exe ""DoctorReference List.xls""")
Worksheets("Patient").Select
ActiveSheet.Range("$A$2:$CZ$65535").AutoFilter Field:=65, Criteria1:="US"
End Sub
The above code gave a compile error message...
Hi,
I have a word document with multiple sections in it. The detailed specifications of each section is available in an excel sheet. As there are multiple sections, each section has different specifications. The excel has many columns, out of which one column indicates the section name. All...
I used the location but not the name of the PT.
=GETPIVOTDATA("ABC",'Sheet1'!$A$3,"product",'Report'!C5)
A macro creates 3 pivot tables in the worksheet by name "Sheet1"
The report is in worksheet "Report"
Before the 3 pivot tables are created, the macro deletes the content in entire...
Hi,
I used macros to create 3 different pivot tables in a one worksheet. I created a normal table which is a form of report whose calculations are based on the data from these 3 tables. Both these worksheets are in the same workbook.
I used GetPivotData to refer to these pivot tables in the...
Hi,
Requirements:
I have a workbook by name Source with a worksheet by name Data. It has columns from A to E, but I don't mind how many rows and columns it has.
I have a workbook by name DestBook with 3 worksheets - Dest1, Dest2, and Dest3
Purpose:
Delete the existing contents in the...
The source is an excel sheet which has exactly 5 columns as required for building the 2 pivot tables.
First row carries the header data, which is essential in building the pivot tables.
Some times the source Data ranges from A1:E3500. Sometimes the data extends beyond this range.
User...
For the Dynamic Table issue,
I need to copy paste the entire data from a database to the existing sheet "Input Data". Saying that, I need all the columns for a row, but not part of the row.
Considering this case, I "think" creating a dynamic table is not a feasible solution.
Please let me...
Thanks Jeff for sharing valuable insights. I made changes to the code. Shown below is that:
--------------------------------------------------------------------------------------
Sub MakePivotsAdvanced()
Dim DataRange As Range
Dim Destination As Range
On Error GoTo errhandler...
Thanks Jeff. I tried giving the exact range and also creating a table and giving that in the range. Still the same error.
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= "Table1", Version:=xlPivotTableVersion14).CreatePivotTable TableDestination :="Sheet1!R1C1"
The...
Hello,
---------------------------------------------------------------------------------------
Purpose: Using a macro, I would like to create a pivot table from input source; but in an existing sheet
---------------------------------------------------------------------------------------...
Hello,
I did a search for this concept before posting it here. I'm new to VB and don't know much about the programming concepts. However, by recording the macro, i'm able to modify a VB code for creating a pivot table in an excel 2003...