We have created an Excel Add-In that I would like to distribute to several users over a network. I would like it done in away so that the Add-In can be stored in a central location on our net...
Morning,
Simple question. I would like an excel statement that works this way. I enter a Job Number and it pulls details from SQL.
Where do i start?
I am developing an application using Access VBA and SQL server. I create an Excel file which I modify via the following sub
procedure which I want to happend without user intervention.
Wh...
I have added a calculated field to a pivottable and it is the only field.
'Deleting' it in the usual way using
.DataFields(1).Orientation = xlHidden
results in an error.
I have tr...
If I enter the data 80125E8 into a cell it is displayed as 8.01E+12. I would like the data to be displayed as text instead, in other words appear in the cell as 80125E8.
I know I could prec...
I need to test for multiple events in Worksheet_Change.
To illustrate my point, here is my logic (code is merely presented to let you know where I'm heading):
Private Sub Worksheet_Chang...
I am trying to save a Microsoft Excel Document that is pretty large. I'm trying to organize all the columns in a nice way so that I can see all the information. However, anytime I save the doc...
Hi, I'm getting an error when I try to export the data from an access database to an excel spreadsheet.
The Excel template "Test.xls does not have a named range "InsertPoint". Please define...
For 500pts, can you tell me what the best way to distribute macros to 20-30 networked workstations?
Criteria:
One person will be updating the macros.
The macro may not be stored in th...
Hi Experts
i need to modify the following sub which will allow the user to choose what ever available printer on the network
Private Sub Btn_Prn_Click()
Sheets(Array(1, 2)).Select
...
Hello,
I am implementing a command bar that allows users to select any worksheet from the dropdown menu in this bar, and also let user to go home, go to the next page, or previous page with a...
I have installed Office Pro MUI core + danish language pack.
But the Analysis Toolpak is not working in the danish version - it only works in the english core.
I tried running the setup ag...
Hello -
I am trying to define the last cell in the last row which has data. The worksheet may contain from 1 to 100 rows. This needs to an automated (i.e. VBA) procedure.
For the purposes o...
I have a .csv file which I am editing in Excel. I have a couple of date fields to which I am applying custom formatting (Format >>> Cells >>> Custom...). I also have another field to which I a...
Below is the exact formula I have right now and it works great.
For the next phase, I need to create my new folder not inside the current folder but rather inside a folder on another drive ...
Ok, you know how there's low, medium, high, very high security settings in an Excel macros right?
Currently using medium which prompts everytime when opening a file.
Is there a way to ma...
Hi
I've got a Userform with one button on it and I want that button to be the same colour as the Sheets Tab (in a new workbook right click on the "Sheet1" tab and then click Tab Color and t...
Hi Experts,
My worksheet ("RawData"), contains a link to a file, range A1:J25 is apparantly an array.
Using the worksheet_calculate sub, if anything within the Rawdata.A1:J25 changes i c...
Okay here is the scenario-
I have created a cool, but monstrious user interface for a large project I am creating in Excel. Upon opening the excel doc....the user interface (userform1).......
so i think you can't do a vlookup with concatenate... why is that?
what i want to do ....(notice the EXTRA ZERO in the shouldbe_field)
concatenate
field1 field2 shouldbe_field
...
Is it possible to list or extract the create and last modify dates for every worksheet in an excel workbook? If Yes how?
On the spreadsheet I am trying to create. I need to be able to have teachers input the letter grade A,B,C,D etc. These letter grades need to be converted to a number so I can use that data in ...
I am an Access (VBA) programmer and need to add controls to an Excel spreadsheet. I need several command buttons to fire macros and a combo box to do a lookup in one column and show a second...
I am trying to find a percentage in a number but am having difficulty when it comes to dividing by 0.00. What i am working on is sales numbers. for instance in Jan and customer bought 256000...
I had a disk crash and now have had to reload my system and applications. (Excel and Outlook Express) I have a spreadsheet that now gets an error on the new computer that has never run the pr...
