|
I am writing a reporting tool to document Excel files for various "compliance criteria", including wkb.VBProject.Protection to report if the VBA is locked.
But how can I find if the workbook HAS any project ?
If I calculate
wkb.VBProject.VBComponents....
Started by Patrick Honorez on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
' On Error Resume Next Dim wWorkbook As Workbook Dim fTest4Code....
Function fTest4Code(wkb As Workbook) As Boolean 'returns true if wkb contains VBA code, false otherwise ' ' Checks if the workbook contains a VBProject.
|
|
What would be the best way to get read-only access to data stored in another excel workbook. There are two posibilities that I'm aware of, each with their pros and cons.
Option 1) Reference the data directly
Example: =[test1.xls]Sheet1!$A$1
pro: Data ...
Started by Ivo Bosticky on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
Be going on in a workbook (or take in user input) Pull in lots of data, or filter / sort the data your you're concerned about the reference being stale when the data in the other workbook changes, you can avoid the problem by using a named....
|
|
I have an Excel 2003 workbook that contains a macro to copy certain of its sheets across to a new workbook, then save and close the new workbook. It does this several dozen times, with slightly different sheet selections each time.
I would like to add...
Started by Margaret on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
PDFCreator....
I have found PDFCreator to be good, the VBA is included in sample files, and have heard that CutePDF is also good .
This may help: http://www.pdf995.com
One feature is "Three auto-name options to bypass Save As dialog"
Office 2007 allows for this .
|
Ask your Facebook Friends
|
I already have a macro that creates sheets and some other stuff. After a sheet has been created do I want to call another macro that copies data from a second excel (its open) to first and active excel file.
First I want to copy to headers, but I cant...
Started by Kim on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Also, given the fact that in your code you are trying to copy .
In Sheet1 of Book1 now contains "A".
|
|
Hi.
A client of mine has been complaining about a particular Excel workbook (Excel file) that is running very slowly.
Whenever they try to make changes to any of the cells, it takes about 10-20 seconds to make the change. Excel freezes up and becomes ...
Started by Saajid Ismail on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at superuser):
In a workbook with many thousands.
Check also that there is no conditional formatting applied to any of the cells - this is a killer in terms of performance .
And speed of the workbook will be impacted.
|
|
With Spreadsheet::WriteExcel , I can create a new workbook, but what if I want to open an existing book and modify certain columns? How would I accomplish that?
I could parse all of the data out of the sheet using Spreadsheet::ParseExcel then write it...
Answer Snippets (Read the full thread at stackoverflow):
It contains several workbook $book ....
An Excel file is a binary file within a binary file .
New(); # $workbook is a Spreadsheet::ParseExcel::Workbook object my $workbook = $parser->Parse and Rewriting Spreadsheets .
|
|
On Mon, 5 Jan 2009 09:01:01 -0800, Sue N. <SueN@discussions.microsoft.com
So I messed up and now I need help :)
I was trying to copy a tab from a workbook and forgot to check off 'copy'.
Later I realized what I had done, so I copied the tab from...
Started by Sue N. on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Search entire workbook, and look for
".xls"
--
Best Regards,
Luke M
*Remember to click "yes.
|
|
I am relatively new to vba. This is a test macro to open access and close a workbook.
I am using Excel 2007 on win 7 & win xp
VB: Sub copyCount() Dim wb As Workbook Dim fname As String Application.ScreenUpdating = False fname = ActiveSheet.Name Set wb...
Started by Deepak_99218 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at ozgrid):
Maybe this
VB: Option Explicit Sub copyCount() Dim wbOpen As Workbook Dim wbMaster As Workbook Dim.
|
|
In Excel are worksheets that make a workbook and by default each workbook contains three arrays or worksheets. Ask ChaCha etc
Started by Answered on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at chacha):
|
|
I have a workbook(a)that I want to copy some information and paste the information into another workbook(b). The problem is workbook(b) is write protected. I have the password but I want to know Is there a code that will open workbook(b) and enter the...
Started by Saa62 on
, 7 posts
by 4 people.
Answer Snippets (Read the full thread at mrexcel):
If this argumentTake a look at the VBA help entry for the Open method of a workbook- it includes a password is omitted and the workbook requires a....
A string that contains the password required to open a protected workbook.
|
