I have a spreadsheet that prevents people from printing the workbook.
Private Sub Workbook_beforeprint(Cancel As Boolean)
Cancel = True
MsgBox "Sorry, For Security Purposes, You Cannot P...
The following macro result in a "The pivot Table field is not valid" error
I believe this stems from the "SourceData:= rawData!C1:C2" fact
The trouble is, I never know how much data their ...
If I open a .CSV file in MS Excel (Office 2000 with CSV Converter installed) using File/Open... it displays the entire file in cell A1. With Office 2003, it displays correctly in separate colu...
Hi Experts,
I have a database with over a million records I am working with in Excel 2007 from which I am trying to retrieve a subset of data where there are some records that appear with m...
I have a table with dates and numbers, how can I add the numbers that falll between 2 dates?
For example I want to add the numbers falling between and including 6/9/2007 and 6/15/2007.
Hi,
I need to copy multiple excel ranges as separate tables into one word document using excel vba. I am able to create one table but did not have success creating multiple tables. Followin...
Not sure if this should be asked here or under vb programming, but here it goes. What I want to do is print the active sheet of an excel spreadsheet to CutePDF writer using the excel filename ...
I'm trying to make hyperlinks in Excel to PDFs in a folder. These files will need to be burned to a CD and be able to be opened from that CD or wherever the user saves them. How do i use Rel...
I have a column containing 15,000 names of photo files. I need to add a prefix to ALL of them.
For example:
photo1.jpg
photo2.jpg
photo3.jpg
I need to add:
new_
to all of the...
Hello, I'm using an Excel spreadsheet on my Windows ME and I accidentally deleted one of the sheet tabs at the botton of the spreadsheet and saved it. Is it possible to get that sheet back? ...
I've been staring long and hard and cannot come up with the syntax to make what seems very simple, work.
I created two list boxes from the control tool box in microsoft excel 2003. I pop...
I have a sheet with acct# name amount comment (from an SQL query)
1234 Smith 36.14 Return
3546 Jones 45.56 ...
Hi All,
Mainly becaue I don't have the time to look things up myself, I was wondering if and how I can achieve the following.
In Cell A1 I have a Year value (4 digits).
Depending on t...
Guys
I've built a workbook template with indentical input sheets and I'm using hyperlinks to local range names for major sections (Revenue in A100, Capex in A364 and so on)
Capex ='Alt ...
I need to keep a running total of values in 3 columns based upon value typed in. For example I want to type in values in column c and column d (for rows 2 - 30). I want to keep a running cumul...
Hello-
The code below allows me to successfully launch a spreadsheet and run a macro called "AutoOptimize." This all works the way I want it to. However, I am trying to use Windows XP sch...
Hi All,
I have 12 numbers (1-12) and I want to print the combinations available from these numbers. I know I can find the number of Combinations or Permutations from Combin or Permut, but I...
Hello Experts,
I'm not sure Excel is the best tool for this job but I don't know what would be better.
I have a script that creates directories with names that are too long for Windows ...
Is there anyway to access a website through an excel macro? What im trying to do is access a site, look for a certain word on this site, and count how many times it is used on that page. I did...
Hi,
I have a .xls link in a web page, meaning that if I click on this link opens up a spreadsheet in Internet Explorer. The link is something like:
http://www.website.com/filename.xls ...
Can someone provide vba code to generate auto invoice numbers based on an invoice template // i.e. number incremenatation based on a new excel doc using the template each time?
Points awarded if someone knows about a way to fix this. Otherwise, I do not see this bug reported anywhere, so it might be an interesting conversation. I have a workaround - if any of the e...
Hello:
Re: http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_20941199.html?query=Invoice&searchType=topic
I am having a little problem with The Private Sub Workbook_BeforeCl...
???How can I flip (ex.):
Mary K Smith
to
Smith Mary K
for all first and last names in one field consistantly separated by a space and having an occasional middle in...
Hi Experts.
The path for the file is here:
C:\Documents and Settings\user\My Documents\System\010136282P.xls
I want to access its properties like Title Author and Comments without ope...
