Tagged Questions
0
votes
0answers
22 views
Change text alignment of category axis data labels
Pulling my hair out a bit with this small problem I'm having. I'm trying to left align the Y-Axis data label text with a bit of VBA code. I've tried 2 approaches:
With ActiveChart
With ...
0
votes
0answers
40 views
Fill out a PDF Form with data from Excel 2003 using vba macros
Is it possible to use Excel 2003 macros to fill out a PDF form?
Basically I have a large pdf file with a few hundred rows of data. I also have an PDF file that is a form. I want each row to be a ...
1
vote
1answer
48 views
Maximum drop-down list/formula length in Excel
I have the following VBA code:
myList = "test"
Range("A1:Z1").Validation.Delete
Range("A1:Z1").Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Formula1:=myList
If my list ...
2
votes
1answer
38 views
Dynamically changing sheet titles for excel 2003 usign vba
I have a several xls files that have there sheet names the same as there filename. Since the sheet names are updated with each xls file, the code i currently have does not update dynamically.
Is ...
0
votes
0answers
38 views
Excel: Call userform function from classmodule
i have an excel userform with several buttons. And i generated their name something like "grid-x-y". While x and y are some int values. As i don't know the amount of buttons at the beginning i have ...
0
votes
1answer
43 views
Too many local, nonstatic variables error in VBA 2003?
Hi I'm getting compile error in VBA Excel 2003 for the insert query for MS access database.How to overcome this error?
Public Function InsertSheetCurrent()
Static intK As Integer
Call ...
1
vote
2answers
79 views
Add Workbook based on Template
I am writing a small VBA add-in for Excel 2003, the idea is that the add-in looks in a directory for any '.xlt' files and for each one it finds it adds a button to a 'Templates' menu which provides a ...
0
votes
1answer
431 views
Merge Multiple Workbooks From Different Folders Into One
I wonder whether someone may be able to help me please.
I'm using the code below to allow a user to merge multiple workbooks from different folders into one 'Summary' worksheet.
Sub Merge()
...
1
vote
1answer
104 views
Code Error in Excel 2003
I have a code that runs absolutely fine with excel 2007 but its not running with excel 2003. It gives "complie error" and this line turns red.
Selection.PasteSpecial Paste:=xlValues, ...
0
votes
0answers
242 views
Pivot Table - Select value with macro in excel 2007
I have a Pivot Table in which i set a Field with a macro:
ActiveSheet.PivotTables("Pivot").PivotFields("Kreditlimit").CurrentPage = _
kreditlimit ' kreditlimit = 70.000,00
...
2
votes
1answer
179 views
Excel 2003 import macro doesnt work in Excel 2010
I have a macro that I used for importing data from many excel workbooks in a directory. It worked just fine in Excel 2003 but since I've recently been upgraded to Excel 2010 the macro doesn't seem to ...
1
vote
1answer
61 views
Remove Cell Content & Shift Up Without Sort
I wonder whether someone may be able to help me please.
@Doug Clancy on this site offered some very much appreciated guidance and solution (shown below), which clears cell content and where necessary ...
0
votes
1answer
94 views
VBA Paste Range
I wonder whether someone may be able to help me please:
I'm using the code below (which I've had some help with) to copy rows of data from one sheet to another if a given range of cells match a ...
0
votes
0answers
244 views
XL2003: Changing ThisWorkbook.Windows().Visible property during Workbook_BeforeClose event prevents workbook from closing
As title. This is driving me mad and I can't find any reference to it anywhere else on the web.
I have a VBA-laden workbook which is normally hidden through use of:
ThisWorkbook.Windows(1).Visible ...
0
votes
0answers
161 views
VBA: Error 48 error loading dll
Below line of mine throws error 'runtime error 48 error in loading dll vba' in VBA,
Dim app As New Excel.Application
Set app = New Excel.Application
I`m using Excel 2003,recently i changed 2010 to ...
