Results 1 to 2 of 2
  1. #1

    Default Problem Importing from Excel to Word


    Maayong adlaw sa tanan, nagka problema ko sa akong Excel/Word VBA codes, please help me, d ko expert sa Excel ako ra ni gi-follow ang document nga gi-pasa sa akong kauban nko unya d na mi ron officemate.

    Akong Excel(2010) nag run ug macro nga i-import to Word(2010) ang problema kay ang ubang tables nga ma import sa Word mo jump sa next nga page. Not sure though asa ang error, sa Excel or Word, I think sa Word kay ma import man ang mga data. Mao ni ang code:

    Selection.HomeKey Unit:=wdLine
    Selection.MoveDown Unit:=wdLine, Count:=2
    Selection.Tables(1).Select (mao ni ang highlight sa error)
    Selection.Font.Name = "Times New Roman"
    Selection.Font.Size = 12
    Selection.MoveDown Unit:=wdLine, Count:=2
    Selection.HomeKey Unit:=wdLine
    Selection.Tables(1).Select
    Selection.Font.Name = "Times New Roman"
    Selection.Font.Size = 12
    Selection.MoveDown Unit:=wdLine, Count:=2
    Selection.HomeKey Unit:=wdLine
    Selection.Tables(1).Select
    Selection.Font.Name = "Times New Roman"
    Selection.Font.Size = 12
    Selection.MoveDown Unit:=wdLine, Count:=2
    Selection.HomeKey Unit:=wdLine
    Selection.Tables(1).Select
    Selection.Font.Name = "Times New Roman"
    Selection.Font.Size = 12
    Selection.MoveDown Unit:=wdLine, Count:=2
    Selection.HomeKey Unit:=wdLine
    Selection.Tables(1).Select
    Selection.Font.Name = "Times New Roman"
    Selection.Font.Size = 12
    ActiveWindow.ActivePane.SmallScroll Down:=4
    Hours free/days
    Selection.MoveUp Unit:=wdLine, Count:=15
    Selection.HomeKey Unit:=wdLine
    Selection.MoveRight Unit:=wdCharacter, Count:=6, Extend:=wdExtend
    Selection.Rows.HeightRule = wdRowHeightAtLeast
    Selection.Rows.Height = CentimetersToPoints(0.75)

  2. #2
    Selection.Tables(1).Select (mao ni ang highlight sa error)

    i think if sheet1 to imong excel. it should start tables(0) or
    I think it should be (Sheet) or
    try tables(sheetName)

  3.    Advertisement

Similar Threads

 
  1. Problem Importing from Excel to Word
    By Alexis_001 in forum Computer Hardware
    Replies: 4
    Last Post: 03-28-2014, 11:30 PM
  2. application mo convert pdf to (word,excel, etc.)
    By misterbot in forum Windows Software
    Replies: 7
    Last Post: 11-27-2013, 09:45 PM
  3. For Sale: We want to sale Surplus fashionable RTW , Import from Japan
    By RokHam Ent in forum Clothing & Accessories
    Replies: 1
    Last Post: 02-01-2012, 10:42 AM
  4. from scanner to word processor.. pwede?
    By pal in forum Software & Games (Old)
    Replies: 12
    Last Post: 05-25-2007, 01:42 PM
  5. P4Vmm2 Changing from SDram to DDram Problem
    By Chipmunk888 in forum Computer Hardware
    Replies: 26
    Last Post: 02-23-2006, 12:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
about us
We are the first Cebu Online Media.

iSTORYA.NET is Cebu's Biggest, Southern Philippines' Most Active, and the Philippines' Strongest Online Community!
follow us
#top