Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.
-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?
Thank you.
Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
If you have any tips or tutorials you would like to see on Excel,
please feel free to visit me at http://teachr.blogspot.com
If you have any tips or tutorials that you would like to see, or add to
my blog, please visit me at http://teachr.blogspot.com and let me know.
Hi,
I just wanted to create a Receipt voucher for some Documents. So that i wish to create a Userform. But I need to print those form in the same style. Could you anyone please help me to do this?
I'm currently working on a new Excel Tips and Tutorials Blog for
beginners, intermediate and advanced users alike. I need some ideas
for common problems or tips that people request on newsgroups and
searches on the internet etc.
If you could please suggest some ideas to me that I can write tutorials
for and therefore add content to my blog with I would be grateful.
Please email any ideas or previous problems you have had to
mattyboy150279@gmail.com and I will add them to my site with detailed
solutions.
My site is http://teachr.blogspot.com
Many thanks in advance.
Mat
Hi all -
I'm in my company's eMarketing group and spend a fair amount of time working with prospect and customer data. Most of this data resides in Oracle which I export into .csv files for analysis and sending out campaigns.
However, I keep running into problems with the 65,536 row limit in Excel. For example, we have one newsletter list that has over 130K members, but I've been unable to do any analysis on this file for some time because I'm not able to open the entire file.
Does anybody know of any plug-ins that will allow me to work with .csv files of this size? I'm not particularly skilled in Excel but am pretty good at following directions.
Thanks!
Cheryl
Hi,
More often than not the various solutions posted for manipulating charts in Excel 2007 with VBA are issue specific, which may be adapted by other users to suit their needs.
This is great, but often means trolling a large number of threads and posts before you find something you can use/adapt.
Given that chart methods are very difficult to track down and the VBA chart object model in XL07 isn't terribly helpful, and to possibly help users with basic manipulation I've started this thread in the hope that others will contribute snippets of code for making changes to charts in XL07 using VBA.
To start the code below can be used to make the chart border invisible for every chart in the active sheet.
Code:
Sub Remove_Chart_Border()
' Use this to make the border on each chart in the active sheet invisible
'
' Get the number of charts in the active sheet
NumberOfChartsInActiveSheet = ActiveSheet.ChartObjects.Count
'
'Create a For/Next loop to cycle through each chart in the active sheet
For ChartLoop = 1 To NumberOfChartsInActiveSheet
'
'activate the next chart in the loop
ActiveSheet.ChartObjects(ChartLoop).Activate
' Do something with the active chart
With ActiveChart
' In this case the "do something" is set the line of the border of the Chart Area to invisible (visible = false)
.ChartArea.Format.Line.Visible = msoFalse
End With
'
'move on to next chart in the loop
Next
'
'
End Sub
My knowledge of manipulating charts with VBA is very limited, so I'm hoping other (likely more experienced) forum members will see this as a good idea and tag on.
