|
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.
|
|
Suppose a spreadsheet contains 600 rows of data.
I'd love to be split this into separate workbooks containing 100 rows
each.
- I'd like the name format to be gubbins1.xls, gubbins2.xls,
gubbins3.xls, gubbins4.xls, gubbins5.xls, gubbins6.xls
- I'd like...
Answer Snippets (Read the full thread at pcreview):
Hi John,
Sub Macro1()
Dim wks1 As Workbook, wks2 As Workbook
Dim x As Integer, i As Integer
Dim pth = True
End Sub
--
isabelle
Le 2012-01-25 11:50, John a écrit :
> Suppose a spreadsheet contains 600, gubbins4.xls, gubbins5.xls....
|
|
If i could crack this would save me HOURS! every week...and everyone in my office
I have a file located here C:\RATES\SDR_RATES.xlsx
It contains historic rates for a special type of currency conversion called SDR (Special Drawing Rights).
Column A contains...
Started by theta on
, 11 posts
by 3 people.
Answer Snippets (Read the full thread at vbaexpress):
Try this array formula
=INDEX('workbook_path[file_name]sheet_names'!$C$1:$C100,MATCH(1,('workbook_path[file_name]sheet_names'!$A$1:$A100="EUR")*('workbook_path[file_name]sheet_names'!$B$1:$B100=1210_from_a_closed_file/
I could use....
|
|
Hi guys/gals,
If anyone has time, I have a non-urgent question.
I created a workbook in Excel 2003 that depends on macros. We have since switched to Excel 2007.
A user used SaveAs to rename it and convert it to Excel 2007. They are not real savy and ignored...
Started by Reimer on
, 20 posts
by 3 people.
Answer Snippets (Read the full thread at eileenslounge):
Oh well) ;-) You could use the Workbook_BeforeSave....
Excel itself warns if you try to save a workbook that contains macros as .xlsx:
x958.png if there was a way, to pound home the fact that the workbook will not work if they continue.
|
