» Home » workbook » Page 1
Copy Excel worksheets, macros, and graphs from one workbook to another, moving links to the new workbook
Category : Programming Languages

I have an Excel workbook with a number of features:


One main user-facing sheet
One summary sheet based on the user-facing sheet's data
A number of graphs based on the user-facing sheet's data (as in, the type of graphs with a separate tab for them, rather than objects within a worksheet - I'm not sure if they have a special name or special properties)
A series of 'backgr

View Replies


How to copy and paste the data from one excel workbook to another existing workbook using .NET code
Category : Programming Languages

Please help, I am creating an appilication in .NEt where I have to copy one excelbook data to another existing excel book.


How to copy and paste the data from one excel workbook to another existing workbook using .NET code.


View Replies


How to append data to existing workbook's sheet and don't create a new workbook
Category : Programming Languages

I am trying to work out what I need to change in the following VBA code to append the data at the bottom of data that already exists in a workbook named "Main" and a worksheet named "summary":


Sub MergeAllWorkbooks()
Dim MyPath As String, FilesInPath As String
Dim MyFiles() As String
Dim SourceRcount As Long, FNum As Long
Dim mybook As Workbook, BaseWks As Wor

View Replies


Keeping the colored highlighted Formulas in all over WorkBook when copying Workbook
Category : Programming Languages

"I've tried to make the condition works but no results, there must be a way to paste cells as Formats whenever cell meet the condition(cell color is RGB(128, 128, 128)) else paste all with values, the below coding dosen't work,any i hope my question will be accepted this time and any help would be highly appreciated!
Kindly find my Excel Workbook attached in DropBox link >>>"
file

View Replies


Load and copy excel table on a workbook to another sheet on another workbook
Category : Programming Languages

I would like to create a button that runs a VB macro, the goal is to load a table that is allocated in a workbook and past it in my current workbook's sheet.


so i have two workbooks, I have to copy a table from destination to my current worbook's sheet.


thanks in advance.


'Set source workbook
Set wb = ActiveWorkbook
'Open the target workbook
View Replies


Assign current WorkBook to Workbook object in Excel
Category : Programming Languages

I've tried to assign the current workbook to a workbook object:


Dim wb As Workbook, ws As Worksheet, rng As Range
wb = ThisWorkbook

In this instance, the code is running in and is the currently active workbook. But I get the following error, where am I going wrong:


91 - Object variable or With block variable not set


View Replies


Excel VBA or Function to extract Workbook name and data from workbook
Category : Programming Languages

Is there any way to extract the workbook name, but then extract only a part of it.
Any version of excel would be fine preferably 2003.


For example


"Help_TicketID123456788.xls"
"Help_TicketID563565464.xls"

...


So then I'd like to extract the ID numbers and put them into a column on a master worksheet in anoth


View Replies


Excel VBA - Use Module in Workbook B to Update Data in Workbook A
Category : Programming Languages

I have 10 XLS's, each of which contain a a few hundred lines of VBA that do the same thing. I want to move this common code into an 11th XLS, and have the other 10 call the code in the 11th XLS. The common code must have access to all of the data and worksheets in the calling XLS. This last requirement does not seem to be addressed by other answers to this question on SO. Can I pass the calling


View Replies


Copying colour palette from an unopen workbook for every new workbook
Category : Programming Languages

I want to write a macro so that everytime a new workbook is opened, it automatically refers to another workbook and brings over that colour palette, the workbook may or may not be open at the time.


The workbook I want to use is on a large network drive, buried in a series of folder - which i cant seem to get the syntax right for either.


Ive seen lots of examples, but can


View Replies


Copying an entire excel workbook to another workbook using VBA
Category : Programming Languages

I have a workbook with 4 worksheets ("Initial Workbook").
I need to copy all four worksheets to a different workbook("New Workbook").


I have the below code which allows me to navigate to the Initial Workbook from the New Workbook and then copy a specific range on one worksheet. I would like to amend this to allow me to select and copy all four of the worksheets on the Original


View Replies


Next
2012 / 2017 Copyrights BigHow , All Rights Reserved .