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

I just restored my ps3 and something appeared to me it says: registration of the trophy information could not be completed the game will quit I have tried every way to solve this it has a code which is...


  • Delete the PS3 system user profile that is associated with your Sony Entertainment Network account by going to Users and highlighting the user you want to delete. Press the Triangle button and select "[Delete] to delete the user. Please note that there is no need to delete your Sony Entertainment Network account.
  • Create a new PS3 system user by going to Users > [Create New User] on the XMB Menu.
  • Sign in to PlayStation Network from the new user profile to sync your trophies.
  • For more tips and hints on using your PlayStation system, visit our technical support forums at community.eu.playstation.com.

Nov 23, 2013 | Video Game Consoles & Games

1 Answer

My Fossil Fighters Champions game is corrupt. It will not load data, create data, save data, or delete data. How can I fix it?


Unfortunately, you are going to have to delete all the files for the game off the console and start over.

Jun 19, 2012 | Video Game Consoles & Games

1 Answer

How do you reset high scores


All Wii games and Wii Channels that create a save file (such as for game progress, high scores, channel settings) that can be deleted or copied.
    To delete save game data
  1. Access the Wii Data Management screen (how to).
  2. Select the "Save Data" icon to display all save files.
  3. Select the file you want to delete.
  4. Select "Erase" to delete the file.
  5. Warning: If a game save file is deleted, there is no way to get it back. Be sure you want to delete it, or even copy it to an SD Card if necessary.

Feb 14, 2010 | Nintendo Wii Console

1 Answer

Nba hangtime for n64 wont save my created player.


You might need a memory card. Some games need one for N64 and some don't. It may also save on the game and sometimes it just glitches out because it's old. I know that my super nintendo used to delete files without doing anything because the game was damn old.

Jul 13, 2009 | Nintendo 64 Console

2 Answers

Parental Control password reset for PS2


At the screen prompting you to input the password, enter the digits 7444. The previous password will be deleted, allowing you to create a new one or you can leave it blank.

Jun 10, 2009 | Sony PlayStation 2 (PS2) Console

1 Answer

Data transfer


Basically you need an SD card.

Located in the "Save Data" section of the "Data Management" area of the Wii Settings Save Data are the files created when you save a game's progress (such as high scores, items found, and where the game last saved), as well as data for certain Wii Channels

This data is stored in this section separately from the Wii Channel data, and can be kept, copied, or deleted independently of the Wii Channel it is used for.

Copy the Save Data to an SD Card, then delete it from the Wii
Most Save Data, including Virtual Console or WiiWare save files, can be copied to a compatible SD Card. This gives you the ability to delete that data, then copy it back over from the SD Card to your Wii should you wish to get it back at a later time. (Be sure to copy the data back over to the Wii when you wish to use it again; simply having the SD Card inserted with the data on it will not allow it to be used.)

Jul 09, 2008 | Nintendo Wii Console

1 Answer

My daughter's fisher price easy link internet launch pad will not start up i recieve a message setup had detected that version 1.02.000 is already installed this setup installs an ealrier version of...


I had a similar issue. Check and see if you have 2 Fisher-Price file folders under C:\Program Files. Go to My Coputer, then c drive, then program files. You should see only 1 Fisher Price folder. If you see another with Fisher-Price(2), Open that folder and select all of the files. Then select cut. Paste those files in the original Fisher-Price Folder and that should get you up and going. That is what I had to do to get mine to work again. I don't know how that second folder got created but it did.
Hope this works for you

Jul 09, 2008 | Video Game Consoles & Games

2 Answers

N Card for Nintendo DS


I don't see any support on Nintendos website for an N-Card. It might be a product that isn't used in the United States.

You should contact Nintendo directly by phone to see if you can get support on it.

Jun 12, 2008 | Nintendo DS Lite Console

2 Answers

Corrupted file


do u have custom firmware on ur psp. the only wy u can play downloaded iso/cso files are with custom firmware.

May 16, 2008 | Sony PlayStation Portable (PSP) Console

2 Answers

DS DELETING FILES?!?!?!?


Yo!
what file are you reffering to ? where you input details like trainer name etc.?
well if you are when you turn the console on with the cartridge in it on the bottom of the screen you will see two rectangular boxes with smaller darker rectangles inside Once you press on this it will allow you to edit details
hope this helps. let me know how you get on, ok
Niki

Apr 01, 2008 | Nintendo DS Console

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

Troy Gorman
Troy Gorman

Level 3 Expert

508 Answers

Jonathon summesfield

Level 2 Expert

284 Answers

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

Answer questions

Manuals & User Guides

Loading...