Question about Sony Playstation 3 (PS3) Console

2 Answers

Delete blank rows in excel using visual basic

I need to create an exe file in visual basic which will take input as excel file and and delete its blank rows and shows the output as the formatted excel sheet.

i can delete the blank rows through macro but that code is not working in VB.

The error is 'activex','selection','application' are not defined.

what to do? please help. its very urgent.

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 46 Answers

Assuming you have code such as createobject() then it sounds like you may not have added the reference for Excel. The menu for "Reference" depends on your version of VB. In VB 2008:

  1. click the Project menu
  2. click Add reference
  3. In the COM tab find the one for Microsoft Excel Object Library
  4. OK
Now try again.
In VB6 I think it's ion the tools menu. There is no COM tab in VB6. But otherwise the same.

Posted on Aug 28, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 78 Answers

Have you tried to read in one file and write back in excel format only the non-blank rows?

Posted on Mar 29, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to delet empty rows in excel


I am assuming you are using Office version 2003 or newer.
Towards the left border of the sheet there are row numbers; Left click on any number selects the entire row.
Once selected, right click on the row number or anywhere on the selected row and delete from the menu.

To select multiple rows:
1. Hold down the left mouse button and drag till you reach the desired end row. (row selection to be done by clicking on row numbers and not the actual rows)
2. Select a cell (left click), then the combination ctrl+shift+rightArrow. This will select the entire row (only if it is empty). Now use shift+downArrow to select one row at a time or ctrl+shift+downArrow to select all adjacent blank/non-blank rows.

If row number are not visible:
In Office 2007 goto "View" tab. Select "Headings" from the "Show/Hide" group. In other Office versions, use the menu navigation to reach this point.

Jul 11, 2014 | Microsoft Office Computers & Internet

1 Answer

My program file regsvr.exe delete.How restore this


Dear Amartya,

Here is a solution for your problem.




What the regsvr.exe virus does?
• This worm creates folders and a registry entry to enable its automatic execution at every system startup.
• This worm also creates a scheduled task to enable its automatic execution at a specified date and/or time.
• It also creates Autorun.inf file for its auto execution.
Solution to fix the problem:
1. If the task manager and registry editor is disabled then we need to enable them first. Read this post.
2. Delete the Autorun.inf file created by the virus. Read this post to know how to do that.
3. Now type msconfig in the Run dialog and click on startup tab.
4. Look for regsvr and uncheck any options, click OK.
5. Now traverse to control panel -> scheduled tasks, and delete the At1 task that might be listed there.
6. Type regedit in the Run dialog to open the registry editor.
7. Click on Edit -> Find and search for regsvr.exe
8. Just delete all the occurrences of regsvr.exe virus (do not confuse it with regsvr32.exe which is not a virus).
9. Navigate to entry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon and modify the entry Shell = "Explorer.exe regsvr.exe" to delete the regsvr.exe from it.


I think it helps.Let me know


Best regards
Chandrashekahr Bhat

Dec 25, 2010 | Microsoft Windows XP Professional

1 Answer

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.


Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

  1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
  2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
  3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
  4. Then, press Alt+Q to close the Visual Basic Editor window.
  5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
  6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

1 Answer

How to remove the parasite variant cftmon32 .exe and Ati hot key poller in system32.. HJT v 2.0.0.2 fixes them but they return after 2 or less subsequent scans. Ati hot key poller in system32. always...


cftmon32.exe is a malicious code created to change security processes and registry files and execute different malicious behavior on your computer. Once installed on the PC, cftmon32.exe may automatically carry out mischievous payloads at system start up by creating entries in registry. cftmon32.exe my compromise your privacy and slash computer security.
Follow the given steps for removing virus
1. Temporarily Disable System Restore, Reboot computer in SafeMode
2. Locate CFTMON32.EXE virus files and uninstall CFTMON32.EXE files program. Follow the screen step-by-step screen instructions to complete uninstallation of CFTMON32.EXE.
3. Delete/Modify any values added to the registry related with CFTMON32.EXE,Exit registry editor and restart the computer
4.Clean/delete all CFTMON32.EXEinfected file(s):CFTMON32.EXE and related,or rename CFTMON32.EXE virus files
5.Please delete all your IE temp files with CFTMON32.EXE manually,run a whole scan with antivirus program

Aug 19, 2010 | Microsoft Windows XP Home Edition Service...

1 Answer

I cannot load some programmes. I get an error 429 activex component message., Is there a free vista available to run over the top to fix any or all problems i might have on my system


cause : This issue can occur when DAO dynamic-link library (DLL) files are mismatched or when there are incorrect registry entries. This issue can also occur when there is a missing DAO design-time licensing key. This key is required by Microsoft Excel, but is not required by applications created with Visual Basic

Method 1 loadTOCNode(2, 'resolution');
  1. Click Start, and then click Run.
  2. In the Open box, type regsvr.exe.
  3. Re-register DAO350.dll.

    NOTE: You can obtain a copy of DAO350.dll at the following FTP address: ftp://ftp.microsoft.com/softlib/mslfiles/ To register DAO350.dll, follow these steps:

    1. Click Start, and then click Run.
    2. In the Open box, type Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
    3. Click OK.
  4. Click Start, point to Settings, and then click Control Panel.
  5. Click Add/Remove Programs.
  6. Insert your Microsoft Office 97 CD, and then click Uninstall.
  7. Delete the DAO folder from the hard drive.
  8. Click Start, point to Settings, and then click Control Panel.
  9. Click Add/Remove Programs.
  10. Insert your Office 97 CD, and then click Install.
  11. Repeat steps 4 through 6 to uninstall Office 97.
  12. Click Start, and then click Run.
  13. In the Open box, type eraser97.exe. (This file is also available at ftp://ftp.microsoft.com/softlib/mslfiles/.)
  14. Repeat steps 4 through 6.
  15. Repeat steps 8 through 10 to reinstall Office 97.
Please Rate Solution!

Sep 08, 2009 | Computers & Internet

2 Answers

Can u tel me how to create a setup.exe in Visual basic


hi,
the process of getting a single 'setup' file is known as 'software packaging'. There are certain software which can do this for you. (no need to crack your head)

http://www.iterating.com/productclasses/Software-Packaging/products

thanks.

Jun 08, 2009 | Microsoft Visual Basic 6.0 (361-00686) for...

2 Answers

When I open computer a message displayed cannot find regsvr.exe


Hi there.
You have a virus on the PC!!

What the regsvr.exe virus does?
• This worm creates folders and a registry entry to enable its automatic execution at every system startup.
• This worm also creates a scheduled task to enable its automatic execution at a specified date and/or time.
• It also creates Autorun.inf file for its auto execution.
Solution to fix the problem:
1. If the task manager and registry editor is disabled then we need to enable them first. Read this post.
2. Delete the Autorun.inf file created by the virus. First go to cmd (start menu, run or search, type “attrib X:Autorun.inf –s –r –h” without quotes where X is your drive name which is having the problem. Now the file is visible and ready to delete. After deleting the file, close the explorer and open it again
3. Now type msconfig in the Run dialog and click on startup tab.
4. Look for regsvr and uncheck any options, click OK.
5. Now traverse to control panel -> scheduled tasks, and delete the At1 task that might be listed there.
6. Type regedit in the Run dialog to open the registry editor.
7. Click on Edit -> Find and search for regsvr.exe
8. Just delete all the occurrences of regsvr.exe virus (do not confuse it with regsvr32.exe which is not a virus).
9. Navigate to entry HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionWinlogon and modify the entry Shell = “Explorer.exe regsvr.exe” to delete the regsvr.exe from it.
shell_regsvr.jpg10. Now to actually delete the virus from the system go to system32 folder and delete the regsvr.exe virus file from there (you will need to uncheck the option of “Hide Protected System Files and Folders” in Folder Options to view the virus file).
Reboot the system for changes to take place.
If this is too much for you to understand please post back for an alternative.

Good luck

May 27, 2009 | Microsoft Windows XP Professional

1 Answer

How to delete the nulls cells?


Try create a new Workbook (file) and then copy only the 10x200 cells from the NULL'ly spreadsheet. Unless you have macros in the nully one, it should be resolved by copying the needed cells to blank new file.

Apr 17, 2009 | Microsoft Computers & Internet

1 Answer

Exe file created not running on other pc.


Hello narensg

In order to be able to run a program (EXE) in a computer, that computer must have Visual Basic RUNTIME MODULES.

please tell your friend to install this runtime modules:
http://download.microsoft.com/download/vb60pro/install/6/win98me/en-us/vbrun60.exe

after installing this package, he will be able to run your program.

Kind regards,
Jerry H.

Feb 25, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

How to connect my database to my project?


use Excel library at following location.

D:\Program Files\Microsoft Office\Office12\EXCEL.EXE
Microsoft Excel 12.0 Object Library

Jan 05, 2009 | Microsoft Office Standard for PC

Not finding what you are looking for?
Sony Playstation 3 (PS3) Console Logo

206 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sony Video Game Consoles & Games Experts

Iron
Iron

Level 3 Expert

3018 Answers

shaun taylor

Level 3 Expert

1450 Answers

marley mcelhinney

Level 3 Expert

490 Answers

Are you a Sony Video Game Console and Game Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...