Tagged Questions
0
votes
1answer
24 views
Comment vba code from another VBA CODE
I would like to comment the lines who contains Msg Box from another code VBA. I'm trying this with the Library VBA EXTENSIBILITY but i doesn't found the solution.
Any help is welcome.
This is my ...
0
votes
2answers
29 views
Excel 2007 vba if statement fill cell colour based on precious cell colour
please help me, i have no idea how to work with colours in vba coding. am gonna try and explain this as simple as i can.
i have cells from D3 to AH564 that has no values in them and never will. if ...
4
votes
2answers
101 views
Unprotect VBProject from VB code
How can i unprotect my VB project from a vb macro ?
i have found this code:
Sub UnprotectVBProject(ByRef WB As Workbook, ByVal Password As String)
Dim VBProj As Object
Set VBProj = ...
0
votes
1answer
33 views
Application defined error while copying a range of cells from a workbook to the workbook i have created in the code
I got the error at the starred lines. I have browsed a lot I found many answers i copied the same but still am getting this error . I am not sure of what wrong i am doing.
Please help. Thanks in ...
1
vote
1answer
31 views
EXCEL - Error while opening excel workbook
I have Office 2007.
Each time I launch Excel, or open an existing file, it tries to access some old file and I get the following error pop up:
'E:\xyz.txt' could not be found. Check the spelling of ...
1
vote
1answer
45 views
How to rename range using VBA in excel 2007
I've 8+ yes professional programming experience in PHP and Java but none in VBA. Learning it right now.
I'm trying to make a Home budget sheet (Just for VBA learning purpose). For that, I'd done ...
0
votes
0answers
38 views
Exporting PDF in multiple sheets with different Print Area Range
I like to export 2 sheets of my file somewhere in the procedure as PDF and i am using the below code i obtain from macro recorder but i get export only the page properties of my 1st sheet, 2nd page is ...
1
vote
1answer
123 views
Excel VBA: How to enable mouse wheel scrolling in combobox/listbox?
I am building a userform in Excel 2007 using VBA and would like to know how to enable mousewheel scrolling of comboboxes and listboxes. Do I need a more recent version of Office to get this feature or ...
-1
votes
0answers
41 views
Excel 2007 crash when opening sheet while Excel is opened using Automation - Windows 7 [closed]
I have written macro in ER/S that creates Diff Report between two DB models. Macro is written in Sax Basic v6 (derivation of VB6) and the report is created in Excel.
I open the Excel like this:
...
-2
votes
1answer
44 views
To make entire row mandatory to fill if one cell of that row is filled
For ms Excel 2007.
I want the user to fill all cells in a row IF any one cell of that row is filled.
I am using ms-Excel 2007.
0
votes
1answer
19 views
Access to worksheet where the macro belongs
I want to access a worksheet where the macro belongs. To do that, I'm using this code snippet.
Is there another way to do it without using the name of this file?
Workbooks("file.xlsm").Activate
Dim ...
2
votes
0answers
32 views
VBA On.Time() Background Check in Combination with regular Usage
I am currently experiencing an Issue with the On.Time() Command.
The Ontime offsetvalue is set to 00:00:10 checking if Files are open. (Sort of a realtime checker).
Sub MacroAutoRun1()
Dim ...
0
votes
2answers
38 views
Efficient data cleaning - MsExcel 2007
I have Ms Excel spreadsheet with 2400 companies.
It now looks like -
Autumn Ridge Golf Course, Inc.
11420 Auburn Road
Fort Wayne, IN 46845
(260) 637-8727
All Occasion Party Rental
4620 Speedway ...
0
votes
0answers
45 views
Why does my macro give an automation error?
When I run the macro the first time it works, but when I reopen the workbook it crashes with an automation error. During debuging it points to the following:
ThisWorkbook.Sheets(curSheetNum).Copy ...
0
votes
1answer
24 views
Filling the HttpResponce csv data in excel - VBA
In my case i'm calling the HttpRequest to get the result `result = winHttpReq.responseText` .result is actually a string.I'm getting the result as a comma separated format string while the woorkbook ...
