Showing related tags and posts accross the entire site.
-
Can somebody pls help me with this Excel 2003 VBA Macro I want to save work sheet as pdf file and send this pdf file with outlook The problem is that my file is not saved every time i start this macro. i cant find the error.... Sub VerstuurEmail() Dim objOl As Outlook.Application Dim objMail As Object...
-
Please help! I have spent way too much time trying to figure this out, so I'm really hoping someone can help. I have recorded vb that changes a page item in a pivot table when selecting from a combo box - similar to this video. http://www.datapigtechnologies.com/f...s/pivot10.html . The recorded...
-
Is there anyway I can automate my sheet so it will print in PDF format and either save to my Shareware site or print to a drive and email to my Shareware site? I have tried recording a macro to see if I could find some code but no luck and I cannot find anything in the literature I have.
-
I have a sheet in which I enter a date and on another sheet I have dates list in column A and corresponding date to that date in the other columns. I what my macro to find the date entered and go to that cell on the second sheet. HELP
-
Hi all, I have a POS data file that I need to work with that is generated by store but it is in a continuous loop. Below is what part of the file looks like. I need to determine the qty sold and $ of each SKU for each store #. Has anyone worked on a file like this? Does anyone have any ideas on how I...
-
Hi guys I have been excel user for quite some time, and I used to think i knew it pretty well. Then I became member of this forum, and now i have realized that i know nothing. For instance I dont know how to use VB for excel. I want to start with simple codes in VB for excel, can anyone please guide...
-
I have been trying to set a shaperange that I can select and then group the objects using VBA. Here is the original code that I have going which works: (NOTE: this was taken from another website and modified) Dim vntShapeName(1) Dim myDocument As Worksheet Dim myRange As ShapeRange Set myDocument = Worksheets...
-
I have a workbook that I create from Access using the .CopyFromRecordset command and then create subtotals using the selection.subtotal GroupBy etc. This all works fine. I would like to format just the subtotal rows' font color and size but can not find the right code to accomplish this. Any help...
-
I have a problem with controls on a userform. I have a UserForm1 with several controls inside Frame1. The controls are OptionBox1, OptionBox2 ... and TextBox1, TextBox2 ... The user can create more by clicking on the command button labled "ADD". What I am tring to do is allow the user to remove...