Write data in closed workbook through user form.

**AmirSoft** · 12-23-2014, 03:01 AM

Hi. I am new in vb and I am trying to make a user form which may help me to write data in a closed workbook available in my system drive.
I tried this code.

Please Login or Register  to view this content.

But not working.

Please help me to sort out this problem.
I observed that there are many experts in Excel Forum, and I think you all are able to do this.
So I request you please give me a simple code to enter data in closed workbook if possible.

If you have any sample of this then please attach here or my email amiritait@gmail.com.

I shall be very thankful to you for your help.

**MarvinP** · 12-23-2014, 03:11 AM

http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

Read the above site.

**AmirSoft** · 12-23-2014, 03:26 AM

Thanks for reply.
In above link they mentioned the way to get data from closed workbook. I want to write data in closed workbook.

Please guide me about this

**AmirSoft** · 12-23-2014, 03:36 AM

Thanks for reply.
In above link they mentioned the way to get data from closed workbook. I want to write data in closed workbook.

Please guide me about this

**sktneer** · 12-23-2014, 03:43 AM

You may try something like this to see if this works for you.

Please Login or Register  to view this content.

**AmirSoft** · 12-23-2014, 04:02 AM

Thanks
This work, But It Open that file.
I want file remain close, is it possible
if not then open that file and close it after save automatically.

Please send code

**sktneer** · 12-23-2014, 04:12 AM

Try this......

Please Login or Register  to view this content.

**AmirSoft** · 12-23-2014, 04:20 AM

YOU WORK GREAT

THANK YOU SO MUCH.

can we count the rows of single column and enter data in next columns
because when i expand the range then it always enter the data in first row of new column.

**sktneer** · 12-23-2014, 08:26 AM

Hi Amir,

Here is the modified code....

Please Login or Register  to view this content.

Write data in closed workbook through user form.

LinkBack

Thread Tools

Rate This Thread

Display

Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Re: Write data in closed workbook through user form.

Thread Information

Users Browsing this Thread

Similar Threads

VB Write User Form Data to Excel

Write data to a closed workbook

write data to a closed workbook

User form don't write if no data is entered

How to Read/Write Data to/from a closed workbook

Bookmarks

Bookmarks

Posting Permissions