I don't have a good experience in Excel program so I want to put a date like dd-mm-yyyy in a cell like
1-Jan-2005 and in other cell 5-jan-2008 then I need to subtract two from one to get res...
I have a pivot table that sums the number of envelopes sent and the number of envelopes late.
This data is grouped by year, month, center num and center name.
I would like to add a field to ...
In VBA, how can call a batch file or other executible that resides in the same directory as the current excel file?
I have a list of data in Excel in which I have successfully used the Sum(if(Frequency) formula when attempting to count unique values in one column. I now have a need to look at another colum...
Hi,
I am trying to programmatically create a pivot table to run from a macro button on a instruction page. I have attached my code. It is a recorded macro and it does not work. I recieve e...
SITUATION:
i use this set of macro to copy in clipboard many outlook links, or one only and i end up with the same problem as tlt28gvg121 (See code snipet, sry for the french comments)
i pas...
Team,
I have currently built a report for senior management by which information from Excels workbook is copied to MS Office using VBA. The whole report works except for this ridiculous mil...
I am using Excel 2007. And it seems that you can still open a DBF (dBase) file in Excel but you can't save it in DBF format. Is there any solution to this? I would like to make some changes in...
Is there a way to set a default button on a message box like you can on a form? As an example so that everytime a message box appears the default button is always No?
Hi
I have a sub in another workbook that has a string parsed into it.
Sub A (ByVal S as string)
......
End Sub
How do I run this procedure from another workbook
Application.Run(A("Te...
Hi - I'm creating a Excel pivot table from a Query in an Access database. I need it to count the number of products reviewed in a specific week, but the dataset has the review as the primary k...
I am using the End xldown command to activate a range. I first search for text in a cell, the header, and then offset down one row to get to the first cell in the range I want to activate. M...
I have a drop down list of sales teams within my company. I have two cells that I would like to auto-populate based on the team selected in the drop down list. Essentiallys if Team A is sele...
Hi
The user must select from a data vbalidation list in Cell F4.
What they choose then determines the next data validation list.
The IF statement I am using is:
=IF(F4="Uni Hospital ...
I've got several controls (buttons, checkbox, drop-down menus etc.) on a sheet which were all working well. At some point in development of the VBA, I started getting the following message and...
I'm comparing two strings to see if they refer to the same movie title. One string is the clean title and one is the title with lots of other info. For example when compared they should retu...
Hi All,
I have an Excel file and a script which takes input as Pipe seperated values, i.e. varable1 | variable2 etc etc.
Therefore I want to either
+ Export the data as Pipe seperated va...
Hi All,
I am writing a marco to convert an excel sheet to a pdf. I have looked at similar threads here and have nearly got it working however it is crashing on the last line with the error ...
When a user clicks the drop-down on a group of DataFields in a pivot table, the user can use checkboxes to show all or some of the existing fields. However, if a user unchecks a box for a fie...
I get the follwoing error when trying to open a .wk1 file in excel 2003 You are attempting to open a file type that is blocked by your registry policy settings.
We have wk1 files all over ...
Hi:
I need to use MS VB6 and OLE Automation to open an EXCEL worksheet and retrieve cell data.
Is there a clean way to iterate over the rows and columns in a worksheet through automation...
Hi all,
When I start Microsoft Excel XP i'm getting this error:
"Compilation error in hidden module: ThisWorkBook"
How can i fix it?
I have a user who has been working in an Excel 2007 file. It has data in it. Then one time when he trys op open the file it opens to a blank background screen, no cells and just the menu bar a...
I have recorded a macro that copies a range of data and then goes to another worksheet and moves to the end of the existing range of data and pastes the data. This will be repeated daily and ...
Hi,
I built a code that executes an SQL code over an ODCB connection. My problem is that this code is working well on my computer but isn't working on 6 others similar computer that I trie...
