Hi,
I've made an Introduction to SQL tutorial aimed at Excel users.
I would love to hear feedback on how to improve the tutorial, especially
if you are an Excel user without much existing SQL knowledge.
http://www.querycell.com/SQLIntro.html
Cheers
Sam H
I have a user who somehow managed to have excel display a box below the subject line labeled 'Introduction:'. This box is below subject and above the formula line. Does anyone know how to remove it? I am stumped
Hello Forum,
This is Krish, I am new to this forum.I am having some doubts in VBA. how to address those in this forum. can any one please help me ?
regards
Krish
Hi Everyone,
I am Kynthia Melissa, a very new member to this forum. I have a special interest in Computer software packages.My approach is to enable the visualisation of complex data in a simple way.I found this forum very informative and I am really very excited here to take part in discussions. Hope you will contribute your ideas and support me in my mission.
Thanks & Regards
Kynthia Melissa
Hi Everyone,
I am Kynthia Melissa, a very new member to this forum. I have a special interest in Computer software packages.My approach is to enable the visualisation of complex data in a simple way.I found this forum very informative and I am really very excited here to take part in discussions. Hope you will contribute your ideas and support me in my mission.
Thanks & Regards
Kynthia Melissa
Hello All!!!
You have put together a very nice forum here. Certainly the result of a good community.
So on behalf of all the wannabe VBA coders, THANKS!!!
I'm currently learning VBA. I'm good with basic code but now want to take it to the next level: Designing ROBUST (unbreakable) utilities for the engineers I work with.
So here I am!!!
Attached is the latest utility I created but it has a number of issues:
1) Placing "X" in plot row does not seem to be intuitive for most of the engineers, I'm planning on replacing it with check boxes or depress-able buttons.
2) To hold the plot format/layout; I have a white line so that when no data is plotted, the chart remains. Thus, starting the data at serriescollection(2). I would like to go to a cleaner solution where the macro generates the entire chart, on a new sheet (named according to chart title), with the format/layout as shown generated with code.
3) If you delete the chart key, it will crash the macro when run again...... should be solved with issue #2
4) I want to macro to consolidate key titles; if there are multiple insistence of the same legendentry() --> consolidate to one.
Any help or reference to examples would be greatly appreciated. I want to take on issue #2 first.
Feel free to clean up any sloppy or in-efficient code and post up your revision. Add lots of notes in the code for the beginners =-)
I hope to be a strong member of the forum and plan to contribute lots of examples code similar to this file ;-)
With the help of the experienced members on the forum, these can become very nice examples beginners can easily learn from.
Peace Out,
-Aaron
Searchability: plot data, color lines based on text color, plot data based on cell marker
Hi all. I have a sub which pastes an xl selection to word and then calls an email dialog with the word doc as attachment. This is fine but I would like to code into this an introduction tp the email. Any ideas?
This is my code:
Option Explicit
Sub PasteToWord()
Dim AppWord As Word.Application
Set AppWord = CreateObject("Word.Application")
AppWord.Visible = False
Application.ScreenUpdating = False
Sheets("GOQ-R").Range("A1:I275").Copy
AppWord.Documents.Add
AppWord.Selection.Paste
Application.CutCopyMode = False
AppWord.ActiveDocument.SendMail
AppWord.ActiveDocument.Close SaveChanges:=False
Application.ScreenUpdating = True
Exit Sub
Set AppWord = Nothing
End Sub
I have decided it is about time I learnt to use VBA properly. Can anyone point to a good introductory guide? Either online, or a book.
Thanks
Bert
I have a column (A) that contains a formula and displays the value
I would like to put in Column B a link to that formula, BUT there the formula should be displayed, and not the value.
Any ideas? Using "show formula" in Tools -> Options is not helpful, as I do not want to to display the formula in column A.
Thanks
I am an extern in a not-for-profit organization. I need help with formulas
and do not know how or what to do? Please help me.
How to enter a formula